-----------------------------------------------Alters After 16/05(May)2023------------------------------------------------------- //17/05/2023 tollfree_request # ALTER TABLE `signalmash_prod2`.`tollfree_request` ADD COLUMN `id_grouporder` VARCHAR(256) NULL AFTER `type`; # ALTER TABLE `signalmash_prod2`.`tollfree_request` CHANGE `id_grouporder` `id_grouporder` VARCHAR(256) CHARSET utf8 COLLATE utf8_general_ci NULL AFTER `id_tollfree`, CHANGE `order_status` `order_status` TINYINT(2) DEFAULT 0 NOT NULL COMMENT '0 => order created and pending, 1 => order success, 2 => order complete but no did available', ADD COLUMN `description` VARCHAR(255) NULL AFTER `type`, DROP PRIMARY KEY, ADD PRIMARY KEY (`id_tollfree`, `order_status`); # ALTER TABLE `signalmash_prod2`.`tollfree_request` ADD COLUMN `returned_amt` DOUBLE NULL AFTER `pro_rates`; # ALTER TABLE `signalmash_prod2`.`tollfree_request` CHANGE `pro_rates` `pro_rates` DOUBLE(10,4) NULL, CHANGE `returned_amt` `returned_amt` DOUBLE(10,4) NULL; did_log # ALTER TABLE `signalmash_prod2`.`did_log` CHANGE `rates` `rates` DOUBLE(10,4) NULL, CHANGE `pro_rates` `pro_rates` DOUBLE(10,4) NULL; did_buy # ALTER TABLE `signalmash_prod2`.`did_buy` CHANGE `pro_rates` `pro_rates` DOUBLE(10,4) NULL; ALTER TABLE `signalmash_prod2`.`kyc_question` ADD COLUMN `if_yes_continue` ENUM('0','1') NULL AFTER `answer_id2`; ALTER TABLE `signalmash_prod2`.`kyc_question` CHANGE `answer` `answer_id1` VARCHAR(1) CHARSET latin1 COLLATE latin1_swedish_ci NULL, ADD COLUMN `answer_id2` VARCHAR(0) NULL AFTER `answer_id1`, ADD COLUMN `question_description` VARCHAR(255) NULL AFTER `answer_id2`; ALTER TABLE `signalmash_prod2`.`kyc_question` ADD COLUMN `service_type` VARCHAR(50) NULL AFTER `answer` CREATE TABLE `signalmash_prod2`.`kyc_question` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `question` VARCHAR(255), `answer` ENUM('0','1'), PRIMARY KEY (`id`) ); ALTER TABLE `signalmash_prod2`.`know_your_customer` ADD COLUMN `status` ENUM('0','1') DEFAULT '0' NULL AFTER `signature_url`; CREATE TABLE `signalmash_prod2`.`know_your_customer` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `iduser` INT(11), `idaccount` INT(11), `question_id` INT(11), `answer1_id` INT(11), `answer2_id` INT(11), `if_yes_continue` ENUM('0','1') DEFAULT '1', `question_description` TEXT, `signature_url` VARCHAR(255), PRIMARY KEY (`id`) ); ALTER TABLE `signalmash_prod2`.`kyc_question` CHANGE `answer_id1` `answer1` VARCHAR(55) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `answer_id2` `answer2` VARCHAR(55) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `if_yes_continue` `if_yes_continue` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `signalmash_prod2`.`kyc_question` CHANGE `question` `question` TEXT CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `question_description` `question_description` TEXT CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `signalmash_prod2`.`billing_address` ADD COLUMN `customerType` VARCHAR(100) NULL AFTER `idaccount`, ADD COLUMN `title` VARCHAR(100) NULL AFTER `country`, ADD COLUMN `ein` VARCHAR(100) NULL AFTER `title`, ADD COLUMN `website` VARCHAR(100) NULL AFTER `ein`, ADD COLUMN `legal_name` VARCHAR(100) NULL AFTER `website`, ADD COLUMN `groupExmpt_number` INT(55) NULL AFTER `legal_name`, ADD COLUMN `businessName` VARCHAR(150) NULL AFTER `groupExmpt_number`; ///////////////////////////////////////// 19/05/2023 ////////////////////////////////////////// ALTER TABLE `signalmash_prod2`.`invoice` ADD COLUMN `commission_amount` DOUBLE(10,4) DEFAULT 0 NULL AFTER `mrc_cost`; ===========18-05-2023============= ALTER TABLE `signalmash_prod2`.`kyc_question` ADD COLUMN `sub_question` TEXT NULL AFTER `question_description`; ALTER TABLE `signalmash_prod2`.`stripe_card` ADD COLUMN `confirm_name` VARCHAR(255) NULL AFTER `name`; ALTER TABLE `signalmash_prod2`.`user` ADD COLUMN `isCard` ENUM('true','false') DEFAULT 'false' NULL AFTER `isAddress`, ADD COLUMN `newUser_status` TINYINT(1) DEFAULT 0 NULL AFTER `is_deleted`; ALTER TABLE `signalmash_prod2`.`kyc_question` CHANGE `if_yes_continue` `click_yes` ENUM('true','false','') CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `signalmash_prod2`.`kyc_question` CHANGE `click_yes` `click_yes` TINYINT(1) DEFAULT 0 NULL; ALTER TABLE `signalmash_prod2`.`kyc_question` ADD COLUMN `question_type` TINYINT(1) DEFAULT 0 NULL COMMENT '0=>normal, 1=>list, 2=>notes, 3=>all' AFTER `service_type`; ============ 22-05-2023 ============ ALTER TABLE `signalmash_prod2`.`stripe_card` CHANGE `confirm_name` `confirm_name` TEXT CHARSET utf8 COLLATE utf8_general_ci NULL; ALTER TABLE `signalmash_prod2`.`session` ADD COLUMN `isCard` ENUM('true','false') NULL AFTER `isPlan`; ALTER TABLE `signalmash_prod2`.`kyc_question` ADD COLUMN `yes_to_continue` VARCHAR(255) NULL AFTER `answer2`; =====================26-05-2023=============== ALTER TABLE `signalmash_prod2`.`user` ADD COLUMN `card_pdf` VARCHAR(255) NULL AFTER `email_verification_date`; ALTER TABLE `signalmash_prod2`.`kyc_question` ADD COLUMN `panel_type` VARCHAR(100) NULL AFTER `question_type`; ALTER TABLE `signalmash_prod2`.`know_your_customer` ADD COLUMN `kyc_lock` TINYINT(1) DEFAULT 0 NULL AFTER `status`; ==============Sp CHANGE for ListUser TABLE================ add isCard and newUser_status field in ListUser select query(Line no.=>19,23,28,34,40,46,52,59,64,70,78,85) ==============Sp CHANGE for AddUser TABLE================== add isCard='false' in AddUser Insert query(Line no.=>30,42,46) did_log # ALTER TABLE `signalmash_prod2`.`did_log` CHANGE `event_type` `event_type` TINYINT(2) NULL COMMENT '1 -> DID Buy, 2 -> Import DID , 3 -> Auto Renewal enable,33-> Auto Renewal Disable, 4 -> Connection enable,44-> Conncetion Disable , 5 -> Disconnect DID, 6 -> Campaign Enable,66 -> Campaign Disable From OSR, 67 -> Campaign Disable From SINCH'; expired_campaign # CREATE TABLE `signalmash_prod2`.`expired_campaign` ( `exp_id` INT(11) AUTO_INCREMENT, `iduser` INT(11), `idaccount` INT(11), `campaign_key` VARCHAR(255), `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, KEY(`exp_id`) ); ==============Sp CHANGE for ListUser TABLE(31-05-2023)================ add kyc_verify_status in ListUser select query(Line no.=>18,22,29,35,41,48,54,60,65,72,79,86) =====================31-05-2023=============== # ALTER TABLE `signalmash_prod2`.`user` ADD COLUMN `kyc_verify_status` TINYINT(1) DEFAULT 0 NULL COMMENT '0=>Unverified, 1=>Verified, 2=>Verification Pending' AFTER `card_pdf`; =========================== 01-06-2023 =================== # CREATE TABLE `signalmash_prod2`.`lookup_api_rates` ( `idrates` INT(11) NOT NULL AUTO_INCREMENT, `idaccount` INT(11) NOT NULL, `iduser` INT(11), `idtariff` INT(11) NOT NULL, `type` VARCHAR(50), `rate` DOUBLE, `category` VARCHAR(100), `description` TEXT, `priority` INT(11), PRIMARY KEY (`idrates`) ); tollfree_request # ALTER TABLE `signalmash_prod2`.`tollfree_request` CHANGE `order_status` `order_status` TINYINT(2) DEFAULT 0 NOT NULL COMMENT '0 => Order Created, 1 => Order Complete or Order Closed, 2 => Order Pending, 3 => Other Status, 4 => Order Canceled'; ============================== 05-06-2923 ==================== # ALTER TABLE `signalmash_prod2`.`two_factor_auth` ADD PRIMARY KEY (`id`); // toll free small quantity tollfree_small_qty // move this table # CREATE TABLE `signalmash_prod2`.`tollfree_small_qty` ( `tfs_id` INT(11) AUTO_INCREMENT, `iduser` INT(11), `idaccount` INT(11), `id_tollfree` INT(11), `quantity` INT(11), `order_status` TINYINT(3), `rates` DOUBLE(10,4), `pro_rates` DOUBLE(10,4), `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP(), `status` TINYINT(2), KEY(`tfs_id`) ); # ALTER TABLE `signalmash_prod2`.`tollfree_small_qty` ADD COLUMN `id_grouporder` VARCHAR(50) NULL AFTER `status`; # ALTER TABLE `signalmash_prod2`.`tollfree_small_qty` CHANGE `id_grouporder` `id_grouporder` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL AFTER `id_tollfree`; # ALTER TABLE `signalmash_prod2`.`tollfree_small_qty` CHANGE `status` `status` TINYINT(2) DEFAULT 0 NULL COMMENT '0 => order not counted/not inprocess, 1 => order counted/processed'; # ALTER TABLE `signalmash_prod2`.`tollfree_small_qty` ADD COLUMN `returned_amount` DOUBLE(10,4) NULL AFTER `status`; tollfree_request # ALTER TABLE `signalmash_prod2`.`tollfree_request` ADD COLUMN `order_type` TINYINT(2) DEFAULT 0 NULL COMMENT '0 =>order quantity >= 100, 1 => order quantity < 100' AFTER `description`; // end stripe_card # ALTER TABLE `signalmash_prod2`.`stripe_card` ADD COLUMN `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NULL AFTER `email`; volt_response // move this table # ALTER TABLE `signalmash_prod2`.`volt_response` CHANGE `volt_user_id` `volt_user_id` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `webhook_url` `webhook_url` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, ADD COLUMN `updated_at` VARCHAR(255) NULL AFTER `created_at`; # ALTER TABLE `signalmash_prod2`.`volt_response` ADD COLUMN `key` TEXT NULL AFTER `updated_at`, ADD COLUMN `signature` TEXT NULL AFTER `key`; user # ALTER TABLE `signalmash_prod2`.`user` ADD COLUMN `volt_status` TINYINT(1) DEFAULT 0 NULL AFTER `kyc_verify_status`; ==================== 22-06-2023 ==================== ALTER TABLE `signalmash_prod2`.`kyc_question` ADD COLUMN `customer_type` VARCHAR(100) NULL AFTER `panel_type`; ALTER TABLE `signalmash_prod2`.`stripe_card` ADD COLUMN `con_fullname` VARCHAR(255) NULL AFTER `confirm_name`; ================================ 26-06-2023 ======================== # ALTER TABLE `signalmash_prod2`.`endpoint` CHANGE `forward_type` `forward_type` ENUM('1','2','3','4','5','6','7') CHARSET utf8 COLLATE utf8_bin NULL; # CREATE TABLE `signalmash_prod2`.`federal_dnc` ( `id_federal` INT(11) NOT NULL AUTO_INCREMENT, `question` TEXT, `answer1` VARCHAR(55), `answer2` VARCHAR(55), `question_description` TEXT, `service_type` VARCHAR(50), `federal_status` TINYINT(1) DEFAULT 0, PRIMARY KEY (`id_federal`) ); ====================================27-06-2023 ================================ # ALTER TABLE `signalmash_prod2`.`federal_dnc` CHANGE `service_type` `question_type` TINYINT(1) DEFAULT 0 NULL; # CREATE TABLE `signalmash_prod2`.`federal_answer` ( `id_answer` INT(11) NOT NULL AUTO_INCREMENT, `idaccount` INT(11), `iduser` INT(11), `question` TEXT, `answer1` VARCHAR(55), `answer2` VARCHAR(55), `value` TEXT, `flename` VARCHAR(255), `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id_answer`) ); ===================================== 28-06-2023 ========================================== # ALTER TABLE `signalmash_prod2`.`federal_answer` ADD COLUMN `question_description` TEXT NULL AFTER `question`; # ALTER TABLE `signalmash_prod2`.`federal_dnc` CHANGE `question_description` `question_description1` TEXT CHARSET latin1 COLLATE latin1_swedish_ci NULL, ADD COLUMN `question_description2` TEXT NULL AFTER `question_description1`; ============================================ 29-06-2023 ======================================== # ALTER TABLE `signalmash_prod2`.`federal_answer` ADD COLUMN `fullname` VARCHAR(100) NULL AFTER `answer2`, CHANGE `value` `signature` TEXT CHARSET latin1 COLLATE latin1_swedish_ci NULL; # ALTER TABLE `signalmash_prod2`.`federal_answer` ADD COLUMN `question_id` INT(11) NULL AFTER `idaccount`; # ============================================ 29-06-2023 ======================================== ALTER TABLE `signalmash_prod2`.`stripe_card` DROP INDEX `key`; ALTER TABLE `signalmash_prod2`.`user` CHANGE `kyc_verify_status` `kyc_verify_status` TINYINT(1) DEFAULT 0 NULL COMMENT '0=>Unverified, 1=>Verified, 2=>Verification Pending,3=>Reject'; ============================================ 30-06-2023 ===================================== # ALTER TABLE `signalmash_prod2`.`federal_answer` CHANGE `flename` `filename` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL; ======================================== 01-06-2023 ======================================== # ALTER TABLE `signalmash_prod2`.`federal_answer` ADD COLUMN `value` TEXT NULL AFTER `filename`; ======================================== 04/07/2023 ==================================== # ALTER TABLE `signalmash_prod2`.`account` ADD COLUMN `ib_channel` INT(11) NULL AFTER `is_billing`, ADD COLUMN `ob_channel` INT(11) NULL AFTER `ib_channel`; ========================================= 05/07/2023 =========================================== # ALTER TABLE `signalmash_prod2`.`account` ADD COLUMN `cps` INT(11) NULL AFTER `ob_channel`; channel_request // move from local # CREATE TABLE `signalmash_prod2`.`channel_request` ( `channel_id` INT(11), `current_in_channel_limit` INT(11), `current_out_channel_limit` INT(11), `request_in_channel_limit` INT(11), `request_out_channel_limit` INT(11), `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` VARCHAR(50), `status` TINYINT(1) DEFAULT 0 COMMENT '0 => Request Created, 1 => Request Verified, 2 => Request Cancelled' ); # ALTER TABLE `signalmash_prod2`.`channel_request` CHANGE `channel_id` `channel_id` INT(11) NULL AUTO_INCREMENT, ADD KEY(`channel_id`); # ALTER TABLE `signalmash_prod2`.`channel_request` ADD COLUMN `iduser` INT(11) NULL AFTER `channel_id`, ADD COLUMN `idaccount` INT(11) NULL AFTER `iduser`; ========================================= 12/07/2023 =========================================== ALTER TABLE `signalmash_prod2`.`user` ADD COLUMN `federal_status` TINYINT(1) DEFAULT 0 NULL AFTER `volt_status`; ========================================= 17/07/2023 =========================================== ALTER TABLE `signalmash_prod2`.`stripe_card` ADD COLUMN `card_pdf` VARCHAR(255) NULL AFTER `created_at`; ////and remove card_pdf from user table federal_log CREATE TABLE `signalmash_prod2`.`federal_log` ( `federal_log_id` INT(11), `iduser` INT(11), `idaccount` INT(11), `pdf` VARCHAR(510), `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `federal_status` TINYINT(1) DEFAULT 0 COMMENT '0 => Inactive, 1 => Active, 2 => Pending to Active, 3 => Reject' ); ALTER TABLE `signalmash_prod2`.`federal_log` CHANGE `federal_log_id` `federal_log_id` INT(11) NULL AUTO_INCREMENT, ADD KEY(`federal_log_id`);