Zeile 29 | Zeile 29 |
---|
defaultviews text NOT NULL, loginattempts smallint unsigned NOT NULL default '0', loginlockoutexpiry int unsigned NOT NULL default '0',
|
defaultviews text NOT NULL, loginattempts smallint unsigned NOT NULL default '0', loginlockoutexpiry int unsigned NOT NULL default '0',
|
| authsecret varchar(16) NOT NULL default '', recovery_codes varchar(177) NOT NULL default '',
|
PRIMARY KEY (uid) ) ENGINE=MyISAM;";
| PRIMARY KEY (uid) ) ENGINE=MyISAM;";
|
Zeile 40 | Zeile 42 |
---|
dateline int unsigned NOT NULL default '0', lastactive int unsigned NOT NULL default '0', data TEXT NOT NULL,
|
dateline int unsigned NOT NULL default '0', lastactive int unsigned NOT NULL default '0', data TEXT NOT NULL,
|
useragent varchar(100) NOT NULL default ''
| useragent varchar(200) NOT NULL default '', authenticated tinyint(1) NOT NULL default '0'
|
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_adminviews (
| ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_adminviews (
|
Zeile 54 | Zeile 57 |
---|
custom_profile_fields text NOT NULL, sortby varchar(20) NOT NULL default '', sortorder varchar(4) NOT NULL default '',
|
custom_profile_fields text NOT NULL, sortby varchar(20) NOT NULL default '', sortorder varchar(4) NOT NULL default '',
|
perpage smallint(4) NOT NULL default '0',
| perpage smallint(4) unsigned NOT NULL default '0',
|
view_type varchar(6) NOT NULL default '', PRIMARY KEY (vid) ) ENGINE=MyISAM;";
| view_type varchar(6) NOT NULL default '', PRIMARY KEY (vid) ) ENGINE=MyISAM;";
|
Zeile 79 | Zeile 82 |
---|
pid int unsigned NOT NULL default '0', posthash varchar(50) NOT NULL default '', uid int unsigned NOT NULL default '0',
|
pid int unsigned NOT NULL default '0', posthash varchar(50) NOT NULL default '', uid int unsigned NOT NULL default '0',
|
filename varchar(120) NOT NULL default '',
| filename varchar(255) NOT NULL default '',
|
filetype varchar(120) NOT NULL default '',
|
filetype varchar(120) NOT NULL default '',
|
filesize int(10) NOT NULL default '0', attachname varchar(120) NOT NULL default '',
| filesize int(10) unsigned NOT NULL default '0', attachname varchar(255) NOT NULL default '',
|
downloads int unsigned NOT NULL default '0', dateuploaded int unsigned NOT NULL default '0', visible tinyint(1) NOT NULL default '0',
| downloads int unsigned NOT NULL default '0', dateuploaded int unsigned NOT NULL default '0', visible tinyint(1) NOT NULL default '0',
|
Zeile 97 | Zeile 100 |
---|
name varchar(120) NOT NULL default '', mimetype varchar(120) NOT NULL default '', extension varchar(10) NOT NULL default '',
|
name varchar(120) NOT NULL default '', mimetype varchar(120) NOT NULL default '', extension varchar(10) NOT NULL default '',
|
maxsize int(15) NOT NULL default '0',
| maxsize int(15) unsigned NOT NULL default '0',
|
icon varchar(100) NOT NULL default '',
|
icon varchar(100) NOT NULL default '',
|
| enabled tinyint(1) NOT NULL default '1', forcedownload tinyint(1) NOT NULL default '0', `groups` TEXT NOT NULL, forums TEXT NOT NULL, avatarfile tinyint(1) NOT NULL default '0',
|
PRIMARY KEY (atid) ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_awaitingactivation ( aid int unsigned NOT NULL auto_increment,
|
PRIMARY KEY (atid) ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_awaitingactivation ( aid int unsigned NOT NULL auto_increment,
|
uid int unsigned NOT NULL default '0',
| uid int unsigned NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0', code varchar(100) NOT NULL default '', type char(1) NOT NULL default '',
| dateline int unsigned NOT NULL default '0', code varchar(100) NOT NULL default '', type char(1) NOT NULL default '',
|
Zeile 116 | Zeile 124 |
---|
$tables[] = "CREATE TABLE mybb_badwords ( bid int unsigned NOT NULL auto_increment, badword varchar(100) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_badwords ( bid int unsigned NOT NULL auto_increment, badword varchar(100) NOT NULL default '',
|
| regex tinyint(1) NOT NULL default '0',
|
replacement varchar(100) NOT NULL default '', PRIMARY KEY (bid) ) ENGINE=MyISAM;";
| replacement varchar(100) NOT NULL default '', PRIMARY KEY (bid) ) ENGINE=MyISAM;";
|
Zeile 135 | Zeile 144 |
---|
gid int unsigned NOT NULL default '0', oldgroup int unsigned NOT NULL default '0', oldadditionalgroups text NOT NULL,
|
gid int unsigned NOT NULL default '0', oldgroup int unsigned NOT NULL default '0', oldadditionalgroups text NOT NULL,
|
olddisplaygroup int NOT NULL default '0', admin int unsigned NOT NULL default '0',
| olddisplaygroup int unsigned NOT NULL default '0', `admin` int unsigned NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0', bantime varchar(50) NOT NULL default '', lifted int unsigned NOT NULL default '0',
| dateline int unsigned NOT NULL default '0', bantime varchar(50) NOT NULL default '', lifted int unsigned NOT NULL default '0',
|
Zeile 146 | Zeile 155 |
---|
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_buddyrequests (
|
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_buddyrequests (
|
id int(10) UNSIGNED NOT NULL auto_increment, uid bigint(30) UNSIGNED NOT NULL, touid bigint(30) UNSIGNED NOT NULL, date int(11) UNSIGNED NOT NULL, KEY (uid), KEY (touid), PRIMARY KEY (id)
| id int(10) unsigned NOT NULL auto_increment, uid int unsigned NOT NULL default '0', touid int unsigned NOT NULL default '0', date int unsigned NOT NULL default '0', KEY (uid), KEY (touid), PRIMARY KEY (id)
|
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_calendars (
| ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_calendars (
|
Zeile 161 | Zeile 170 |
---|
disporder smallint unsigned NOT NULL default '0', startofweek tinyint(1) NOT NULL default '0', showbirthdays tinyint(1) NOT NULL default '0',
|
disporder smallint unsigned NOT NULL default '0', startofweek tinyint(1) NOT NULL default '0', showbirthdays tinyint(1) NOT NULL default '0',
|
eventlimit smallint(3) NOT NULL default '0',
| eventlimit smallint(3) unsigned NOT NULL default '0',
|
moderation tinyint(1) NOT NULL default '0', allowhtml tinyint(1) NOT NULL default '0', allowmycode tinyint(1) NOT NULL default '0',
| moderation tinyint(1) NOT NULL default '0', allowhtml tinyint(1) NOT NULL default '0', allowmycode tinyint(1) NOT NULL default '0',
|
Zeile 245 | Zeile 254 |
---|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
| canviewdeletionnotice tinyint(1) NOT NULL default '0',
|
modposts tinyint(1) NOT NULL default '0', modthreads tinyint(1) NOT NULL default '0', mod_edit_posts tinyint(1) NOT NULL default '0',
| modposts tinyint(1) NOT NULL default '0', modthreads tinyint(1) NOT NULL default '0', mod_edit_posts tinyint(1) NOT NULL default '0',
|
Zeile 380 | Zeile 390 |
---|
sentcount int unsigned NOT NULL default '0', totalcount int unsigned NOT NULL default '0', conditions text NOT NULL,
|
sentcount int unsigned NOT NULL default '0', totalcount int unsigned NOT NULL default '0', conditions text NOT NULL,
|
perpage smallint(4) NOT NULL default '50', PRIMARY KEY (mid) ) ENGINE=MyISAM;";
| perpage smallint(4) unsigned NOT NULL default '50', PRIMARY KEY (mid) ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_mailerrors ( eid int unsigned NOT NULL auto_increment, subject varchar(200) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_mailerrors ( eid int unsigned NOT NULL auto_increment, subject varchar(200) NOT NULL default '',
|
Zeile 473 | Zeile 483 |
---|
name varchar(200) NOT NULL, description text NOT NULL, forums text NOT NULL,
|
name varchar(200) NOT NULL, description text NOT NULL, forums text NOT NULL,
|
groups text NOT NULL,
| `groups` text NOT NULL,
|
type char(1) NOT NULL default '', postoptions text NOT NULL, threadoptions text NOT NULL,
| type char(1) NOT NULL default '', postoptions text NOT NULL, threadoptions text NOT NULL,
|
Zeile 515 | Zeile 525 |
---|
uid int unsigned NOT NULL default '0', voteoption smallint unsigned NOT NULL default '0', dateline int unsigned NOT NULL default '0',
|
uid int unsigned NOT NULL default '0', voteoption smallint unsigned NOT NULL default '0', dateline int unsigned NOT NULL default '0',
|
| ipaddress varbinary(16) NOT NULL default '',
|
KEY pid (pid, uid), PRIMARY KEY (vid) ) ENGINE=MyISAM;";
| KEY pid (pid, uid), PRIMARY KEY (vid) ) ENGINE=MyISAM;";
|
Zeile 600 | Zeile 611 |
---|
description text NOT NULL, enabled tinyint(1) NOT NULL default '1', logging tinyint(1) NOT NULL default '0',
|
description text NOT NULL, enabled tinyint(1) NOT NULL default '1', logging tinyint(1) NOT NULL default '0',
|
posts int NOT NULL default '0',
| posts int unsigned NOT NULL default '0',
|
posttype char(2) NOT NULL default '',
|
posttype char(2) NOT NULL default '',
|
threads int NOT NULL default '0',
| threads int unsigned NOT NULL default '0',
|
threadtype char(2) NOT NULL default '',
|
threadtype char(2) NOT NULL default '',
|
registered int NOT NULL default '0',
| registered int unsigned NOT NULL default '0',
|
registeredtype varchar(20) NOT NULL default '',
|
registeredtype varchar(20) NOT NULL default '',
|
online int NOT NULL default '0',
| online int unsigned NOT NULL default '0',
|
onlinetype varchar(20) NOT NULL default '', reputations int NOT NULL default '0', reputationtype char(2) NOT NULL default '',
|
onlinetype varchar(20) NOT NULL default '', reputations int NOT NULL default '0', reputationtype char(2) NOT NULL default '',
|
referrals int NOT NULL default '0',
| referrals int unsigned NOT NULL default '0',
|
referralstype char(2) NOT NULL default '',
|
referralstype char(2) NOT NULL default '',
|
warnings int NOT NULL default '0',
| warnings int unsigned NOT NULL default '0',
|
warningstype char(2) NOT NULL default '', requirements varchar(200) NOT NULL default '', originalusergroup varchar(120) NOT NULL default '0', newusergroup smallint unsigned NOT NULL default '0', usergrouptype varchar(120) NOT NULL default '0', PRIMARY KEY (pid)
|
warningstype char(2) NOT NULL default '', requirements varchar(200) NOT NULL default '', originalusergroup varchar(120) NOT NULL default '0', newusergroup smallint unsigned NOT NULL default '0', usergrouptype varchar(120) NOT NULL default '0', PRIMARY KEY (pid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_promotionlogs ( plid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_promotionlogs ( plid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default '0',
|
Zeile 641 | Zeile 652 |
---|
incorrect int unsigned NOT NULL default 0, active tinyint(1) NOT NULL default '0', PRIMARY KEY (qid)
|
incorrect int unsigned NOT NULL default 0, active tinyint(1) NOT NULL default '0', PRIMARY KEY (qid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_questionsessions ( sid varchar(32) NOT NULL default '', qid int unsigned NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_questionsessions ( sid varchar(32) NOT NULL default '', qid int unsigned NOT NULL default '0',
|
Zeile 657 | Zeile 668 |
---|
id3 int unsigned NOT NULL default '0', uid int unsigned NOT NULL default '0', reportstatus tinyint(1) NOT NULL default '0',
|
id3 int unsigned NOT NULL default '0', uid int unsigned NOT NULL default '0', reportstatus tinyint(1) NOT NULL default '0',
|
| reasonid smallint unsigned NOT NULL default '0',
|
reason varchar(250) NOT NULL default '', type varchar(50) NOT NULL default '', reports int unsigned NOT NULL default '0',
| reason varchar(250) NOT NULL default '', type varchar(50) NOT NULL default '', reports int unsigned NOT NULL default '0',
|
Zeile 665 | Zeile 677 |
---|
lastreport int unsigned NOT NULL default '0', KEY reportstatus (reportstatus), KEY lastreport (lastreport),
|
lastreport int unsigned NOT NULL default '0', KEY reportstatus (reportstatus), KEY lastreport (lastreport),
|
| PRIMARY KEY (rid) ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_reportreasons ( rid int unsigned NOT NULL auto_increment, title varchar(250) NOT NULL default '', appliesto varchar(250) NOT NULL default '', extra tinyint(1) NOT NULL default '0', disporder smallint unsigned NOT NULL default '0',
|
PRIMARY KEY (rid) ) ENGINE=MyISAM;";
| PRIMARY KEY (rid) ) ENGINE=MyISAM;";
|
Zeile 699 | Zeile 720 |
---|
ip varbinary(16) NOT NULL default '', time int unsigned NOT NULL default '0', location varchar(150) NOT NULL default '',
|
ip varbinary(16) NOT NULL default '', time int unsigned NOT NULL default '0', location varchar(150) NOT NULL default '',
|
useragent varchar(100) NOT NULL default '',
| useragent varchar(200) NOT NULL default '',
|
anonymous tinyint(1) NOT NULL default '0', nopermission tinyint(1) NOT NULL default '0',
|
anonymous tinyint(1) NOT NULL default '0', nopermission tinyint(1) NOT NULL default '0',
|
location1 int(10) NOT NULL default '0', location2 int(10) NOT NULL default '0',
| location1 int(10) unsigned NOT NULL default '0', location2 int(10) unsigned NOT NULL default '0',
|
PRIMARY KEY(sid), KEY location (location1, location2), KEY time (time),
| PRIMARY KEY(sid), KEY location (location1, location2), KEY time (time),
|
Zeile 854 | Zeile 875 |
---|
prefix varchar(120) NOT NULL default '', displaystyle varchar(200) NOT NULL default '', forums text NOT NULL,
|
prefix varchar(120) NOT NULL default '', displaystyle varchar(200) NOT NULL default '', forums text NOT NULL,
|
groups text NOT NULL,
| `groups` text NOT NULL,
|
PRIMARY KEY (pid) ) ENGINE=MyISAM;";
| PRIMARY KEY (pid) ) ENGINE=MyISAM;";
|
Zeile 862 | Zeile 883 |
---|
rid int unsigned NOT NULL auto_increment, tid int unsigned NOT NULL default '0', uid int unsigned NOT NULL default '0',
|
rid int unsigned NOT NULL auto_increment, tid int unsigned NOT NULL default '0', uid int unsigned NOT NULL default '0',
|
rating smallint unsigned NOT NULL default '0',
| rating tinyint(1) unsigned NOT NULL default '0',
|
ipaddress varbinary(16) NOT NULL default '', KEY tid (tid, uid), PRIMARY KEY (rid)
| ipaddress varbinary(16) NOT NULL default '', KEY tid (tid, uid), PRIMARY KEY (rid)
|
Zeile 887 | Zeile 908 |
---|
lastpost int unsigned NOT NULL default '0', lastposter varchar(120) NOT NULL default '', lastposteruid int unsigned NOT NULL default '0',
|
lastpost int unsigned NOT NULL default '0', lastposter varchar(120) NOT NULL default '', lastposteruid int unsigned NOT NULL default '0',
|
views int(100) NOT NULL default '0', replies int(100) NOT NULL default '0',
| views int(100) unsigned NOT NULL default '0', replies int(100) unsigned NOT NULL default '0',
|
closed varchar(30) NOT NULL default '', sticky tinyint(1) NOT NULL default '0', numratings smallint unsigned NOT NULL default '0',
| closed varchar(30) NOT NULL default '', sticky tinyint(1) NOT NULL default '0', numratings smallint unsigned NOT NULL default '0',
|
Zeile 921 | Zeile 942 |
---|
tid int unsigned NOT NULL default '0', notification tinyint(1) NOT NULL default '0', dateline int unsigned NOT NULL default '0',
|
tid int unsigned NOT NULL default '0', notification tinyint(1) NOT NULL default '0', dateline int unsigned NOT NULL default '0',
|
subscriptionkey varchar(32) NOT NULL default '',
| |
KEY uid (uid), KEY tid (tid, notification), PRIMARY KEY (sid)
| KEY uid (uid), KEY tid (tid, notification), PRIMARY KEY (sid)
|
Zeile 937 | Zeile 957 |
---|
$tables[] = "CREATE TABLE mybb_usergroups ( gid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_usergroups ( gid smallint unsigned NOT NULL auto_increment,
|
type smallint(2) NOT NULL default '2',
| type tinyint(1) unsigned NOT NULL default '2',
|
title varchar(120) NOT NULL default '', description text NOT NULL, namestyle varchar(200) NOT NULL default '{username}', usertitle varchar(120) NOT NULL default '',
|
title varchar(120) NOT NULL default '', description text NOT NULL, namestyle varchar(200) NOT NULL default '{username}', usertitle varchar(120) NOT NULL default '',
|
stars smallint(4) NOT NULL default '0',
| stars smallint(4) unsigned NOT NULL default '0',
|
starimage varchar(120) NOT NULL default '', image varchar(120) NOT NULL default '', disporder smallint(6) unsigned NOT NULL,
| starimage varchar(120) NOT NULL default '', image varchar(120) NOT NULL default '', disporder smallint(6) unsigned NOT NULL,
|
Zeile 964 | Zeile 984 |
---|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
| canviewdeletionnotice tinyint(1) NOT NULL default '0',
|
canpostpolls tinyint(1) NOT NULL default '0', canvotepolls tinyint(1) NOT NULL default '0', canundovotes tinyint(1) NOT NULL default '0',
| canpostpolls tinyint(1) NOT NULL default '0', canvotepolls tinyint(1) NOT NULL default '0', canundovotes tinyint(1) NOT NULL default '0',
|
Zeile 971 | Zeile 992 |
---|
cansendpms tinyint(1) NOT NULL default '0', cantrackpms tinyint(1) NOT NULL default '0', candenypmreceipts tinyint(1) NOT NULL default '0',
|
cansendpms tinyint(1) NOT NULL default '0', cantrackpms tinyint(1) NOT NULL default '0', candenypmreceipts tinyint(1) NOT NULL default '0',
|
pmquota int(3) NOT NULL default '0', maxpmrecipients int(4) NOT NULL default '5',
| pmquota int(3) unsigned NOT NULL default '0', maxpmrecipients int(4) unsigned NOT NULL default '5',
|
cansendemail tinyint(1) NOT NULL default '0', cansendemailoverride tinyint(1) NOT NULL default '0',
|
cansendemail tinyint(1) NOT NULL default '0', cansendemailoverride tinyint(1) NOT NULL default '0',
|
maxemails int(3) NOT NULL default '5', emailfloodtime int(3) NOT NULL default '5',
| maxemails int(3) unsigned NOT NULL default '5', emailfloodtime int(3) unsigned NOT NULL default '5',
|
canviewmemberlist tinyint(1) NOT NULL default '0', canviewcalendar tinyint(1) NOT NULL default '0', canaddevents tinyint(1) NOT NULL default '0',
| canviewmemberlist tinyint(1) NOT NULL default '0', canviewcalendar tinyint(1) NOT NULL default '0', canaddevents tinyint(1) NOT NULL default '0',
|
Zeile 993 | Zeile 1014 |
---|
canratemembers tinyint(1) NOT NULL default '0', canchangename tinyint(1) NOT NULL default '0', canbereported tinyint(1) NOT NULL default '0',
|
canratemembers tinyint(1) NOT NULL default '0', canchangename tinyint(1) NOT NULL default '0', canbereported tinyint(1) NOT NULL default '0',
|
| canbeinvisible tinyint(1) NOT NULL default '1',
|
canchangewebsite tinyint(1) NOT NULL default '1', showforumteam tinyint(1) NOT NULL default '0', usereputationsystem tinyint(1) NOT NULL default '0', cangivereputations tinyint(1) NOT NULL default '0',
|
canchangewebsite tinyint(1) NOT NULL default '1', showforumteam tinyint(1) NOT NULL default '0', usereputationsystem tinyint(1) NOT NULL default '0', cangivereputations tinyint(1) NOT NULL default '0',
|
| candeletereputations tinyint(1) NOT NULL default '0',
|
reputationpower int unsigned NOT NULL default '0', maxreputationsday int unsigned NOT NULL default '0', maxreputationsperuser int unsigned NOT NULL default '0',
| reputationpower int unsigned NOT NULL default '0', maxreputationsday int unsigned NOT NULL default '0', maxreputationsperuser int unsigned NOT NULL default '0',
|
Zeile 1006 | Zeile 1029 |
---|
cancustomtitle tinyint(1) NOT NULL default '0', canwarnusers tinyint(1) NOT NULL default '0', canreceivewarnings tinyint(1) NOT NULL default '0',
|
cancustomtitle tinyint(1) NOT NULL default '0', canwarnusers tinyint(1) NOT NULL default '0', canreceivewarnings tinyint(1) NOT NULL default '0',
|
maxwarningsday int(3) NOT NULL default '3',
| maxwarningsday int(3) unsigned NOT NULL default '3',
|
canmodcp tinyint(1) NOT NULL default '0', showinbirthdaylist tinyint(1) NOT NULL default '0', canoverridepm tinyint(1) NOT NULL default '0', canusesig tinyint(1) NOT NULL default '0', canusesigxposts smallint unsigned NOT NULL default '0', signofollow tinyint(1) NOT NULL default '0',
|
canmodcp tinyint(1) NOT NULL default '0', showinbirthdaylist tinyint(1) NOT NULL default '0', canoverridepm tinyint(1) NOT NULL default '0', canusesig tinyint(1) NOT NULL default '0', canusesigxposts smallint unsigned NOT NULL default '0', signofollow tinyint(1) NOT NULL default '0',
|
edittimelimit int(4) NOT NULL default '0', maxposts int(4) NOT NULL default '0',
| edittimelimit int(4) unsigned NOT NULL default '0', maxposts int(4) unsigned NOT NULL default '0',
|
showmemberlist tinyint(1) NOT NULL default '1', canmanageannounce tinyint(1) NOT NULL default '0', canmanagemodqueue tinyint(1) NOT NULL default '0',
| showmemberlist tinyint(1) NOT NULL default '1', canmanageannounce tinyint(1) NOT NULL default '0', canmanagemodqueue tinyint(1) NOT NULL default '0',
|
Zeile 1034 | Zeile 1057 |
---|
salt varchar(10) NOT NULL default '', loginkey varchar(50) NOT NULL default '', email varchar(220) NOT NULL default '',
|
salt varchar(10) NOT NULL default '', loginkey varchar(50) NOT NULL default '', email varchar(220) NOT NULL default '',
|
postnum int(10) NOT NULL default '0', threadnum int(10) NOT NULL default '0',
| postnum int(10) unsigned NOT NULL default '0', threadnum int(10) unsigned NOT NULL default '0',
|
avatar varchar(200) NOT NULL default '', avatardimensions varchar(10) NOT NULL default '', avatartype varchar(10) NOT NULL default '0',
| avatar varchar(200) NOT NULL default '', avatardimensions varchar(10) NOT NULL default '', avatartype varchar(10) NOT NULL default '0',
|
Zeile 1049 | Zeile 1072 |
---|
lastpost int unsigned NOT NULL default '0', website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
lastpost int unsigned NOT NULL default '0', website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
aim varchar(50) NOT NULL default '', yahoo varchar(50) NOT NULL default '',
| |
skype varchar(75) NOT NULL default '', google varchar(75) NOT NULL default '', birthday varchar(15) NOT NULL default '',
| skype varchar(75) NOT NULL default '', google varchar(75) NOT NULL default '', birthday varchar(15) NOT NULL default '',
|
Zeile 1073 | Zeile 1094 |
---|
showavatars tinyint(1) NOT NULL default '0', showquickreply tinyint(1) NOT NULL default '0', showredirect tinyint(1) NOT NULL default '0',
|
showavatars tinyint(1) NOT NULL default '0', showquickreply tinyint(1) NOT NULL default '0', showredirect tinyint(1) NOT NULL default '0',
|
ppp smallint(6) NOT NULL default '0', tpp smallint(6) NOT NULL default '0', daysprune smallint(6) NOT NULL default '0',
| ppp smallint(6) unsigned NOT NULL default '0', tpp smallint(6) unsigned NOT NULL default '0', daysprune smallint(6) unsigned NOT NULL default '0',
|
dateformat varchar(4) NOT NULL default '', timeformat varchar(4) NOT NULL default '', timezone varchar(5) NOT NULL default '',
| dateformat varchar(4) NOT NULL default '', timeformat varchar(4) NOT NULL default '', timezone varchar(5) NOT NULL default '',
|
Zeile 1098 | Zeile 1119 |
---|
language varchar(50) NOT NULL default '', timeonline int unsigned NOT NULL default '0', showcodebuttons tinyint(1) NOT NULL default '1',
|
language varchar(50) NOT NULL default '', timeonline int unsigned NOT NULL default '0', showcodebuttons tinyint(1) NOT NULL default '1',
|
totalpms int(10) NOT NULL default '0', unreadpms int(10) NOT NULL default '0', warningpoints int(3) NOT NULL default '0',
| totalpms int(10) unsigned NOT NULL default '0', unreadpms int(10) unsigned NOT NULL default '0', warningpoints int(3) unsigned NOT NULL default '0',
|
moderateposts tinyint(1) NOT NULL default '0', moderationtime int unsigned NOT NULL default '0', suspendposting tinyint(1) NOT NULL default '0',
| moderateposts tinyint(1) NOT NULL default '0', moderationtime int unsigned NOT NULL default '0', suspendposting tinyint(1) NOT NULL default '0',
|
Zeile 1109 | Zeile 1130 |
---|
suspendsigtime int unsigned NOT NULL default '0', coppauser tinyint(1) NOT NULL default '0', classicpostbit tinyint(1) NOT NULL default '0',
|
suspendsigtime int unsigned NOT NULL default '0', coppauser tinyint(1) NOT NULL default '0', classicpostbit tinyint(1) NOT NULL default '0',
|
loginattempts tinyint(2) NOT NULL default '1',
| loginattempts smallint(2) unsigned NOT NULL default '0', loginlockoutexpiry int unsigned NOT NULL default '0',
|
usernotes text NOT NULL, sourceeditor tinyint(1) NOT NULL default '0', UNIQUE KEY username (username),
| usernotes text NOT NULL, sourceeditor tinyint(1) NOT NULL default '0', UNIQUE KEY username (username),
|
Zeile 1123 | Zeile 1145 |
---|
utid smallint unsigned NOT NULL auto_increment, posts int unsigned NOT NULL default '0', title varchar(250) NOT NULL default '',
|
utid smallint unsigned NOT NULL auto_increment, posts int unsigned NOT NULL default '0', title varchar(250) NOT NULL default '',
|
stars smallint(4) NOT NULL default '0',
| stars smallint(4) unsigned NOT NULL default '0',
|
starimage varchar(120) NOT NULL default '', PRIMARY KEY (utid) ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_warninglevels ( lid int unsigned NOT NULL auto_increment,
|
starimage varchar(120) NOT NULL default '', PRIMARY KEY (utid) ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_warninglevels ( lid int unsigned NOT NULL auto_increment,
|
percentage smallint(3) NOT NULL default '0',
| percentage smallint(3) unsigned NOT NULL default '0',
|
action text NOT NULL, PRIMARY KEY (lid) ) ENGINE=MyISAM;";
| action text NOT NULL, PRIMARY KEY (lid) ) ENGINE=MyISAM;";
|