· 6 years ago · May 17, 2019, 04:18 PM
1DROP TABLE IF EXISTS `QLqEqiMsDA_users`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `QLqEqiMsDA_users` (
5 `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
6 `username` varchar(120) NOT NULL DEFAULT '',
7 `password` varchar(120) NOT NULL DEFAULT '',
8 `salt` varchar(10) NOT NULL DEFAULT '',
9 `loginkey` varchar(50) NOT NULL DEFAULT '',
10 `email` varchar(220) NOT NULL DEFAULT '',
11 `postnum` int(10) unsigned NOT NULL DEFAULT '0',
12 `awards` int(10) NOT NULL DEFAULT '0',
13 `threadnum` int(10) unsigned NOT NULL DEFAULT '0',
14 `avatar` varchar(200) NOT NULL DEFAULT '',
15 `avatardimensions` varchar(10) NOT NULL DEFAULT '',
16 `avatartype` varchar(10) NOT NULL DEFAULT '0',
17 `usergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
18 `additionalgroups` varchar(200) NOT NULL DEFAULT '',
19 `displaygroup` smallint(5) unsigned NOT NULL DEFAULT '0',
20 `usertitle` varchar(250) NOT NULL DEFAULT '',
21 `regdate` int(10) unsigned NOT NULL DEFAULT '0',
22 `lastactive` int(10) unsigned NOT NULL DEFAULT '0',
23 `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
24 `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
25 `website` varchar(200) NOT NULL DEFAULT '',
26 `icq` varchar(10) NOT NULL DEFAULT '',
27 `aim` varchar(50) NOT NULL DEFAULT '',
28 `yahoo` varchar(50) NOT NULL DEFAULT '',
29 `skype` varchar(75) NOT NULL DEFAULT '',
30 `google` varchar(75) NOT NULL DEFAULT '',
31 `birthday` varchar(15) NOT NULL DEFAULT '',
32 `birthdayprivacy` varchar(4) NOT NULL DEFAULT 'all',
33 `signature` text NOT NULL,
34 `allownotices` tinyint(1) NOT NULL DEFAULT '0',
35 `hideemail` tinyint(1) NOT NULL DEFAULT '0',
36 `subscriptionmethod` tinyint(1) NOT NULL DEFAULT '0',
37 `invisible` tinyint(1) NOT NULL DEFAULT '0',
38 `receivepms` tinyint(1) NOT NULL DEFAULT '0',
39 `receivefrombuddy` tinyint(1) NOT NULL DEFAULT '0',
40 `pmnotice` tinyint(1) NOT NULL DEFAULT '0',
41 `pmnotify` tinyint(1) NOT NULL DEFAULT '0',
42 `buddyrequestspm` tinyint(1) NOT NULL DEFAULT '1',
43 `buddyrequestsauto` tinyint(1) NOT NULL DEFAULT '0',
44 `threadmode` varchar(8) NOT NULL DEFAULT '',
45 `showimages` tinyint(1) NOT NULL DEFAULT '0',
46 `showvideos` tinyint(1) NOT NULL DEFAULT '0',
47 `showsigs` tinyint(1) NOT NULL DEFAULT '0',
48 `showavatars` tinyint(1) NOT NULL DEFAULT '0',
49 `showquickreply` tinyint(1) NOT NULL DEFAULT '0',
50 `showredirect` tinyint(1) NOT NULL DEFAULT '0',
51 `ppp` smallint(6) unsigned NOT NULL DEFAULT '0',
52 `tpp` smallint(6) unsigned NOT NULL DEFAULT '0',
53 `daysprune` smallint(6) unsigned NOT NULL DEFAULT '0',
54 `dateformat` varchar(4) NOT NULL DEFAULT '',
55 `timeformat` varchar(4) NOT NULL DEFAULT '',
56 `timezone` varchar(5) NOT NULL DEFAULT '',
57 `dst` tinyint(1) NOT NULL DEFAULT '0',
58 `dstcorrection` tinyint(1) NOT NULL DEFAULT '0',
59 `buddylist` text NOT NULL,
60 `ignorelist` text NOT NULL,
61 `style` smallint(5) unsigned NOT NULL DEFAULT '0',
62 `away` tinyint(1) NOT NULL DEFAULT '0',
63 `awaydate` int(10) unsigned NOT NULL DEFAULT '0',
64 `returndate` varchar(15) NOT NULL DEFAULT '',
65 `awayreason` varchar(200) NOT NULL DEFAULT '',
66 `pmfolders` text NOT NULL,
67 `notepad` text NOT NULL,
68 `referrer` int(10) unsigned NOT NULL DEFAULT '0',
69 `referrals` int(10) unsigned NOT NULL DEFAULT '0',
70 `reputation` int(11) NOT NULL DEFAULT '0',
71 `regip` varbinary(16) NOT NULL DEFAULT '',
72 `lastip` varbinary(16) NOT NULL DEFAULT '',
73 `language` varchar(50) NOT NULL DEFAULT '',
74 `timeonline` int(10) unsigned NOT NULL DEFAULT '0',
75 `showcodebuttons` tinyint(1) NOT NULL DEFAULT '1',
76 `totalpms` int(10) unsigned NOT NULL DEFAULT '0',
77 `unreadpms` int(10) unsigned NOT NULL DEFAULT '0',
78 `warningpoints` int(3) unsigned NOT NULL DEFAULT '0',
79 `moderateposts` tinyint(1) NOT NULL DEFAULT '0',
80 `moderationtime` int(10) unsigned NOT NULL DEFAULT '0',
81 `suspendposting` tinyint(1) NOT NULL DEFAULT '0',
82 `suspensiontime` int(10) unsigned NOT NULL DEFAULT '0',
83 `suspendsignature` tinyint(1) NOT NULL DEFAULT '0',
84 `suspendsigtime` int(10) unsigned NOT NULL DEFAULT '0',
85 `coppauser` tinyint(1) NOT NULL DEFAULT '0',
86 `classicpostbit` tinyint(1) NOT NULL DEFAULT '0',
87 `loginattempts` smallint(2) unsigned NOT NULL DEFAULT '1',
88 `usernotes` text NOT NULL,
89 `sourceeditor` tinyint(1) NOT NULL DEFAULT '0',
90 `deniedsupport` int(1) NOT NULL DEFAULT '0',
91 `deniedsupportreason` int(5) NOT NULL DEFAULT '0',
92 `deniedsupportuid` int(10) NOT NULL DEFAULT '0',
93 `mysupportdisplayastext` int(1) NOT NULL DEFAULT '0',
94 `myalerts_disabled_alert_types` text NOT NULL,
95 `tyl_unumtyls` int(100) NOT NULL DEFAULT '0',
96 `tyl_unumrcvtyls` int(100) NOT NULL DEFAULT '0',
97 `tyl_unumptyls` int(100) NOT NULL DEFAULT '0',
98 `socialsites` text NOT NULL,
99 `twostepauth_secret` text NOT NULL,
100 `twostepauth_enabled` int(1) NOT NULL DEFAULT '0',
101 `twostepauth_hide_hint` int(1) NOT NULL DEFAULT '0',
102 `twostepauth_method` int(1) NOT NULL DEFAULT '1',
103 `newpoints` decimal(16,2) NOT NULL DEFAULT '0.00',
104 `vouches` int(11) NOT NULL DEFAULT '0',
105 `themeColor` varchar(7) DEFAULT NULL,
106 `password_changes` int(11) NOT NULL DEFAULT '0',
107 `myrewards_last_alert` int(11) NOT NULL,
108 `newpoints_items` text NOT NULL,
109 `newpoints_display_item` int(11) DEFAULT NULL,
110 `2fa_enabled` tinyint(1) DEFAULT '0',
111 `2fa_secret` varchar(255) DEFAULT NULL,
112 `postbitBackground` varchar(196) DEFAULT NULL,
113 `newpoints_donate_token` varchar(255) NOT NULL DEFAULT '',
114 `profilmuzigi173` varchar(300) DEFAULT NULL,
115 `profilmuzigiacik` tinyint(1) NOT NULL DEFAULT '1',
116 `profilebg` varchar(200) NOT NULL DEFAULT '',
117 `profilebgdimensions` varchar(10) NOT NULL DEFAULT '',
118 `profilebgtype` varchar(10) NOT NULL DEFAULT '',
119 PRIMARY KEY (`uid`),
120 UNIQUE KEY `username` (`username`),
121 KEY `usergroup` (`usergroup`),
122 KEY `regip` (`regip`),
123 KEY `lastip` (`lastip`)
124) ENGINE=InnoDB AUTO_INCREMENT=113899 DEFAULT CHARSET=utf8;
125/*!40101 SET character_set_client = @saved_cs_client */;