· 5 years ago · Mar 01, 2020, 06:18 AM
1DROP TABLE IF EXISTS `vb_user`;
2CREATE TABLE `vb_user` (
3 `userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
5 `membergroupids` char(250) CHARACTER SET latin1 NOT NULL DEFAULT '',
6 `displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
7 `username` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
8 `password` char(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
9 `passworddate` date NOT NULL DEFAULT '0000-00-00',
10 `email` char(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
11 `styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
12 `parentemail` char(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
13 `homepage` char(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
14 `icq` char(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
15 `aim` char(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
16 `yahoo` char(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
17 `msn` char(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
18 `skype` char(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
19 `showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
20 `showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
21 `usertitle` char(250) CHARACTER SET latin1 NOT NULL DEFAULT '',
22 `customtitle` smallint(6) NOT NULL DEFAULT '0',
23 `joindate` int(10) unsigned NOT NULL DEFAULT '0',
24 `daysprune` smallint(6) NOT NULL DEFAULT '0',
25 `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
26 `lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
27 `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
28 `lastpostid` int(10) unsigned NOT NULL DEFAULT '0',
29 `posts` int(10) unsigned NOT NULL DEFAULT '0',
30 `reputation` int(11) NOT NULL DEFAULT '10',
31 `reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1',
32 `timezoneoffset` char(4) CHARACTER SET latin1 NOT NULL DEFAULT '',
33 `pmpopup` smallint(6) NOT NULL DEFAULT '0',
34 `avatarid` smallint(6) NOT NULL DEFAULT '0',
35 `avatarrevision` int(10) unsigned NOT NULL DEFAULT '0',
36 `profilepicrevision` int(10) unsigned NOT NULL DEFAULT '0',
37 `sigpicrevision` int(10) unsigned NOT NULL DEFAULT '0',
38 `options` int(10) unsigned NOT NULL DEFAULT '33570831',
39 `birthday` char(10) CHARACTER SET latin1 NOT NULL DEFAULT '',
40 `birthday_search` date NOT NULL DEFAULT '0000-00-00',
41 `maxposts` smallint(6) NOT NULL DEFAULT '-1',
42 `startofweek` smallint(6) NOT NULL DEFAULT '1',
43 `ipaddress` char(15) CHARACTER SET latin1 NOT NULL DEFAULT '',
44 `referrerid` int(10) unsigned NOT NULL DEFAULT '0',
45 `languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
46 `emailstamp` int(10) unsigned NOT NULL DEFAULT '0',
47 `threadedmode` smallint(5) unsigned NOT NULL DEFAULT '0',
48 `autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
49 `pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
50 `pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
51 `salt` char(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
52 `ipoints` int(10) unsigned NOT NULL DEFAULT '0',
53 `infractions` int(10) unsigned NOT NULL DEFAULT '0',
54 `warnings` int(10) unsigned NOT NULL DEFAULT '0',
55 `infractiongroupids` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
56 `infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
57 `adminoptions` int(10) unsigned NOT NULL DEFAULT '0',
58 `profilevisits` int(10) unsigned NOT NULL DEFAULT '0',
59 `friendcount` int(10) unsigned NOT NULL DEFAULT '0',
60 `friendreqcount` int(10) unsigned NOT NULL DEFAULT '0',
61 `vmunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
62 `vmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
63 `socgroupinvitecount` int(10) unsigned NOT NULL DEFAULT '0',
64 `socgroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
65 `pcunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
66 `pcmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
67 `gmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
68 `assetposthash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
69 `fbuserid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
70 `fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
71 `fbname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
72 `logintype` enum('vb','fb') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'vb',
73 `fbaccesstoken` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
74 `newrepcount` smallint(5) unsigned NOT NULL DEFAULT '0',
75 `panjo_selling` tinyint(1) DEFAULT NULL,
76 `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
77 PRIMARY KEY (`userid`),
78 KEY `usergroupid` (`usergroupid`),
79 KEY `username` (`username`),
80 KEY `birthday` (`birthday`,`showbirthday`),
81 KEY `birthday_search` (`birthday_search`),
82 KEY `referrerid` (`referrerid`),
83 KEY `fbuserid` (`fbuserid`),
84 KEY `email` (`email`),
85 KEY `lastactivity` (`lastactivity`)
86) ENGINE=InnoDB AUTO_INCREMENT=1405673 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;