=================This query is for DE609================Executed on Live (24/01/2018) ==== ALTER TABLE `sps_transactions` CHANGE `out_type_id` `out_type_id` VARCHAR(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; UPDATE `sps_transactions` set out_type_id = NULL where out_type_id = '' =================End - DE609================ =================This query is for US701================Executed on Live (24/01/2018)==== ALTER TABLE `sps_gate_configurations` ADD `grace_period` INT(10) NOT NULL DEFAULT '0' AFTER `percentage_flat`; ALTER TABLE `sps_gate_configurations` ADD `discount_additional_value` FLOAT(4,2) NOT NULL DEFAULT '0.0' AFTER `percentage_flat`; ALTER TABLE `sps_transaction_discount` CHANGE `discount_at` `discount_at` ENUM('ENTRY','EXIT','CPS','CPS_GATE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `sps_transaction_additional_charges` CHANGE `additional_charges_at` `additional_charges_at` ENUM('ENTRY','EXIT','CPS','CPS_GATE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE `sps_cps` CHANGE `updated_at` `updated_at` TIMESTAMP NULL; ALTER TABLE `sps_cps` ADD `cps_foc_approved` INT(10) NOT NULL AFTER `cps_foc_approval`; ALTER TABLE `sps_transactions` ADD `entry_process_time` DATETIME NULL DEFAULT NULL AFTER `sync_at`, ADD `cps_process_time` DATETIME NULL DEFAULT NULL AFTER `entry_process_time`, ADD `exit_process_time` DATETIME NULL DEFAULT NULL AFTER `cps_process_time`; =================End - US701================ =================This query is for 35954 Use for Email & SMS notification ==================== ALTER TABLE `sps_membership_log` ADD `is_notify` TINYINT NOT NULL DEFAULT '0' AFTER `reason_id`;