

DROP TABLE IF EXISTS `tbl_rpt004_1_1`;

CREATE TABLE `tbl_rpt004_1_1` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `gate_name` varchar(150) NOT NULL DEFAULT '',
  `qty` varchar(150) NOT NULL DEFAULT '',
  `rev` varchar(150) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



DROP TABLE IF EXISTS `tbl_rpt004_2_1`;

CREATE TABLE `tbl_rpt004_2_1` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `gate_name` varchar(150) NOT NULL DEFAULT '',
  `qty` varchar(150) NOT NULL DEFAULT '',
  `rev` varchar(150) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


#Warning this to be used whenever new Reprot change or EOD Configuration changed 
TRUNCATE TABLE `tbl_rpt001`; 
#Warning this to be used whenever new Reprot change or EOD Configuration changed

