ALTER TABLE `tbltenant_subscription_payments` CHANGE `mode` `mode` ENUM('subscription_callback','direct_via_web','cron') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

ALTER TABLE `tbltenant_subscription_payments` CHANGE `status` `status` ENUM('completed','failed','pending') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

ALTER TABLE `tbltenant_plan_information` ADD `submit_id` VARCHAR(191) NULL DEFAULT NULL AFTER `stripe_subscription_id`;

ALTER TABLE `tbltenant_plan_changes_history` ADD `tenant_first_name` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_id`;
ALTER TABLE `tbltenant_plan_changes_history` ADD `tenant_last_name` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_first_name`;
ALTER TABLE `tbltenant_plan_changes_history` ADD `tenant_email` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_last_name`;
ALTER TABLE `tbltenant_plan_changes_history` ADD `tenant_mobile_no` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_email`;
ALTER TABLE `tbltenant_plan_changes_history` ADD `tenant_company` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_mobile_no`;

ALTER TABLE `tblpurchase_plan_history` ADD `tenant_first_name` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_id`;
ALTER TABLE `tblpurchase_plan_history` ADD `tenant_last_name` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_first_name`;
ALTER TABLE `tblpurchase_plan_history` ADD `tenant_email` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_last_name`;
ALTER TABLE `tblpurchase_plan_history` ADD `tenant_mobile_no` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_email`;
ALTER TABLE `tblpurchase_plan_history` ADD `tenant_company` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_mobile_no`;

ALTER TABLE `tbltenant_plan_cancel_history` ADD `tenant_first_name` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_id`;
ALTER TABLE `tbltenant_plan_cancel_history` ADD `tenant_last_name` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_first_name`;
ALTER TABLE `tbltenant_plan_cancel_history` ADD `tenant_email` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_last_name`;
ALTER TABLE `tbltenant_plan_cancel_history` ADD `tenant_mobile_no` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_email`;
ALTER TABLE `tbltenant_plan_cancel_history` ADD `tenant_company` VARCHAR(355) NULL DEFAULT NULL AFTER `tenant_mobile_no`;