/*1. Configure - EOD : Serail number vise data shown*/

ALTER TABLE `sps_eod_report_select` ADD `eod_reportvise_id` INT NOT NULL AFTER `location_id`;

UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '1' WHERE `sps_eod_report_select`.`eod_report_id` = 1;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '2' WHERE `sps_eod_report_select`.`eod_report_id` = 3;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '3' WHERE `sps_eod_report_select`.`eod_report_id` = 17;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '4' WHERE `sps_eod_report_select`.`eod_report_id` = 4;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '5' WHERE `sps_eod_report_select`.`eod_report_id` = 20;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '6' WHERE `sps_eod_report_select`.`eod_report_id` = 18;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '7' WHERE `sps_eod_report_select`.`eod_report_id` = 12;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '8' WHERE `sps_eod_report_select`.`eod_report_id` = 6;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '9' WHERE `sps_eod_report_select`.`eod_report_id` = 9;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '10' WHERE `sps_eod_report_select`.`eod_report_id` = 8;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '11' WHERE `sps_eod_report_select`.`eod_report_id` = 7;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '12' WHERE `sps_eod_report_select`.`eod_report_id` = 13;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '13' WHERE `sps_eod_report_select`.`eod_report_id` = 5;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '14' WHERE `sps_eod_report_select`.`eod_report_id` = 10;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '15' WHERE `sps_eod_report_select`.`eod_report_id` = 15;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '16' WHERE `sps_eod_report_select`.`eod_report_id` = 14;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '17' WHERE `sps_eod_report_select`.`eod_report_id` = 19;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '18' WHERE `sps_eod_report_select`.`eod_report_id` = 16;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '19' WHERE `sps_eod_report_select`.`eod_report_id` = 11;
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '20' WHERE `sps_eod_report_select`.`eod_report_id` = 2;


/*2. Banking Amount - Settlement Table: adding column*/

ALTER TABLE `sps_settlement` ADD `banking_amt` FLOAT(10,2) NOT NULL AFTER `f_eight_ticket_charges`;

ALTER TABLE `sps_settlement` CHANGE `banking_amt` `banking_amt` FLOAT(10,2) NOT NULL DEFAULT '0';