ALTER TABLE `sps_cps` ADD INDEX transaction_id (`transaction_id`);

/*Equipment list*/
ALTER TABLE `sps_equipment_lists`  ADD `superadmin` TINYINT NOT NULL  AFTER `area_id`;
ALTER TABLE `sps_equipment_lists` ADD `sync_at` DATETIME NULL DEFAULT NULL AFTER `superadmin`;

/*Payment Modes*/
ALTER TABLE `sps_payment_modes`  ADD `superadmin` TINYINT NOT NULL  AFTER `area_id`;
ALTER TABLE `sps_payment_modes` ADD `sync_at` DATETIME NULL DEFAULT NULL AFTER `superadmin`;

/*the below query is with respect to US833_APS_Transaction_Report.sql, whereAPS user has beedn added in 
sps_shift_management where it should not be considered as settled that is why setting shift_settlement_status = 0 and end_shift_status = 0*/

UPDATE 
  sps_shift_management 
SET 
  shift_settlement_status = 0, 
  end_shift_status = 0 
WHERE 
  user_id = '1' 
  AND user_type = '1' 
  AND shift_start = '0000-00-00 00:00:00' 
  AND shift_end = '0000-00-00 00:00:00' 
  AND shift_settlement_status = '1';