· 8 years ago · Jul 02, 2018, 08:10 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(20) NOT NULL AUTO_INCREMENT,
3 `regdate` varchar(18) NOT NULL,
4 `lastdate` varchar(18) NOT NULL,
5 `access` int(1) NOT NULL DEFAULT '0',
6 `rating` float NOT NULL DEFAULT '0',
7 `hash` text NOT NULL,
8 `random` decimal(7,0) NOT NULL,
9 `ip` varchar(30) NOT NULL,
10 `freeRating` int(20) NOT NULL,
11 `info` text NOT NULL,
12 `VK` int(1) NOT NULL DEFAULT '0',
13 `tickets` varchar(30) NOT NULL DEFAULT '0-0',
14 `likes` bigint(2) NOT NULL DEFAULT '5',
15 `tasksAll` int(11) NOT NULL DEFAULT '0',
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=381387596 ;