/// visa_default
ALTER TABLE `visa_default` ADD `country_id` INT(11) NOT NULL AFTER `id`, ADD `purpose` VARCHAR(50) NOT NULL AFTER `country_id`, ADD `type` VARCHAR(100) NOT NULL AFTER `purpose`, ADD `completion_time` INT(5) NOT NULL AFTER `type`, ADD `days_before_travel` INT(5) NOT NULL AFTER `completion_time`, ADD `info` LONGTEXT NOT NULL AFTER `days_before_travel`, ADD `amount` INT(11) NOT NULL AFTER `info`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `amount`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;


/// visa_default_docs
ALTER TABLE `visa_default_docs` ADD `visa_default_id` INT(11) NOT NULL AFTER `id`, ADD `name` VARCHAR(100) NOT NULL AFTER `visa_default_id`, ADD `type` ENUM('text','image') NOT NULL AFTER `name`, ADD `madatory` TINYINT(2) NOT NULL COMMENT '0:no; 1:yes' AFTER `type`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `mandatory`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_default_docs` ADD `description` LONGTEXT NULL AFTER `type`;


/// visa
ALTER TABLE `visa` ADD `user_id` INT(11) NOT NULL AFTER `id`, ADD `country_id` INT(11) NOT NULL AFTER `user_id`, ADD `purpose` VARCHAR(50) NOT NULL AFTER `country_id`, ADD `type` VARCHAR(100) NOT NULL AFTER `purpose`, ADD `completion_time` INT(5) NOT NULL AFTER `type`, ADD `days_before_travel` INT(5) NOT NULL AFTER `completion_time`, ADD `info` LONGTEXT NOT NULL AFTER `days_before_travel`, ADD `amount` INT(11) NOT NULL AFTER `info`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `amount`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa` ADD `visa_default_id` BIGINT NOT NULL AFTER `user_id`;
ALTER TABLE `visa` ADD `status` TINYINT NOT NULL DEFAULT '1' AFTER `amount`;
ALTER TABLE `visa` CHANGE `amount` `amount_b2b` INT NOT NULL;
ALTER TABLE `visa` ADD `amount_b2c` INT(11) NOT NULL AFTER `amount_b2b`;
ALTER TABLE `visa` ADD `web_user_id` BIGINT NOT NULL AFTER `user_id`;


/// visa_docs
ALTER TABLE `visa_docs` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `visa_id` INT(11) NOT NULL AFTER `user_id`, ADD `name` VARCHAR(100) NOT NULL AFTER `visa_id`, ADD `type` ENUM('text','image') NOT NULL AFTER `name`, ADD `madatory` TINYINT(2) NOT NULL COMMENT '0:no; 1:yes' AFTER `type`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `mandatory`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_docs` ADD `description` LONGTEXT NULL AFTER `type`;
ALTER TABLE `visa_docs` ADD `status` TINYINT NOT NULL DEFAULT '1' AFTER `mandatory`;


/// visa_apply
ALTER TABLE `visa_apply` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `web_user_id` BIGINT NOT NULL AFTER `user_id`, ADD `supplier_id` BIGINT NOT NULL DEFAULT '0' AFTER `web_user_id`, ADD `visa_id` BIGINT NOT NULL AFTER `supplier_id`, ADD `travel_from` DATE NOT NULL AFTER `visa_id`, ADD `travel_to` DATE NOT NULL AFTER `travel_from`, ADD `completion_time` INT(3) NOT NULL AFTER `travel_to`, ADD `info` LONGTEXT NOT NULL AFTER `completion_time`, ADD `amount` INT(11) NOT NULL AFTER `info`, ADD `traveller_qty` INT(3) NOT NULL AFTER `amount`, ADD `request_info` VARCHAR(250) NULL AFTER `traveller_qty`, ADD `share_request_info` TINYINT(2) NOT NULL DEFAULT '0' AFTER `request_info`;
ALTER TABLE `visa_apply` ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `share_request_info`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_apply` CHANGE `id` `id` BIGINT NOT NULL AUTO_INCREMENT, CHANGE `info` `info` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'info written by the website owner', CHANGE `share_request_info` `share_request_info` TINYINT NOT NULL DEFAULT '0' COMMENT 'info written by the end user', CHANGE `createdAt` `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `updatedAt` `updatedAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE `visa_apply` ADD `status` TINYINT NOT NULL COMMENT '0: pending; 1:all accepted; 2 all rejected; 3: partly accepted & partly rejected' AFTER `share_request_info`;
ALTER TABLE `visa_apply` CHANGE `status` `status` TINYINT NOT NULL DEFAULT '0' COMMENT '0: pending; 1:all accepted; 2 all rejected; 3: partly accepted & partly rejected';


/// visa_apply_pax
ALTER TABLE `visa_apply_pax` ADD `visa_apply_id` BIGINT NOT NULL AFTER `id`, ADD `pax_name` VARCHAR(150) NOT NULL AFTER `visa_apply_id`, ADD `status` TINYINT(2) NOT NULL AFTER `pax_name`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;


/// visa_apply_details
ALTER TABLE `visa_apply_details` ADD `visa_apply_id` BIGINT NOT NULL AFTER `id`, ADD `traveller_name` VARCHAR(100) NOT NULL AFTER `visa_apply_id`, ADD `doc_name` VARCHAR(100) NOT NULL AFTER `traveller_name`, ADD `doc_type` VARCHAR(50) NOT NULL AFTER `doc_name`, ADD `allow_change` TINYINT(2) NOT NULL DEFAULT '0' AFTER `doc_type`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `allow_change`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_apply_details` CHANGE `id` `id` BIGINT NOT NULL AUTO_INCREMENT, CHANGE `visa_apply_id` `visa_pax_id` BIGINT NOT NULL, CHANGE `traveller_name` `doc_name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, CHANGE `doc_name` `doc_type` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, CHANGE `doc_type` `doc_input` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, CHANGE `createdAt` `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `updatedAt` `updatedAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;


/// visa_apply_pax_status_b2c
ALTER TABLE `visa_apply_pax_status_b2c` ADD `visa_apply_pax_id` BIGINT NOT NULL AFTER `id`, ADD `status` INT(3) NOT NULL COMMENT '0:not accepted; 1: accepted; 2:applied; 3:approved; 4:rejected' AFTER `visa_apply_pax_id`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;


/// visa_apply_pax_status_b2b
ALTER TABLE `visa_apply_pax_status_b2b` ADD `visa_apply_pax_id` BIGINT NOT NULL AFTER `id`, ADD `status` INT(3) NOT NULL COMMENT '0:not accepted; 1: accepted; 2:applied; 3:approved; 4:rejected' AFTER `visa_apply_pax_id`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;


/// visa_supplier
ALTER TABLE `visa_supplier` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `visa_default_id` BIGINT NOT NULL AFTER `user_id`, ADD `completion_time` INT(3) NOT NULL AFTER `visa_default_id`, ADD `days_before_travel` INT(5) NOT NULL AFTER `completion_time`, ADD `info` LONGTEXT NULL AFTER `days_before_travel`, ADD `amount` INT(10) NOT NULL AFTER `info`, ADD `qty` INT(10) NOT NULL AFTER `amount`, ADD `accepted` INT(10) NOT NULL AFTER `qty`;
ALTER TABLE `visa_supplier` ADD `rejected` INT(10) NOT NULL DEFAULT '0' AFTER `accepted`, ADD `in_progress` INT(10) NOT NULL DEFAULT '0' AFTER `rejected`, ADD `status` TINYINT(3) NOT NULL COMMENT '0:off; 1:on' AFTER `in_progress`, ADD `success` INT(10) NOT NULL DEFAULT '0' AFTER `status`, ADD `failure` INT(10) NOT NULL DEFAULT '0' AFTER `success`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `failure`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_supplier` ADD `info` VARCHAR(250) NULL AFTER `amount`;


/// visa_types
ALTER TABLE `visa_types` ADD `visa_default_id` BIGINT NOT NULL AFTER `id`, ADD `text_1` VARCHAR(100) NULL AFTER `visa_default_id`, ADD `t_desc_1` VARCHAR(255) NULL AFTER `text_1`, ADD `text_2` VARCHAR(100) NULL AFTER `t_desc_1`, ADD `t_desc_2` VARCHAR(255) NULL AFTER `text_2`, ADD `text_3` VARCHAR(100) NULL AFTER `t_desc_2`, ADD `t_desc_3` VARCHAR(255) NULL AFTER `text_3`, ADD `text_4` VARCHAR(100) NULL AFTER `t_desc_3`, ADD `t_desc_4` VARCHAR(255) NULL AFTER `text_4`, ADD `text_5` VARCHAR(100) NULL AFTER `t_desc_4`, ADD `t_desc_5` VARCHAR(255) NULL AFTER `text_5`, ADD `text_6` VARCHAR(100) NULL AFTER `t_desc_5`, ADD `t_desc_6` VARCHAR(255) NULL AFTER `text_6`, ADD `text_7` VARCHAR(100) NULL AFTER `t_desc_6`, ADD `t_desc_7` VARCHAR(255) NULL AFTER `text_7`;
ALTER TABLE `visa_types`  ADD `image_1` VARCHAR(100) NULL  AFTER `t_desc_7`,  ADD `i_desc_1` VARCHAR(255) NULL  AFTER `image_1`,  ADD `image_2` VARCHAR(100) NULL  AFTER `i_desc_1`,  ADD `i_desc_2` VARCHAR(255) NULL  AFTER `image_2`,  ADD `image_3` VARCHAR(100) NULL  AFTER `i_desc_2`,  ADD `i_desc_3` VARCHAR(255) NULL  AFTER `image_3`,  ADD `image_4` VARCHAR(100) NULL  AFTER `i_desc_3`,  ADD `i_desc_4` VARCHAR(255) NULL  AFTER `image_4`,  ADD `image_5` VARCHAR(100) NULL  AFTER `i_desc_4`,  ADD `i_desc_5` VARCHAR(255) NULL  AFTER `image_5`,  ADD `image_6` VARCHAR(100) NULL  AFTER `i_desc_5`,  ADD `i_desc_6` VARCHAR(255) NULL  AFTER `image_6`,  ADD `image_7` VARCHAR(100) NULL  AFTER `i_desc_6`,  ADD `i_desc_7` VARCHAR(255) NULL  AFTER `image_7`;
ALTER TABLE `visa_types`  ADD `radio_1` VARCHAR(100) NULL  AFTER `i_desc_7`,  ADD `r_opt_1` VARCHAR(255) NULL  AFTER `radio_1`,  ADD `r_desc_1` VARCHAR(255) NULL  AFTER `r_opt_1`,  ADD `radio_2` VARCHAR(100) NULL  AFTER `r_desc_1`,  ADD `r_opt_2` VARCHAR(255) NULL  AFTER `radio_2`,  ADD `r_desc_2` VARCHAR(255) NULL  AFTER `r_opt_2`,  ADD `radio_3` VARCHAR(100) NULL  AFTER `r_desc_2`,  ADD `r_opt_3` VARCHAR(255) NULL  AFTER `radio_3`,  ADD `r_desc_3` VARCHAR(255) NULL  AFTER `r_opt_3`,  ADD `radio_4` VARCHAR(100) NULL  AFTER `r_desc_3`,  ADD `r_opt_4` VARCHAR(255) NULL  AFTER `radio_4`,  ADD `r_desc_4` VARCHAR(255) NULL  AFTER `r_opt_4`,  ADD `radio_5` INT(100) NULL  AFTER `r_desc_4`,  ADD `r_opt_5` INT(255) NULL  AFTER `radio_5`,  ADD `r_desc_5` INT(255) NULL  AFTER `r_opt_5`,  ADD `status` TINYINT(2) NOT NULL DEFAULT '1'  AFTER `r_desc_5`,  ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP  AFTER `status`,  ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  AFTER `createdAt`;
ALTER TABLE `visa_types` CHANGE `visa_default_id` `country_id` BIGINT NOT NULL;
ALTER TABLE `visa_types` ADD `purpose` VARCHAR(100) NOT NULL AFTER `country_id`, ADD `type` VARCHAR(100) NOT NULL AFTER `purpose`;
ALTER TABLE `visa_types` ADD `date_1` VARCHAR(100) NULL AFTER `r_desc_5`, ADD `d_desc_1` VARCHAR(255) NULL AFTER `date_1`, ADD `date_2` VARCHAR(100) NULL AFTER `d_desc_1`, ADD `d_desc_2` VARCHAR(255) NULL AFTER `date_2`;
ALTER TABLE `visa_types` ADD `full_name` VARCHAR(150) NOT NULL AFTER `type`;


/// visa_prices
ALTER TABLE `visa_prices` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `visa_types_id` BIGINT NOT NULL AFTER `user_id`, ADD `completion_time` INT(3) NOT NULL AFTER `visa_types_id`, ADD `days_before_travel` INT(5) NOT NULL AFTER `completion_time`, ADD `info` VARCHAR(255) NULL AFTER `days_before_travel`, ADD `amount_b2b` INT(11) NOT NULL AFTER `info`, ADD `amount_b2c` INT(11) NOT NULL AFTER `amount_b2b`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `amount_b2c`, ADD `updateAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_prices` ADD `status` TINYINT NOT NULL DEFAULT '1' AFTER `amount_b2c`;
ALTER TABLE `visa_prices` ADD `qty` INT(5) NOT NULL DEFAULT '0' AFTER `amount_b2c`, ADD `accepted` INT(5) NOT NULL DEFAULT '0' AFTER `qty`, ADD `rejected` INT(5) NOT NULL DEFAULT '0' AFTER `accepted`;
ALTER TABLE `visa_prices` ADD `auto_forward_id` BIGINT NOT NULL DEFAULT '0' COMMENT 'user/supplier to forward the query automatically ' AFTER `amount_b2c`;
ALTER TABLE `visa_prices` ADD `image` VARCHAR(100) NULL AFTER `amount_b2c`;


/// visa_type_add
ALTER TABLE `visa_type_add` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `visa_type_id` BIGINT NOT NULL AFTER `user_id`, ADD `completion_time` INT(10) NOT NULL AFTER `visa_type_id`, ADD `days_before_travel` INT(5) NOT NULL AFTER `completion_time`, ADD `info` VARCHAR(255) NOT NULL AFTER `days_before_travel`, ADD `amount_b2b` INT(10) NOT NULL AFTER `info`, ADD `amount_b2c` INT(10) NOT NULL AFTER `amount_b2b`, ADD `auto_forward_id` BIGINT NOT NULL DEFAULT '0' COMMENT 'user/supplier to forward the query automatically' AFTER `amount_b2c`, ADD `status` TINYINT NOT NULL DEFAULT '1' AFTER `auto_forward_id`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;


/// visa_apply
// ALTER TABLE `visa_apply` ADD `visa_price_id` BIGINT NOT NULL AFTER `id`, ADD `user_id` BIGINT NOT NULL AFTER `visa_price_id`, ADD `web_user_id` BIGINT NOT NULL AFTER `user_id`, ADD `supplier_id` BIGINT NOT NULL AFTER `web_user_id`, ADD `completion_time` INT(5) NOT NULL AFTER `supplier_id`, ADD `info` VARCHAR(255) NOT NULL AFTER `completion_time`, ADD `total_amount` INT(5) NOT NULL AFTER `info`, ADD `status_b2b` TINYINT(2) NOT NULL DEFAULT '0' COMMENT '0: request received, 1:applied; 2:under query; 3:accepted; 4:rejected' AFTER `total_amount`, ADD `status_b2c` TINYINT(2) NOT NULL DEFAULT '0' COMMENT '0: request received, 1:applied; 2:under query; 3:accepted; 4:rejected' AFTER `status_b2b`, ADD `status` TINYINT(2) NOT NULL DEFAULT '1' AFTER `status_b2c`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
// ALTER TABLE `visa_apply` ADD `country_id` INT(5) NOT NULL AFTER `supplier_id`, ADD `country_name` VARCHAR(50) NOT NULL AFTER `country_id`;
CREATE TABLE `visa_apply` LIKE `visa_apply_pax`;
ALTER TABLE `visa_apply`  ADD `user_id` BIGINT NOT NULL  AFTER `id`,  ADD `web_user_id` BIGINT NOT NULL  AFTER `user_id`,  ADD `visa_types_id` BIGINT NOT NULL  AFTER `web_user_id`,  ADD `country_id` INT(11) NOT NULL  AFTER `visa_types_id`,  ADD `purpose` VARCHAR(200) NOT NULL  AFTER `country_id`,  ADD `type` VARCHAR(200) NOT NULL  AFTER `purpose`;
ALTER TABLE `visa_apply` ADD `completion_time` INT(10) NOT NULL AFTER `amount`, ADD `days_before_travel` INT(10) NOT NULL AFTER `completion_time`, ADD `info` VARCHAR(250) NOT NULL AFTER `days_before_travel`;
ALTER TABLE `visa_apply` ADD `country_name` VARCHAR(100) NOT NULL AFTER `country_id`;
ALTER TABLE `visa_apply` ADD `supplier_id` BIGINT NOT NULL DEFAULT '0' AFTER `web_user_id`;
ALTER TABLE `visa_apply` ADD `forwarded_on` DATETIME NULL AFTER `status`;



/// visa_apply_pax
ALTER TABLE `visa_apply_pax`  ADD `visa_apply_id` BIGINT NOT NULL  AFTER `id`,  ADD `text_1` VARCHAR(250) NULL  AFTER `visa_apply_id`,  ADD `text_2` VARCHAR(250) NULL  AFTER `text_1`,  ADD `text_3` VARCHAR(250) NULL  AFTER `text_2`,  ADD `text_4` VARCHAR(250) NULL  AFTER `text_3`,  ADD `text_5` VARCHAR(250) NULL  AFTER `text_4`,  ADD `text_6` VARCHAR(250) NULL  AFTER `text_5`,  ADD `text_7` VARCHAR(250) NULL  AFTER `text_6`,  ADD `image_1` VARCHAR(100) NULL  AFTER `text_7`,  ADD `image_2` VARCHAR(100) NULL  AFTER `image_1`,  ADD `image_3` VARCHAR(100) NULL  AFTER `image_2`,  ADD `image_4` VARCHAR(100) NULL  AFTER `image_3`,  ADD `image_5` VARCHAR(100) NULL  AFTER `image_4`,  ADD `image_6` VARCHAR(100) NULL  AFTER `image_5`,  ADD `image_7` VARCHAR(100) NULL  AFTER `image_6`,  ADD `radio_1` VARCHAR(100) NULL  AFTER `image_7`,  ADD `radio_2` VARCHAR(100) NULL  AFTER `radio_1`,  ADD `radio_3` VARCHAR(100) NULL  AFTER `radio_2`,  ADD `radio_4` VARCHAR(100) NULL  AFTER `radio_3`,  ADD `radio_5` VARCHAR(100) NULL  AFTER `radio_4`,  ADD `date_1` DATE NULL  AFTER `radio_5`,  ADD `date_2` DATE NULL  AFTER `date_1`,  ADD `amount` INT(5) NOT NULL  AFTER `date_2`,  ADD `status_b2b` TINYINT(2) NOT NULL DEFAULT '0'  AFTER `amount`,  ADD `status_b2c` TINYINT(2) NOT NULL DEFAULT '0'  AFTER `status_b2b`;
ALTER TABLE `visa_apply_pax` ADD `status` TINYINT(2) NOT NULL DEFAULT '1' AFTER `status_b2c`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_apply_pax` ADD `full_name` VARCHAR(150) NOT NULL AFTER `visa_apply_id`;


/// OTHER
ALTER TABLE `countries` ADD `is_e_visa` TINYINT NOT NULL DEFAULT '0' AFTER `country_code`;


/// visa_supplier
ALTER TABLE `visa_supplier` ADD `user_id` BIGINT NOT NULL AFTER `id`, ADD `visa_types_id` BIGINT NOT NULL AFTER `user_id`, ADD `amount` INT(11) NOT NULL AFTER `visa_types_id`, ADD `status` TINYINT(2) NOT NULL DEFAULT '1' AFTER `amount`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_supplier` ADD `completion_time` INT(5) NOT NULL AFTER `visa_types_id`, ADD `days_before_travel` INT(10) NOT NULL AFTER `completion_time`;


/// visa_forward
ALTER TABLE `visa_forward` ADD `visa_apply_id` BIGINT NOT NULL AFTER `id`, ADD `supplier_id` BIGINT NOT NULL AFTER `visa_apply_id`, ADD `amount` INT(10) NOT NULL AFTER `supplier_id`, ADD `status` TINYINT NOT NULL DEFAULT '1' AFTER `amount`, ADD `reason` VARCHAR(250) NULL AFTER `status`, ADD `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `reason`, ADD `updatedAt` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `createdAt`;
ALTER TABLE `visa_forward` ADD `status_b2b` TINYINT NOT NULL DEFAULT '0' AFTER `amount`;


/// env file
VISAIMAGE = /var/www/html/fb-final_api/uploads/visa_image/