· 8 years ago · Dec 26, 2017, 08:18 AM
1DROP TABLE IF EXISTS `plimus`;
2CREATE TABLE `plimus` (
3 `id` int(10) NOT NULL AUTO_INCREMENT,
4 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
5 `username` varchar(15) DEFAULT NULL,
6 `item` int(5) DEFAULT NULL,
7 `quantity` smallint(5) DEFAULT NULL,
8 `given` tinyint(1) NOT NULL DEFAULT '0',
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;