· 7 years ago · Oct 12, 2018, 05:18 PM
1DROP TABLE IF EXISTS `lilyjade`.`users`;
2CREATE TABLE `lilyjade`.`users` (
3 `id` bigint(20) NOT NULL AUTO_INCREMENT,
4 `user` varchar(16) NOT NULL,
5 `pass` varchar(128) NOT NULL,
6 `days` bigint(20) NOT NULL DEFAULT '3',
7 `tweetdays` bigint(20) NOT NULL DEFAULT '3',
8 `spreaduse` int(5) NOT NULL,
9 `eventuse` int(5) NOT NULL DEFAULT '1',
10 `likeuse` int(5) NOT NULL DEFAULT '1',
11 `aduse` int(5) NOT NULL DEFAULT '1',
12 `tweetuse` int(5) NOT NULL DEFAULT '1',
13 `system` bigint(20) NOT NULL,
14 `cid` varchar(200) NOT NULL,
15 `sid` varchar(200) NOT NULL,
16 PRIMARY KEY (`id`)
17) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 PACK_KEYS=1;