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