-- Migration script for TAXITUR.NO database enhancements

-- 1. Ensure vbs_users has all document pack and bank fields
ALTER TABLE `vbs_users` 
  ADD COLUMN IF NOT EXISTS `license_front` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `license_back` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `driver_ticket` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `driver_card` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `avinor_card` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `isps_course` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `company_certificate` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `insurance_liability` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `permit_number` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `bank_name` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `account_number` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `iban` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `swift` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `contact_person` VARCHAR(255) NULL;

-- 2. Ensure vbs_vehicles has plate photo & reg number verification fields
ALTER TABLE `vbs_vehicles` 
  ADD COLUMN IF NOT EXISTS `plate_photo` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `reg_number` VARCHAR(100) NULL;

-- 3. Ensure vbs_corporate_customers has contact_person, customer_number, and discount_percent fields
ALTER TABLE `vbs_corporate_customers` 
  ADD COLUMN IF NOT EXISTS `contact_person` VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS `customer_number` VARCHAR(50) NULL,
  ADD COLUMN IF NOT EXISTS `discount_percent` DECIMAL(5,2) NOT NULL DEFAULT 0.00;


-- 4. Ensure vbs_bookings has assigned driver & tracking fields
ALTER TABLE `vbs_bookings` 
  ADD COLUMN IF NOT EXISTS `driver_id` INT(11) NULL DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS `driver_lat` VARCHAR(50) NULL,
  ADD COLUMN IF NOT EXISTS `driver_lng` VARCHAR(50) NULL,
  ADD COLUMN IF NOT EXISTS `booking_status` VARCHAR(50) NULL DEFAULT 'pending';
