-- Production Migration Script for TAXITUR (vbs_users document compliance columns)
-- Run this script in phpMyAdmin or MySQL Workbench on your production database

ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `driver_card_front` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `driver_card_back` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `driver_ticket_front` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `driver_ticket_back` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `vehicle_registration` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `insurance_certificate` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `isps_course` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `avinor_pass` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `police_certificate` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `verification_status` VARCHAR(50) DEFAULT 'pending';
ALTER TABLE `vbs_users` ADD COLUMN IF NOT EXISTS `verification_note` TEXT NULL;
