· 8 years ago · Dec 24, 2017, 08:22 AM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(10) unsigned NOT NULL auto_increment,
3 `username` varchar(40) character set latin1 collate latin1_general_ci NOT NULL default '',
4 `passhash` varchar(32) character set latin1 collate latin1_general_ci NOT NULL default '',
5 `secret` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
6 `email` varchar(80) character set latin1 collate latin1_general_ci NOT NULL default '',
7 `status` enum('pending','confirmed') character set latin1 collate latin1_general_ci NOT NULL default 'pending',
8 `added` int(11) NOT NULL default '0',
9 `last_login` int(11) NOT NULL default '0',
10 `last_access` int(11) NOT NULL default '0',
11 `editsecret` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
12 `privacy` enum('strong','normal','low') character set latin1 collate latin1_general_ci NOT NULL default 'normal',
13 `stylesheet` int(10) default '1',
14 `info` text character set latin1 collate latin1_general_ci,
15 `acceptpms` enum('yes','friends','no') character set latin1 collate latin1_general_ci NOT NULL default 'yes',
16 `ip` varchar(15) character set latin1 collate latin1_general_ci NOT NULL default '',
17 `class` tinyint(3) unsigned NOT NULL default '0',
18 `time_offset` varchar(5) NOT NULL,
19 `dst_in_use` tinyint(1) NOT NULL default '0',
20 `auto_correct_dst` tinyint(1) NOT NULL default '1',
21 `avatar` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default '',
22 `av_w` smallint(3) unsigned NOT NULL default '0',
23 `av_h` smallint(3) unsigned NOT NULL default '0',
24 `title` varchar(30) character set latin1 collate latin1_general_ci NOT NULL default '',
25 `country` int(10) unsigned NOT NULL default '0',
26 `notifs` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default '',
27 `modcomment` text character set latin1 collate latin1_general_ci NOT NULL,
28 `enabled` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'yes',
29 `avatars` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'yes',
30 `donor` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'no',
31 `warned` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'no',
32 `warneduntil` int(11) NOT NULL default '0',
33 `topicsperpage` int(3) unsigned NOT NULL default '0',
34 `postsperpage` int(3) unsigned NOT NULL default '0',
35 `deletepms` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'yes',
36 `savepms` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'no',
37 PRIMARY KEY (`id`),
38 UNIQUE KEY `username` (`username`),
39 KEY `ip` (`ip`),
40 KEY `country` (`country`),
41 KEY `last_access` (`last_access`),
42 KEY `enabled` (`enabled`),
43 KEY `warned` (`warned`)
44) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;