ALTER TABLE `sps_eod_report_select` CHANGE `updated_at` `updated_at` TIMESTAMP NOT NULL DEFAULT 0, CHANGE `deleted_at` `deleted_at` TIMESTAMP NULL DEFAULT NULL;
UPDATE `sps_eod_report_select` SET `deleted_at` = NULL;
UPDATE `sps_eod_report_select` SET `deleted_at` = '2019-11-28 00:00:00' WHERE `sps_eod_report_select`.`eod_report_name` = 'vehicle_type_wise_revenue';
ALTER TABLE `sps_eod_report_select` CHANGE `eod_reportvise_id` `eod_reportvise_id` FLOAT(11) NOT NULL;

UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '5.1' WHERE `sps_eod_report_select`.`eod_report_name` = 'vehicle_type_wise_revenue_report_in_gate';
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '5.2' WHERE `sps_eod_report_select`.`eod_report_name` = 'vehicle_type_wise_revenue_report_out_gate';
UPDATE `sps_eod_report_select` SET `eod_reportvise_id` = '5.3' WHERE `sps_eod_report_select`.`eod_report_name` = 'vehicle_type_wise_revenue_report_cps_gate';