USE cement_management;

-- Add driver_name column to diesel_purchases table if it doesn't exist
ALTER TABLE diesel_purchases 
ADD COLUMN driver_name VARCHAR(255) NULL 
AFTER vehicle_id;

-- Show the table structure to verify
DESCRIBE diesel_purchases;
