Lines Matching full:null
30 `gid` smallint(5) unsigned NOT NULL,
31 `type` tinyint(1) unsigned NOT NULL DEFAULT '2',
32 `title` varchar(120) NOT NULL DEFAULT '',
33 `description` text NOT NULL DEFAULT '',
34 `namestyle` varchar(200) NOT NULL DEFAULT '{username}',
35 `usertitle` varchar(120) NOT NULL DEFAULT '',
36 `stars` smallint(4) unsigned NOT NULL DEFAULT '0',
37 `starimage` varchar(120) NOT NULL DEFAULT '',
38 `image` varchar(120) NOT NULL DEFAULT '',
39 `disporder` smallint(6) unsigned NOT NULL DEFAULT '0',
40 `isbannedgroup` tinyint(1) NOT NULL DEFAULT '0',
41 `canview` tinyint(1) NOT NULL DEFAULT '0',
42 `canviewthreads` tinyint(1) NOT NULL DEFAULT '0',
43 `canviewprofiles` tinyint(1) NOT NULL DEFAULT '0',
44 `candlattachments` tinyint(1) NOT NULL DEFAULT '0',
45 `canviewboardclosed` tinyint(1) NOT NULL DEFAULT '0',
46 `canpostthreads` tinyint(1) NOT NULL DEFAULT '0',
47 `canpostreplys` tinyint(1) NOT NULL DEFAULT '0',
48 `canpostattachments` tinyint(1) NOT NULL DEFAULT '0',
49 `canratethreads` tinyint(1) NOT NULL DEFAULT '0',
50 `modposts` tinyint(1) NOT NULL DEFAULT '0',
51 `modthreads` tinyint(1) NOT NULL DEFAULT '0',
52 `mod_edit_posts` tinyint(1) NOT NULL DEFAULT '0',
53 `modattachments` tinyint(1) NOT NULL DEFAULT '0',
54 `caneditposts` tinyint(1) NOT NULL DEFAULT '0',
55 `candeleteposts` tinyint(1) NOT NULL DEFAULT '0',
56 `candeletethreads` tinyint(1) NOT NULL DEFAULT '0',
57 `caneditattachments` tinyint(1) NOT NULL DEFAULT '0',
58 `canpostpolls` tinyint(1) NOT NULL DEFAULT '0',
59 `canvotepolls` tinyint(1) NOT NULL DEFAULT '0',
60 `canundovotes` tinyint(1) NOT NULL DEFAULT '0',
61 `canusepms` tinyint(1) NOT NULL DEFAULT '0',
62 `cansendpms` tinyint(1) NOT NULL DEFAULT '0',
63 `cantrackpms` tinyint(1) NOT NULL DEFAULT '0',
64 `candenypmreceipts` tinyint(1) NOT NULL DEFAULT '0',
65 `pmquota` int(3) unsigned NOT NULL DEFAULT '0',
66 `maxpmrecipients` int(4) unsigned NOT NULL DEFAULT '5',
67 `cansendemail` tinyint(1) NOT NULL DEFAULT '0',
68 `cansendemailoverride` tinyint(1) NOT NULL DEFAULT '0',
69 `maxemails` int(3) unsigned NOT NULL DEFAULT '5',
70 `emailfloodtime` int(3) unsigned NOT NULL DEFAULT '5',
71 `canviewmemberlist` tinyint(1) NOT NULL DEFAULT '0',
72 `canviewcalendar` tinyint(1) NOT NULL DEFAULT '0',
73 `canaddevents` tinyint(1) NOT NULL DEFAULT '0',
74 `canbypasseventmod` tinyint(1) NOT NULL DEFAULT '0',
75 `canmoderateevents` tinyint(1) NOT NULL DEFAULT '0',
76 `canviewonline` tinyint(1) NOT NULL DEFAULT '0',
77 `canviewwolinvis` tinyint(1) NOT NULL DEFAULT '0',
78 `canviewonlineips` tinyint(1) NOT NULL DEFAULT '0',
79 `cancp` tinyint(1) NOT NULL DEFAULT '0',
80 `issupermod` tinyint(1) NOT NULL DEFAULT '0',
81 `cansearch` tinyint(1) NOT NULL DEFAULT '0',
82 `canusercp` tinyint(1) NOT NULL DEFAULT '0',
83 `canuploadavatars` tinyint(1) NOT NULL DEFAULT '0',
84 `canratemembers` tinyint(1) NOT NULL DEFAULT '0',
85 `canchangename` tinyint(1) NOT NULL DEFAULT '0',
86 `canbereported` tinyint(1) NOT NULL DEFAULT '0',
87 `canchangewebsite` tinyint(1) NOT NULL DEFAULT '1',
88 `showforumteam` tinyint(1) NOT NULL DEFAULT '0',
89 `usereputationsystem` tinyint(1) NOT NULL DEFAULT '0',
90 `cangivereputations` tinyint(1) NOT NULL DEFAULT '0',
91 `candeletereputations` tinyint(1) NOT NULL DEFAULT '0',
92 `reputationpower` int(10) unsigned NOT NULL DEFAULT '0',
93 `maxreputationsday` int(10) unsigned NOT NULL DEFAULT '0',
94 `maxreputationsperuser` int(10) unsigned NOT NULL DEFAULT '0',
95 `maxreputationsperthread` int(10) unsigned NOT NULL DEFAULT '0',
96 `candisplaygroup` tinyint(1) NOT NULL DEFAULT '0',
97 `attachquota` int(10) unsigned NOT NULL DEFAULT '0',
98 `cancustomtitle` tinyint(1) NOT NULL DEFAULT '0',
99 `canwarnusers` tinyint(1) NOT NULL DEFAULT '0',
100 `canreceivewarnings` tinyint(1) NOT NULL DEFAULT '0',
101 `maxwarningsday` int(3) unsigned NOT NULL DEFAULT '3',
102 `canmodcp` tinyint(1) NOT NULL DEFAULT '0',
103 `showinbirthdaylist` tinyint(1) NOT NULL DEFAULT '0',
104 `canoverridepm` tinyint(1) NOT NULL DEFAULT '0',
105 `canusesig` tinyint(1) NOT NULL DEFAULT '0',
106 `canusesigxposts` smallint(5) unsigned NOT NULL DEFAULT '0',
107 `signofollow` tinyint(1) NOT NULL DEFAULT '0',
108 `edittimelimit` int(4) unsigned NOT NULL DEFAULT '0',
109 `maxposts` int(4) unsigned NOT NULL DEFAULT '0',
110 `showmemberlist` tinyint(1) NOT NULL DEFAULT '1',
111 `canmanageannounce` tinyint(1) NOT NULL DEFAULT '0',
112 `canmanagemodqueue` tinyint(1) NOT NULL DEFAULT '0',
113 `canmanagereportedcontent` tinyint(1) NOT NULL DEFAULT '0',
114 `canviewmodlogs` tinyint(1) NOT NULL DEFAULT '0',
115 `caneditprofiles` tinyint(1) NOT NULL DEFAULT '0',
116 `canbanusers` tinyint(1) NOT NULL DEFAULT '0',
117 `canviewwarnlogs` tinyint(1) NOT NULL DEFAULT '0',
118 `canuseipsearch` tinyint(1) NOT NULL DEFAULT '0'
152 MODIFY `gid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
185 `uid` int(10) unsigned NOT NULL,
186 `username` varchar(120) NOT NULL DEFAULT '',
187 `password` varchar(120) NOT NULL DEFAULT '',
188 `salt` varchar(10) NOT NULL DEFAULT '',
189 `loginkey` varchar(50) NOT NULL DEFAULT '',
190 `email` varchar(220) NOT NULL DEFAULT '',
191 `postnum` int(10) unsigned NOT NULL DEFAULT '0',
192 `threadnum` int(10) unsigned NOT NULL DEFAULT '0',
193 `avatar` varchar(200) NOT NULL DEFAULT '',
194 `avatardimensions` varchar(10) NOT NULL DEFAULT '',
195 `avatartype` varchar(10) NOT NULL DEFAULT '0',
196 `usergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
197 `additionalgroups` varchar(200) NOT NULL DEFAULT '',
198 `displaygroup` smallint(5) unsigned NOT NULL DEFAULT '0',
199 `usertitle` varchar(250) NOT NULL DEFAULT '',
200 `regdate` int(10) unsigned NOT NULL DEFAULT '0',
201 `lastactive` int(10) unsigned NOT NULL DEFAULT '0',
202 `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
203 `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
204 `website` varchar(200) NOT NULL DEFAULT '',
205 `icq` varchar(10) NOT NULL DEFAULT '',
206 `aim` varchar(50) NOT NULL DEFAULT '',
207 `yahoo` varchar(50) NOT NULL DEFAULT '',
208 `skype` varchar(75) NOT NULL DEFAULT '',
209 `google` varchar(75) NOT NULL DEFAULT '',
210 `birthday` varchar(15) NOT NULL DEFAULT '',
211 `birthdayprivacy` varchar(4) NOT NULL DEFAULT 'all',
212 `signature` text NOT NULL DEFAULT '',
213 `allownotices` tinyint(1) NOT NULL DEFAULT '0',
214 `hideemail` tinyint(1) NOT NULL DEFAULT '0',
215 `subscriptionmethod` tinyint(1) NOT NULL DEFAULT '0',
216 `invisible` tinyint(1) NOT NULL DEFAULT '0',
217 `receivepms` tinyint(1) NOT NULL DEFAULT '0',
218 `receivefrombuddy` tinyint(1) NOT NULL DEFAULT '0',
219 `pmnotice` tinyint(1) NOT NULL DEFAULT '0',
220 `pmnotify` tinyint(1) NOT NULL DEFAULT '0',
221 `buddyrequestspm` tinyint(1) NOT NULL DEFAULT '1',
222 `buddyrequestsauto` tinyint(1) NOT NULL DEFAULT '0',
223 `threadmode` varchar(8) NOT NULL DEFAULT '',
224 `showimages` tinyint(1) NOT NULL DEFAULT '0',
225 `showvideos` tinyint(1) NOT NULL DEFAULT '0',
226 `showsigs` tinyint(1) NOT NULL DEFAULT '0',
227 `showavatars` tinyint(1) NOT NULL DEFAULT '0',
228 `showquickreply` tinyint(1) NOT NULL DEFAULT '0',
229 `showredirect` tinyint(1) NOT NULL DEFAULT '0',
230 `ppp` smallint(6) unsigned NOT NULL DEFAULT '0',
231 `tpp` smallint(6) unsigned NOT NULL DEFAULT '0',
232 `daysprune` smallint(6) unsigned NOT NULL DEFAULT '0',
233 `dateformat` varchar(4) NOT NULL DEFAULT '',
234 `timeformat` varchar(4) NOT NULL DEFAULT '',
235 `timezone` varchar(5) NOT NULL DEFAULT '',
236 `dst` tinyint(1) NOT NULL DEFAULT '0',
237 `dstcorrection` tinyint(1) NOT NULL DEFAULT '0',
238 `buddylist` text NOT NULL DEFAULT '',
239 `ignorelist` text NOT NULL DEFAULT '',
240 `style` smallint(5) unsigned NOT NULL DEFAULT '0',
241 `away` tinyint(1) NOT NULL DEFAULT '0',
242 `awaydate` int(10) unsigned NOT NULL DEFAULT '0',
243 `returndate` varchar(15) NOT NULL DEFAULT '',
244 `awayreason` varchar(200) NOT NULL DEFAULT '',
245 `pmfolders` text NOT NULL DEFAULT '',
246 `notepad` text NOT NULL DEFAULT '',
247 `referrer` int(10) unsigned NOT NULL DEFAULT '0',
248 `referrals` int(10) unsigned NOT NULL DEFAULT '0',
249 `reputation` int(11) NOT NULL DEFAULT '0',
250 `regip` varbinary(16) NOT NULL DEFAULT '',
251 `lastip` varbinary(16) NOT NULL DEFAULT '',
252 `language` varchar(50) NOT NULL DEFAULT '',
253 `timeonline` int(10) unsigned NOT NULL DEFAULT '0',
254 `showcodebuttons` tinyint(1) NOT NULL DEFAULT '1',
255 `totalpms` int(10) unsigned NOT NULL DEFAULT '0',
256 `unreadpms` int(10) unsigned NOT NULL DEFAULT '0',
257 `warningpoints` int(3) unsigned NOT NULL DEFAULT '0',
258 `moderateposts` tinyint(1) NOT NULL DEFAULT '0',
259 `moderationtime` int(10) unsigned NOT NULL DEFAULT '0',
260 `suspendposting` tinyint(1) NOT NULL DEFAULT '0',
261 `suspensiontime` int(10) unsigned NOT NULL DEFAULT '0',
262 `suspendsignature` tinyint(1) NOT NULL DEFAULT '0',
263 `suspendsigtime` int(10) unsigned NOT NULL DEFAULT '0',
264 `coppauser` tinyint(1) NOT NULL DEFAULT '0',
265 `classicpostbit` tinyint(1) NOT NULL DEFAULT '0',
266 `loginattempts` smallint(2) unsigned NOT NULL DEFAULT '1',
267 `usernotes` text NOT NULL DEFAULT '',
268 `sourceeditor` tinyint(1) NOT NULL DEFAULT '0'
303 MODIFY `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=88;