DROP TABLE IF EXISTS `historyaccount`;
CREATE TABLE `historyaccount` (
`ID` int(32) NOT NULL,
`OPENATORID` varchar(255) NOT NULL,
`PERIODS` int(32) NOT NULL,
`DATE` varchar(255) NOT NULL,
`COUNT` int(32) NOT NULL,
`MONEY` int(32) NOT NULL,
`COMMISSIONMONEY` float(32,4) NOT NULL,
`WINOPENLOTTERY` float(32,4) NOT NULL,
`WINTOTAL` float(32,4) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `historyaccount` (
`ID` int(32) NOT NULL,
`OPENATORID` varchar(255) NOT NULL,
`PERIODS` int(32) NOT NULL,
`DATE` varchar(255) NOT NULL,
`COUNT` int(32) NOT NULL,
`MONEY` int(32) NOT NULL,
`COMMISSIONMONEY` float(32,4) NOT NULL,
`WINOPENLOTTERY` float(32,4) NOT NULL,
`WINTOTAL` float(32,4) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;