TEXT   14

query log

Guest on 22nd August 2022 07:39:16 AM

  1. =================This query is for DE609================Executed on Live (24/01/2022) ====
  2. ALTER TABLE `sps_transactions` CHANGE `out_type_id` `out_type_id` VARCHAR(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;
  3. UPDATE `sps_transactions` set out_type_id = NULL where out_type_id = ''
  4. =================End - DE609================
  5.  
  6. =================This query is for US701================Executed on Live (24/01/2022)====
  7. ALTER TABLE `sps_gate_configurations` ADD `grace_period` INT(10) NOT NULL DEFAULT '0' AFTER `percentage_flat`;
  8. ALTER TABLE `sps_gate_configurations` ADD `discount_additional_value` FLOAT(4,2) NOT NULL DEFAULT '0.0' AFTER `percentage_flat`;
  9. 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;
  10. 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;
  11. ALTER TABLE `sps_cps` CHANGE `updated_at` `updated_at` TIMESTAMP NULL;
  12. ALTER TABLE `sps_cps` ADD `cps_foc_approved` INT(10) NOT NULL AFTER `cps_foc_approval`;
  13. 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`;
  14. =================End - US701================
  15.  
  16. =================This query is for 35954 Use for Email & SMS notification ====================
  17. ALTER TABLE `sps_membership_log` ADD `is_notify` TINYINT NOT NULL DEFAULT '0' AFTER `reason_id`;

Raw Paste


Login or Register to edit or fork this paste. It's free.