ALTER TABLE `tbl_flight_booking` ADD `IsPassExpiry` TINYINT NOT NULL DEFAULT '0' AFTER `couponexpiryDate`, ADD `IsPassIssue` TINYINT NOT NULL DEFAULT '0' AFTER `IsPassExpiry`, ADD `isGSTMandatory` TINYINT NOT NULL DEFAULT '0' AFTER `IsPassIssue`, ADD `isDobAdult` TINYINT NOT NULL DEFAULT '0' AFTER `isGSTMandatory`, ADD `isDobChild` TINYINT NOT NULL DEFAULT '0' AFTER `isDobAdult`;

ALTER TABLE `tbl_flight_booking` ADD `isDobInfant` TINYINT NOT NULL DEFAULT '0' AFTER `isDobChild`;

ALTER TABLE `tbl_flight_booking_farebreakdown` ADD `TotalFare` FLOAT NOT NULL AFTER `OfferedFare`;

ALTER TABLE `tbl_flight_customer` ADD `SelectedBag` VARCHAR(300) NULL DEFAULT NULL AFTER `SeatPrice`, ADD `SelectedMeal` VARCHAR(300) NULL DEFAULT NULL AFTER `SelectedBag`;


ALTER TABLE `tbl_flight_customer` CHANGE `SelectedBag` `SelectedBag` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `SelectedMeal` `SelectedMeal` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;



ALTER TABLE `tbl_flight_segment` ADD `BagPrice` FLOAT NOT NULL DEFAULT '0' AFTER `TravelDate`, ADD `MealPrice` FLOAT NOT NULL DEFAULT '0' AFTER `BagPrice`, ADD `SeatPrice` FLOAT NOT NULL DEFAULT '0' AFTER `MealPrice`;