· 7 years ago · Feb 22, 2019, 04:44 PM
1DROP TABLE IF EXISTS `logs`;
2CREATE TABLE `logs` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `typ` text NOT NULL,
5 `name` varchar(32) NOT NULL,
6 `uid` varchar(64) NOT NULL,
7 `tname` varchar(32) NOT NULL,
8 `tuid` varchar(64) NOT NULL,
9 `value` int(100) NOT NULL,
10 `item` text NOT NULL,
11 `bank` int(100) NOT NULL,
12 `cash` int(100) NOT NULL,
13 `temp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
14 PRIMARY KEY (`id`)
15) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;