SET
FOREIGN_KEY_CHECKS=0;

ALTER TABLE `sps_settlement`
    ADD COLUMN `fastag_amount` DOUBLE(20,2) DEFAULT 0 AFTER `e_wallets_amount`;


ALTER TABLE `sps_settlement`
    ADD COLUMN `cash_count` int(10) DEFAULT 0 AFTER `fastag_amount`;
ALTER TABLE `sps_settlement`
    ADD COLUMN `edc_count` int(10) DEFAULT 0 AFTER `cash_count`;
ALTER TABLE `sps_settlement`
    ADD COLUMN `upi_count` int(10) DEFAULT 0 AFTER `edc_count`;
ALTER TABLE `sps_settlement`
    ADD COLUMN `fastag_count` int(10) DEFAULT 0 AFTER `upi_count`;


-- EOD Cashier Income Details
UPDATE `sps_eod_report_select` SET `eod_report_name` = 'system_income_details', `status` = 1, `area_id` = 1, `location_id` = 1, `eod_reportvise_id` = 4.1, `created_by` = 1, `updated_by` = 0, `created_at` = '2017-11-01 16:09:06', `updated_at` = '2022-06-06 06:34:02', `deleted_at` = NULL WHERE `eod_report_name` = 'cashier_income_details';


-- EOD Cashier Income Details New
INSERT INTO `sps_eod_report_select` (`eod_report_name`, `status`, `area_id`, `location_id`, `eod_reportvise_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cashier_banking_details', 1, 1, 1, 4.2, 1, 0, '2017-11-01 16:09:06', '2022-06-06 06:34:02', NULL);



SET
FOREIGN_KEY_CHECKS=1;