/// FLIGHT BOOKING DETAILS ALTER TABLE `flight_booking_details` ADD `ssr_bag_desc` VARCHAR(100) NULL AFTER `passport_expire_date`, ADD `ssr_bag_amt` INT(10) NULL AFTER `ssr_bag_desc`, ADD `ssr_meal_desc` VARCHAR(100) NULL AFTER `ssr_bag_amt`, ADD `ssr_meal_amt` INT(10) NULL AFTER `ssr_meal_desc`, ADD `ssr_seat_desc` VARCHAR(100) NULL AFTER `ssr_meal_amt`, ADD `ssr_seat_amt` INT(10) NULL AFTER `ssr_seat_desc`, ADD `ssr_spl_desc` VARCHAR(100) NULL AFTER `ssr_seat_amt`, ADD `ssr_spl_amt` INT(10) NULL AFTER `ssr_spl_desc`; /// BOOKING TOKENS WEB ALTER TABLE `booking_tokens_web` CHANGE `search_req` `search_req` JSON NULL DEFAULT NULL, CHANGE `search_res` `search_res` JSON NULL DEFAULT NULL, CHANGE `search_res_our` `search_res_our` JSON NULL DEFAULT NULL, CHANGE `fare_rule_req` `fare_rule_req` JSON NULL DEFAULT NULL, CHANGE `fare_rule_res` `fare_rule_res` JSON NULL DEFAULT NULL, CHANGE `fare_rule_our` `fare_rule_our` JSON NULL DEFAULT NULL, CHANGE `price_check_req` `price_check_req` JSON NULL DEFAULT NULL, CHANGE `price_check_res` `price_check_res` JSON NULL DEFAULT NULL, CHANGE `price_check_req_our` `price_check_req_our` JSON NULL DEFAULT NULL, CHANGE `price_check_res_our` `price_check_res_our` JSON NULL DEFAULT NULL; /// FIT PRICE CHECK ALTER TABLE `fit_price_check` ADD `req` JSON NOT NULL AFTER `id`, ADD `res` JSON NOT NULL AFTER `req`, ADD `req_our` JSON NOT NULL AFTER `res`, ADD `res_our` JSON NOT NULL AFTER `req_our`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `res_our`; ALTER TABLE `fit_price_check` ADD `token_id` VARCHAR(100) NOT NULL AFTER `id` /// FIT SSR ALTER TABLE `fit_ssr` ADD `req` JSON NOT NULL AFTER `id`, ADD `res` JSON NOT NULL AFTER `req`, ADD `req_our` JSON NOT NULL AFTER `res`, ADD `res_our` JSON NOT NULL AFTER `req_our`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `res_our`; ALTER TABLE `fit_ssr` ADD `token_id` VARCHAR(100) NOT NULL AFTER `id`