-- ====================================================================
-- Production Database Migration Script for TAXITUR.NO Platform
-- Safe for execution on any MySQL / MariaDB version.
-- ====================================================================

-- 1. User & Driver profile enhancements
ALTER TABLE `vbs_users` ADD COLUMN `license_front` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `license_back` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `driver_ticket` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `driver_card` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `avinor_card` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `isps_course` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `company_certificate` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `insurance_liability` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `permit_number` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `bank_name` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `account_number` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `iban` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `swift` VARCHAR(255) NULL;
ALTER TABLE `vbs_users` ADD COLUMN `contact_person` VARCHAR(255) NULL;

-- 2. Corporate Customer enhancements
ALTER TABLE `vbs_corporate_customers` ADD COLUMN `contact_person` VARCHAR(255) NULL;
ALTER TABLE `vbs_corporate_customers` ADD COLUMN `customer_number` VARCHAR(50) NULL;
ALTER TABLE `vbs_corporate_customers` ADD COLUMN `discount_percent` DECIMAL(5,2) NOT NULL DEFAULT 0.00;

-- 3. Bookings & Live Map Tracking enhancements
ALTER TABLE `vbs_bookings` ADD COLUMN `driver_id` INT(11) NULL DEFAULT NULL;
ALTER TABLE `vbs_bookings` ADD COLUMN `corporate_id` INT(11) NULL DEFAULT NULL;
ALTER TABLE `vbs_bookings` ADD COLUMN `driver_lat` VARCHAR(50) NULL;
ALTER TABLE `vbs_bookings` ADD COLUMN `driver_lng` VARCHAR(50) NULL;
ALTER TABLE `vbs_bookings` ADD COLUMN `booking_status` VARCHAR(50) NULL DEFAULT 'pending';

-- 4. Modify payment_type column to support all payment types cleanly
ALTER TABLE `vbs_bookings` MODIFY COLUMN `payment_type` VARCHAR(50) NOT NULL DEFAULT 'cash';

-- 5. Performance Indexes for Production
ALTER TABLE `vbs_bookings` ADD INDEX `idx_bookings_ref` (`booking_ref`);
ALTER TABLE `vbs_bookings` ADD INDEX `idx_bookings_driver` (`driver_id`);
ALTER TABLE `vbs_bookings` ADD INDEX `idx_bookings_corp` (`corporate_id`);
ALTER TABLE `vbs_bookings` ADD INDEX `idx_bookings_user` (`user_id`);
ALTER TABLE `vbs_bookings` ADD INDEX `idx_bookings_status` (`is_conformed`);
ALTER TABLE `vbs_corporate_customers` ADD INDEX `idx_corp_cust_num` (`customer_number`);

-- End of Production Migration
