-- Add driver photo column for profile pictures
ALTER TABLE drivers ADD COLUMN driver_photo VARCHAR(255) DEFAULT NULL COMMENT 'Relative path to driver profile picture (e.g., uploads/drivers/abc.jpg)';

-- Index for photo queries (optional, partial)
CREATE INDEX IF NOT EXISTS idx_drivers_photo ON drivers(driver_photo(50));