· 8 years ago · Mar 14, 2018, 12:22 AM
1CREATE TABLE IF NOT EXISTS `donation` (
2 `username` varchar(32) NOT NULL,
3 `time` varchar(100) NOT NULL,
4 `productid` varchar(100) NOT NULL,
5 `price` decimal(10,0) NOT NULL,
6 `tickets` int(11) NOT NULL,
7 `index` int(11) NOT NULL AUTO_INCREMENT,
8 PRIMARY KEY (`index`)
9) ENGINE=MyISA