ALTER TABLE `sales` ADD `reference_id` VARCHAR(100) NOT NULL AFTER `id`, ADD `departure_date` DATE NOT NULL AFTER `reference_id`, ADD `return_date` DATE NULL AFTER `departure_date`, ADD `adult` TINYINT(3) NOT NULL AFTER `return_date`, ADD `children` TINYINT(3) NOT NULL AFTER `adult`, ADD `infant` TINYINT(3) NOT NULL AFTER `children`, ADD `booking_date` DATETIME NOT NULL AFTER `infant`, ADD `payment_charges_fix_amount` INT(10) NOT NULL AFTER `booking_date`, ADD `payment_charges_in_percentage` INT(10) NOT NULL AFTER `payment_charges_fix_amount`, ADD `departure_time` VARCHAR(20) NOT NULL AFTER `payment_charges_in_percentage`, ADD `booking_status` TINYINT(3) NOT NULL AFTER `departure_time`, ADD `flight_number` VARCHAR(20) NOT NULL AFTER `booking_status`, ADD `return_flight` TINYINT(3) NOT NULL AFTER `flight_number`, ADD `trip_duration` TINYINT(3) NOT NULL AFTER `return_flight`, ADD `pnr_number` VARCHAR(20) NOT NULL AFTER `trip_duration`, ADD `departure_city_code` VARCHAR(10) NOT NULL AFTER `pnr_number`, ADD `arrical_city_code` VARCHAR(10) NOT NULL AFTER `departure_city_code`, ADD `seller_company` VARCHAR(100) NOT NULL AFTER `arrical_city_code`, ADD `seller_email` VARCHAR(100) NOT NULL AFTER `seller_company`, ADD `seller_mobile` VARCHAR(15) NOT NULL AFTER `seller_email`, ADD `airline_code` VARCHAR(10) NOT NULL AFTER `seller_mobile`, ADD `pax` JSON NOT NULL AFTER `airline_code`, ADD `payment_mode` VARCHAR(30) NOT NULL AFTER `sold_from`, ADD `transaction_id` VARCHAR(50) NULL AFTER `payment_mode`, ADD `purchase_price` INT(10) NOT NULL AFTER `amount`, ADD `inv_buyer_name` VARCHAR(100) NOT NULL AFTER `purchase_price`, ADD `web_buyer_name` VARCHAR(100) NOT NULL AFTER `inv_buyer_name`, ADD `inv_buyer_email` VARCHAR(100) NOT NULL AFTER `web_buyer_name`, ADD `web_buyer_email` VARCHAR(100) NOT NULL AFTER `inv_buyer_email`, ADD `inv_buyer_mobile` VARCHAR(100) NOT NULL AFTER `web_buyer_email`, ADD `web_buyer_mobile` VARCHAR(100) NOT NULL AFTER `inv_buyer_mobile`, ADD `inv_sold_from` VARCHAR(50) NOT NULL AFTER `web_buyer_mobile`, ADD `web_sold_from` VARCHAR(50) NOT NULL AFTER `inv_sold_from`, ADD `inv_amount` INT(10) NOT NULL AFTER `web_sold_from`, ADD `web_amount` INT(10) NOT NULL AFTER `inv_amount`, ADD `inv_user_id` INT(10) NOT NULL AFTER `reference_id`, ADD `web_user_id` INT(10) NOT NULL AFTER `inv_user_id`, ADD `re_flight_number` VARCHAR(20) NULL AFTER `return_flight`, ADD `flight_id` INT(10) NOT NULL AFTER `reference_id`, ADD `airline_id` INT(10) NOT NULL AFTER `flight_id`;