/// fit_groups ALTER TABLE `fit_groups` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `name` VARCHAR(200) NOT NULL AFTER `user_id`, ADD `type` TINYINT(2) NOT NULL COMMENT '0: no default; 1: b2b; 2: b2c' AFTER `name`, ADD `status` TINYINT(2) NOT NULL DEFAULT '1' AFTER `type`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`; /// fit_margins ALTER TABLE `fit_margins` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `supplier_id` BIGINT NOT NULL AFTER `user_id`, ADD `group_id` BIGINT NOT NULL AFTER `supplier_id`, ADD `name` VARCHAR(100) NOT NULL AFTER `group_id` ADD `airline` VARCHAR(255) NOT NULL COMMENT 'airline_codes' AFTER `name`, ADD `cabin_class` VARCHAR(255) NOT NULL COMMENT 'cabin type' AFTER `airline`, ADD `booking_class` VARCHAR(255) NOT NULL COMMENT 'booking_class_code' AFTER `cabin_class`, ADD `fare_from` INT NOT NULL DEFAULT '0' AFTER `booking_class`, ADD `fare_to` INT NOT NULL DEFAULT '0' AFTER `fare_from`, ADD `hbf_per` INT NOT NULL DEFAULT '0' AFTER `fare_to`, ADD `hbf_min` INT NOT NULL DEFAULT '0' AFTER `hbf_per`, ADD `hbf_max` INT NOT NULL DEFAULT '0' AFTER `hbf_min`, ADD `hbf_inf` INT NOT NULL DEFAULT '0' AFTER `hbf_max`, ADD `hft_per` INT NOT NULL DEFAULT '0' AFTER `hbf_inf`, ADD `hft_min` INT NOT NULL DEFAULT '0' AFTER `hft_per`, ADD `hft_max` INT NOT NULL DEFAULT '0' AFTER `hft_min`, ADD `hft_inf` INT NOT NULL DEFAULT '0' AFTER `hft_max`, ADD `dis_per` INT NOT NULL DEFAULT '0' AFTER `hft_inf`, ADD `dis_min` INT NOT NULL DEFAULT '0' AFTER `dis_per`, ADD `dis_max` INT NOT NULL DEFAULT '0' AFTER `dis_min`, ADD `dis_inf` INT NOT NULL DEFAULT '0' AFTER `dis_max`, ADD `imm_per` INT NOT NULL DEFAULT '0' AFTER `dis_inf`, ADD `imm_min` INT NOT NULL DEFAULT '0' AFTER `imm_per`, ADD `imm_max` INT NOT NULL DEFAULT '0' AFTER `imm_min`, ADD `imm_inf` INT NOT NULL DEFAULT '0' AFTER `imm_max`, ADD `pb_per` INT NOT NULL DEFAULT '0' AFTER `imm_inf`, ADD `pb_min` INT NOT NULL DEFAULT '0' AFTER `pb_per`, ADD `pb_max` INT NOT NULL DEFAULT '0' AFTER `pb_min`, ADD `pb_inf` INT NOT NULL DEFAULT '0' AFTER `pb_max`, ADD `s_per` INT NOT NULL DEFAULT '0' AFTER `pb_inf`, ADD `s_min` INT NOT NULL DEFAULT '0' AFTER `s_per`, ADD `s_max` INT NOT NULL DEFAULT '0' AFTER `s_min`, ADD `s_inf` INT NOT NULL DEFAULT '0' AFTER `s_max`, ADD `tds_per` INT NOT NULL DEFAULT '0' AFTER `s_inf`, ADD `status` TINYINT(2) NOT NULL DEFAULT '1' AFTER `tds_per`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;