-----------------------------------------------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`);