Zeile 9 | Zeile 9 |
---|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
|
uid int unsigned NOT NULL default '0',
| uid int NOT NULL default '0',
|
ipaddress blob(16) NOT NULL default '',
|
ipaddress blob(16) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data TEXT NOT NULL );";
$tables[] = "CREATE TABLE mybb_adminoptions (
|
module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data TEXT NOT NULL );";
$tables[] = "CREATE TABLE mybb_adminoptions (
|
uid int unsigned NOT NULL default '0',
| uid int NOT NULL default '0',
|
cpstyle varchar(50) NOT NULL default '', cplanguage varchar(50) NOT NULL default '', codepress tinyint(1) NOT NULL default '1', notes TEXT NOT NULL, permissions TEXT NOT NULL, defaultviews TEXT NOT NULL,
|
cpstyle varchar(50) NOT NULL default '', cplanguage varchar(50) NOT NULL default '', codepress tinyint(1) NOT NULL default '1', notes TEXT NOT NULL, permissions TEXT NOT NULL, defaultviews TEXT NOT NULL,
|
loginattempts smallint unsigned NOT NULL default '0', loginlockoutexpiry int unsigned NOT NULL default '0'
| loginattempts smallint NOT NULL default '0', loginlockoutexpiry int NOT NULL default '0', authsecret varchar(16) NOT NULL default '', recovery_codes varchar(177) NOT NULL default ''
|
);";
$tables[] = "CREATE TABLE mybb_adminsessions ( sid varchar(32) NOT NULL default '',
|
);";
$tables[] = "CREATE TABLE mybb_adminsessions ( sid varchar(32) NOT NULL default '',
|
uid int NOT NULL default '0',
| uid int NOT NULL default '0',
|
loginkey varchar(50) NOT NULL default '', ip blob(16) NOT NULL default '',
|
loginkey varchar(50) NOT NULL default '', ip blob(16) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0', lastactive int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0', lastactive int NOT NULL default '0',
|
data TEXT NOT NULL,
|
data TEXT NOT NULL,
|
useragent varchar(100) NOT NULL default ''
| useragent varchar(200) NOT NULL default '', authenticated tinyint(1) NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_adminviews (
| );";
$tables[] = "CREATE TABLE mybb_adminviews (
|
Zeile 61 | Zeile 64 |
---|
uid int NOT NULL default '0', subject varchar(120) NOT NULL default '', message TEXT NOT NULL,
|
uid int NOT NULL default '0', subject varchar(120) NOT NULL default '', message TEXT NOT NULL,
|
startdate int unsigned NOT NULL default '0', enddate int unsigned NOT NULL default '0',
| startdate int NOT NULL default '0', enddate int NOT NULL default '0',
|
allowhtml tinyint(1) NOT NULL default '0', allowmycode tinyint(1) NOT NULL default '0', allowsmilies tinyint(1) NOT NULL default '0'
| allowhtml tinyint(1) NOT NULL default '0', allowmycode tinyint(1) NOT NULL default '0', allowsmilies tinyint(1) NOT NULL default '0'
|
Zeile 78 | Zeile 81 |
---|
filesize int(10) NOT NULL default '0', attachname varchar(120) NOT NULL default '', downloads int NOT NULL default '0',
|
filesize int(10) NOT NULL default '0', attachname varchar(120) NOT NULL default '', downloads int NOT NULL default '0',
|
dateuploaded int unsigned NOT NULL default '0',
| dateuploaded int NOT NULL default '0',
|
visible tinyint(1) NOT NULL default '0', thumbnail varchar(120) NOT NULL default '' );";
| visible tinyint(1) NOT NULL default '0', thumbnail varchar(120) NOT NULL default '' );";
|
Zeile 89 | Zeile 92 |
---|
mimetype varchar(120) NOT NULL default '', extension varchar(10) NOT NULL default '', maxsize int(15) NOT NULL default '0',
|
mimetype varchar(120) NOT NULL default '', extension varchar(10) NOT NULL default '', maxsize int(15) NOT NULL default '0',
|
icon varchar(100) NOT NULL default '' );";
| icon varchar(100) NOT NULL default '', enabled tinyint(1) NOT NULL default '1', groups TEXT NOT NULL, forums TEXT NOT NULL, avatarfile tinyint(1) NOT NULL default '0' );";
|
$tables[] = "CREATE TABLE mybb_awaitingactivation ( aid INTEGER PRIMARY KEY, uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_awaitingactivation ( aid INTEGER PRIMARY KEY, uid int NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
code varchar(100) NOT NULL default '', type char(1) NOT NULL default '', validated tinyint(1) NOT NULL default '0', misc varchar(255) NOT NULL default ''
|
code varchar(100) NOT NULL default '', type char(1) NOT NULL default '', validated tinyint(1) NOT NULL default '0', misc varchar(255) NOT NULL default ''
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_badwords ( bid INTEGER PRIMARY KEY, badword varchar(100) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_badwords ( bid INTEGER PRIMARY KEY, badword varchar(100) NOT NULL default '',
|
| regex tinyint(1) NOT NULL default '0',
|
replacement varchar(100) NOT NULL default '' );";
| replacement varchar(100) NOT NULL default '' );";
|
Zeile 112 | Zeile 120 |
---|
fid INTEGER PRIMARY KEY, filter varchar(200) NOT NULL default '', type tinyint(1) NOT NULL default '0',
|
fid INTEGER PRIMARY KEY, filter varchar(200) NOT NULL default '', type tinyint(1) NOT NULL default '0',
|
lastuse int unsigned NOT NULL default '0', dateline int unsigned NOT NULL default '0'
| lastuse int NOT NULL default '0', dateline int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_banned (
| );";
$tables[] = "CREATE TABLE mybb_banned (
|
Zeile 123 | Zeile 131 |
---|
oldadditionalgroups TEXT NOT NULL, olddisplaygroup int NOT NULL default '0', admin int NOT NULL default '0',
|
oldadditionalgroups TEXT NOT NULL, olddisplaygroup int NOT NULL default '0', admin int NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
bantime varchar(50) NOT NULL default '',
|
bantime varchar(50) NOT NULL default '',
|
lifted int unsigned NOT NULL default '0',
| lifted int NOT NULL default '0',
|
reason varchar(255) NOT NULL default '' );";
$tables[] = "CREATE TABLE mybb_buddyrequests (
|
reason varchar(255) NOT NULL default '' );";
$tables[] = "CREATE TABLE mybb_buddyrequests (
|
id INTEGER PRIMARY KEY, uid bigint UNSIGNED NOT NULL, touid bigint UNSIGNED NOT NULL, date int UNSIGNED NOT NULL );";
| id INTEGER PRIMARY KEY, uid int NOT NULL default '0', touid int NOT NULL default '0', date int NOT NULL default '0' );";
|
$tables[] = "CREATE TABLE mybb_calendars ( cid INTEGER PRIMARY KEY, name varchar(100) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_calendars ( cid INTEGER PRIMARY KEY, name varchar(100) NOT NULL default '',
|
Zeile 163 | Zeile 171 |
---|
$tables[] = "CREATE TABLE mybb_captcha ( imagehash varchar(32) NOT NULL default '', imagestring varchar(8) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_captcha ( imagehash varchar(32) NOT NULL default '', imagestring varchar(8) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
used tinyint(1) NOT NULL default '0' );";
$tables[] = "CREATE TABLE mybb_datacache ( title varchar(50) NOT NULL default '' PRIMARY KEY, cache mediumTEXT NOT NULL
|
used tinyint(1) NOT NULL default '0' );";
$tables[] = "CREATE TABLE mybb_datacache ( title varchar(50) NOT NULL default '' PRIMARY KEY, cache mediumTEXT NOT NULL
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_delayedmoderation ( did integer PRIMARY KEY, type varchar(30) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_delayedmoderation ( did integer PRIMARY KEY, type varchar(30) NOT NULL default '',
|
delaydateline int unsigned NOT NULL default '0',
| delaydateline int NOT NULL default '0',
|
uid int(10) NOT NULL default '0', fid smallint(5) NOT NULL default '0', tids text NOT NULL,
|
uid int(10) NOT NULL default '0', fid smallint(5) NOT NULL default '0', tids text NOT NULL,
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
inputs text NOT NULL
|
inputs text NOT NULL
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_events ( eid INTEGER PRIMARY KEY, cid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_events ( eid INTEGER PRIMARY KEY, cid int NOT NULL default '0',
|
Zeile 217 | Zeile 225 |
---|
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 244 | Zeile 253 |
---|
lastposteruid int(10) NOT NULL default '0', lastposttid int(10) NOT NULL default '0', lastpostsubject varchar(120) NOT NULL default '',
|
lastposteruid int(10) NOT NULL default '0', lastposttid int(10) NOT NULL default '0', lastpostsubject varchar(120) NOT NULL default '',
|
allowhtml tinyint(1) NOT NULL default '0',
| allowhtml tinyint(1) NOT NULL default '0',
|
allowmycode tinyint(1) NOT NULL default '0', allowsmilies tinyint(1) NOT NULL default '0', allowimgcode tinyint(1) NOT NULL default '0',
| allowmycode tinyint(1) NOT NULL default '0', allowsmilies tinyint(1) NOT NULL default '0', allowimgcode tinyint(1) NOT NULL default '0',
|
Zeile 322 | Zeile 331 |
---|
uid int NOT NULL default '0', gid smallint NOT NULL default '0', reason varchar(250) NOT NULL default '',
|
uid int NOT NULL default '0', gid smallint NOT NULL default '0', reason varchar(250) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
invite tinyint(1) NOT NULL default '0' );";
| invite tinyint(1) NOT NULL default '0' );";
|
Zeile 334 | Zeile 343 |
---|
htmlmessage text NOT NULL, type tinyint(1) NOT NULL default '0', format tinyint(1) NOT NULL default '0',
|
htmlmessage text NOT NULL, type tinyint(1) NOT NULL default '0', format tinyint(1) NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0', senddate int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0', senddate int NOT NULL default '0',
|
status tinyint(1) NOT NULL default '0', sentcount int NOT NULL default '0', totalcount int NOT NULL default '0',
| status tinyint(1) NOT NULL default '0', sentcount int NOT NULL default '0', totalcount int NOT NULL default '0',
|
Zeile 349 | Zeile 358 |
---|
message TEXT NOT NULL, toaddress varchar(150) NOT NULL default '', fromaddress varchar(150) NOT NULL default '',
|
message TEXT NOT NULL, toaddress varchar(150) NOT NULL default '', fromaddress varchar(150) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
error TEXT NOT NULL, smtperror varchar(200) NOT NULL default '', smtpcode smallint(5) NOT NULL default '0'
| error TEXT NOT NULL, smtperror varchar(200) NOT NULL default '', smtpcode smallint(5) NOT NULL default '0'
|
Zeile 359 | Zeile 368 |
---|
mid INTEGER PRIMARY KEY, subject varchar(200) not null default '', message TEXT NOT NULL,
|
mid INTEGER PRIMARY KEY, subject varchar(200) not null default '', message TEXT NOT NULL,
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
fromuid int NOT NULL default '0', fromemail varchar(200) not null default '',
|
fromuid int NOT NULL default '0', fromemail varchar(200) not null default '',
|
touid int unsigned NOT NULL default '0',
| touid int NOT NULL default '0',
|
toemail varchar(200) NOT NULL default '', tid int NOT NULL default '0', ipaddress blob(16) NOT NULL default '',
| toemail varchar(200) NOT NULL default '', tid int NOT NULL default '0', ipaddress blob(16) NOT NULL default '',
|
Zeile 379 | Zeile 388 |
---|
$tables[] = "CREATE TABLE mybb_moderatorlog ( uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_moderatorlog ( uid int NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
fid smallint NOT NULL default '0', tid int NOT NULL default '0', pid int NOT NULL default '0',
| fid smallint NOT NULL default '0', tid int NOT NULL default '0', pid int NOT NULL default '0',
|
Zeile 390 | Zeile 399 |
---|
$tables[] = "CREATE TABLE mybb_moderators ( mid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_moderators ( mid INTEGER PRIMARY KEY,
|
fid smallint NOT NULL default '0', id int NOT NULL default '0',
| fid smallint NOT NULL default '0', id int NOT NULL default '0',
|
isgroup tinyint(1) NOT NULL default '0', caneditposts tinyint(1) NOT NULL default '0', cansoftdeleteposts tinyint(1) NOT NULL default '0',
| isgroup tinyint(1) NOT NULL default '0', caneditposts tinyint(1) NOT NULL default '0', cansoftdeleteposts tinyint(1) NOT NULL default '0',
|
Zeile 416 | Zeile 425 |
---|
canmanageannouncements tinyint(1) NOT NULL default '0', canmanagereportedposts tinyint(1) NOT NULL default '0', canviewmodlog tinyint(1) NOT NULL default '0'
|
canmanageannouncements tinyint(1) NOT NULL default '0', canmanagereportedposts tinyint(1) NOT NULL default '0', canviewmodlog tinyint(1) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_modtools ( tid INTEGER PRIMARY KEY,
| $tables[] = "CREATE TABLE mybb_modtools ( tid INTEGER PRIMARY KEY,
|
Zeile 443 | Zeile 452 |
---|
pid INTEGER PRIMARY KEY, tid int NOT NULL default '0', question varchar(200) NOT NULL default '',
|
pid INTEGER PRIMARY KEY, tid int NOT NULL default '0', question varchar(200) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
options TEXT NOT NULL, votes TEXT NOT NULL, numoptions smallint NOT NULL default '0', numvotes int NOT NULL default '0',
|
options TEXT NOT NULL, votes TEXT NOT NULL, numoptions smallint NOT NULL default '0', numvotes int NOT NULL default '0',
|
timeout int unsigned NOT NULL default '0',
| timeout int NOT NULL default '0',
|
closed tinyint(1) NOT NULL default '0', multiple tinyint(1) NOT NULL default '0', public tinyint(1) NOT NULL default '0',
| closed tinyint(1) NOT NULL default '0', multiple tinyint(1) NOT NULL default '0', public tinyint(1) NOT NULL default '0',
|
Zeile 460 | Zeile 469 |
---|
pid int NOT NULL default '0', uid int NOT NULL default '0', voteoption smallint NOT NULL default '0',
|
pid int NOT NULL default '0', uid int NOT NULL default '0', voteoption smallint NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0'
| dateline int NOT NULL default '0', ipaddress blob(16) NOT NULL default ''
|
);";
$tables[] = "CREATE TABLE mybb_posts (
| );";
$tables[] = "CREATE TABLE mybb_posts (
|
Zeile 472 | Zeile 482 |
---|
icon smallint NOT NULL default '0', uid int NOT NULL default '0', username varchar(80) NOT NULL default '',
|
icon smallint NOT NULL default '0', uid int NOT NULL default '0', username varchar(80) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
message TEXT NOT NULL, ipaddress blob(16) NOT NULL default '', includesig tinyint(1) NOT NULL default '0',
| message TEXT NOT NULL, ipaddress blob(16) NOT NULL default '', includesig tinyint(1) NOT NULL default '0',
|
Zeile 493 | Zeile 503 |
---|
subject varchar(120) NOT NULL default '', icon smallint NOT NULL default '0', message TEXT NOT NULL,
|
subject varchar(120) NOT NULL default '', icon smallint NOT NULL default '0', message TEXT NOT NULL,
|
dateline int unsigned NOT NULL default '0', deletetime int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0', deletetime int NOT NULL default '0',
|
status tinyint(1) NOT NULL default '0',
|
status tinyint(1) NOT NULL default '0',
|
statustime int unsigned NOT NULL default '0',
| statustime int NOT NULL default '0',
|
includesig tinyint(1) NOT NULL default '0', smilieoff tinyint(1) NOT NULL default '0', receipt tinyint(1) NOT NULL default '0',
|
includesig tinyint(1) NOT NULL default '0', smilieoff tinyint(1) NOT NULL default '0', receipt tinyint(1) NOT NULL default '0',
|
readtime int unsigned NOT NULL default '0',
| readtime int NOT NULL default '0',
|
ipaddress blob(16) NOT NULL default '' );";
| ipaddress blob(16) NOT NULL default '' );";
|
Zeile 559 | Zeile 569 |
---|
uid int NOT NULL default '0', oldusergroup varchar(200) NOT NULL default '0', newusergroup smallint NOT NULL default '0',
|
uid int NOT NULL default '0', oldusergroup varchar(200) NOT NULL default '0', newusergroup smallint NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
type varchar(9) NOT NULL default 'primary' );";
| type varchar(9) NOT NULL default 'primary' );";
|
Zeile 567 | Zeile 577 |
---|
qid INTEGER PRIMARY KEY, question varchar(200) NOT NULL default '', answer varchar(150) NOT NULL default '',
|
qid INTEGER PRIMARY KEY, question varchar(200) NOT NULL default '', answer varchar(150) NOT NULL default '',
|
shown int unsigned NOT NULL default 0, correct int unsigned NOT NULL default 0, incorrect int unsigned NOT NULL default 0,
| shown int NOT NULL default 0, correct int NOT NULL default 0, incorrect int NOT NULL default 0,
|
active tinyint(1) NOT NULL default '0' );";
$tables[] = "CREATE TABLE mybb_questionsessions ( sid varchar(32) NOT NULL default '',
|
active tinyint(1) NOT NULL default '0' );";
$tables[] = "CREATE TABLE mybb_questionsessions ( sid varchar(32) NOT NULL default '',
|
qid int unsigned NOT NULL default '0', dateline int unsigned NOT NULL default '0'
| qid int NOT NULL default '0', dateline int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_reportedcontent (
| );";
$tables[] = "CREATE TABLE mybb_reportedcontent (
|
Zeile 586 | Zeile 596 |
---|
id3 int NOT NULL default '0', uid int NOT NULL default '0', reportstatus tinyint(1) NOT NULL default '0',
|
id3 int NOT NULL default '0', uid int NOT NULL default '0', reportstatus tinyint(1) NOT NULL default '0',
|
| reasonid smallint NOT NULL default '0',
|
reason varchar(250) NOT NULL default '', type varchar(50) NOT NULL default '', reports int NOT NULL default '0', reporters text NOT NULL,
|
reason varchar(250) NOT NULL default '', type varchar(50) NOT NULL default '', reports int NOT NULL default '0', reporters text NOT NULL,
|
dateline int unsigned NOT NULL default '0', lastreport int unsigned NOT NULL default '0'
| dateline int NOT NULL default '0', lastreport int NOT NULL default '0' );";
$tables[] = "CREATE TABLE mybb_reportreasons ( rid INTEGER PRIMARY KEY, title varchar(250) NOT NULL default '', appliesto varchar(250) NOT NULL default '', extra tinyint(1) NOT NULL default '0', disporder smallint NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_reputation (
| );";
$tables[] = "CREATE TABLE mybb_reputation (
|
Zeile 600 | Zeile 619 |
---|
adduid int NOT NULL default '0', pid int NOT NULL default '0', reputation smallint NOT NULL default '0',
|
adduid int NOT NULL default '0', pid int NOT NULL default '0', reputation smallint NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
comments TEXT NOT NULL );";
$tables[] = "CREATE TABLE mybb_searchlog ( sid varchar(32) NOT NULL default '', uid int NOT NULL default '0',
|
comments TEXT NOT NULL );";
$tables[] = "CREATE TABLE mybb_searchlog ( sid varchar(32) NOT NULL default '', uid int NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
ipaddress blob(16) NOT NULL default '', threads LONGTEXT NOT NULL, posts LONGTEXT NOT NULL,
| ipaddress blob(16) NOT NULL default '', threads LONGTEXT NOT NULL, posts LONGTEXT NOT NULL,
|
Zeile 620 | Zeile 639 |
---|
sid varchar(32) NOT NULL default '', uid int NOT NULL default '0', ip blob(16) NOT NULL default '',
|
sid varchar(32) NOT NULL default '', uid int NOT NULL default '0', ip blob(16) NOT NULL default '',
|
time int unsigned NOT NULL default '0',
| time int NOT NULL default '0',
|
location varchar(150) NOT NULL default '',
|
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', location1 int(10) 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',
|
Zeile 664 | Zeile 683 |
---|
username varchar(120) NOT NULL DEFAULT '', email varchar(220) NOT NULL DEFAULT '', ipaddress blob(16) NOT NULL default '',
|
username varchar(120) NOT NULL DEFAULT '', email varchar(220) NOT NULL DEFAULT '', ipaddress blob(16) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
data TEXT NOT NULL default '' );";
| data TEXT NOT NULL default '' );";
|
Zeile 675 | Zeile 694 |
---|
language varchar(20) NOT NULL default '', usergroup smallint NOT NULL default '0', useragent varchar(200) NOT NULL default '',
|
language varchar(20) NOT NULL default '', usergroup smallint NOT NULL default '0', useragent varchar(200) NOT NULL default '',
|
lastvisit int unsigned NOT NULL default '0'
| lastvisit int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_stats (
|
);";
$tables[] = "CREATE TABLE mybb_stats (
|
dateline int unsigned NOT NULL default '0' PRIMARY KEY, numusers int unsigned NOT NULL default '0', numthreads int unsigned NOT NULL default '0', numposts int unsigned NOT NULL default '0'
| dateline int NOT NULL default '0' PRIMARY KEY, numusers int NOT NULL default '0', numthreads int NOT NULL default '0', numposts int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_tasks (
| );";
$tables[] = "CREATE TABLE mybb_tasks (
|
Zeile 695 | Zeile 714 |
---|
day varchar(100) NOT NULL default '', month varchar(30) NOT NULL default '', weekday varchar(15) NOT NULL default '',
|
day varchar(100) NOT NULL default '', month varchar(30) NOT NULL default '', weekday varchar(15) NOT NULL default '',
|
nextrun int unsigned NOT NULL default '0', lastrun int unsigned NOT NULL default '0',
| nextrun int NOT NULL default '0', lastrun int NOT NULL default '0',
|
enabled tinyint(1) NOT NULL default '1', logging tinyint(1) NOT NULL default '0',
|
enabled tinyint(1) NOT NULL default '1', logging tinyint(1) NOT NULL default '0',
|
locked int unsigned NOT NULL default '0'
| locked int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_tasklog ( lid INTEGER PRIMARY KEY, tid int NOT NULL default '0',
|
);";
$tables[] = "CREATE TABLE mybb_tasklog ( lid INTEGER PRIMARY KEY, tid int NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
data TEXT NOT NULL );";
| data TEXT NOT NULL );";
|
Zeile 744 | Zeile 763 |
---|
$tables[] = "CREATE TABLE mybb_themestylesheets( sid INTEGER PRIMARY KEY, name varchar(30) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_themestylesheets( sid INTEGER PRIMARY KEY, name varchar(30) NOT NULL default '',
|
tid smallint unsigned NOT NULL default '0',
| tid smallint NOT NULL default '0',
|
attachedto TEXT NOT NULL, stylesheet LONGTEXT NOT NULL, cachefile varchar(100) NOT NULL default '',
|
attachedto TEXT NOT NULL, stylesheet LONGTEXT NOT NULL, cachefile varchar(100) NOT NULL default '',
|
lastmodified int unsigned NOT NULL default '0'
| lastmodified int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_threadprefixes (
| );";
$tables[] = "CREATE TABLE mybb_threadprefixes (
|
Zeile 763 | Zeile 782 |
---|
rid INTEGER PRIMARY KEY, tid int NOT NULL default '0', uid int NOT NULL default '0',
|
rid INTEGER PRIMARY KEY, tid int NOT NULL default '0', uid int NOT NULL default '0',
|
rating smallint NOT NULL default '0',
| rating tinyint(1) NOT NULL default '0',
|
ipaddress blob(16) NOT NULL default '' );";
| ipaddress blob(16) NOT NULL default '' );";
|
Zeile 780 | Zeile 799 |
---|
poll int NOT NULL default '0', uid int NOT NULL default '0', username varchar(80) NOT NULL default '',
|
poll int NOT NULL default '0', uid int NOT NULL default '0', username varchar(80) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
firstpost int NOT NULL default '0',
|
firstpost int NOT NULL default '0',
|
lastpost int unsigned NOT NULL default '0',
| lastpost int NOT NULL default '0',
|
lastposter varchar(120) NOT NULL default '', lastposteruid int NOT NULL default '0', views int(100) NOT NULL default '0',
| lastposter varchar(120) NOT NULL default '', lastposteruid int NOT NULL default '0', views int(100) NOT NULL default '0',
|
Zeile 810 | Zeile 829 |
---|
uid int NOT NULL default '0', tid int NOT NULL default '0', notification tinyint(1) NOT NULL default '0',
|
uid int NOT NULL default '0', tid int NOT NULL default '0', notification tinyint(1) NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0', subscriptionkey varchar(32) NOT NULL default ''
| dateline int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_userfields (
| );";
$tables[] = "CREATE TABLE mybb_userfields (
|
Zeile 823 | Zeile 841 |
---|
$tables[] = "CREATE TABLE mybb_usergroups ( gid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_usergroups ( gid INTEGER PRIMARY KEY,
|
type smallint(2) NOT NULL default '2',
| type tinyint(1) NOT NULL default '2',
|
title varchar(120) NOT NULL default '', description TEXT NOT NULL, namestyle varchar(200) NOT NULL default '{username}',
| title varchar(120) NOT NULL default '', description TEXT NOT NULL, namestyle varchar(200) NOT NULL default '{username}',
|
Zeile 850 | Zeile 868 |
---|
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 883 | Zeile 902 |
---|
showforumteam tinyint(1) NOT NULL default '0', usereputationsystem tinyint(1) NOT NULL default '0', cangivereputations tinyint(1) NOT NULL default '0',
|
showforumteam tinyint(1) NOT NULL default '0', usereputationsystem tinyint(1) NOT NULL default '0', cangivereputations 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', maxreputationsperthread int unsigned NOT NULL default '0',
| candeletereputations tinyint(1) NOT NULL default '0', reputationpower int NOT NULL default '0', maxreputationsday int NOT NULL default '0', maxreputationsperuser int NOT NULL default '0', maxreputationsperthread int NOT NULL default '0',
|
candisplaygroup tinyint(1) NOT NULL default '0',
|
candisplaygroup tinyint(1) NOT NULL default '0',
|
attachquota int unsigned NOT NULL default '0',
| attachquota int 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',
| cancustomtitle tinyint(1) NOT NULL default '0', canwarnusers tinyint(1) NOT NULL default '0', canreceivewarnings tinyint(1) NOT NULL default '0',
|
Zeile 897 | Zeile 917 |
---|
showinbirthdaylist tinyint(1) NOT NULL default '0', canoverridepm tinyint(1) NOT NULL default '0', canusesig 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 int unsigned NOT NULL default '0',
| canusesigxposts int 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',
| signofollow tinyint(1) NOT NULL default '0', edittimelimit int(4) NOT NULL default '0', maxposts int(4) NOT NULL default '0',
|
Zeile 928 | Zeile 948 |
---|
additionalgroups varchar(200) NOT NULL default '', displaygroup smallint NOT NULL default '0', usertitle varchar(250) NOT NULL default '',
|
additionalgroups varchar(200) NOT NULL default '', displaygroup smallint NOT NULL default '0', usertitle varchar(250) NOT NULL default '',
|
regdate int unsigned NOT NULL default '0', lastactive int unsigned NOT NULL default '0', lastvisit int unsigned NOT NULL default '0', lastpost int unsigned NOT NULL default '0',
| regdate int NOT NULL default '0', lastactive int NOT NULL default '0', lastvisit int NOT NULL default '0', lastpost int NOT NULL default '0',
|
website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
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 '',
| yahoo varchar(50) NOT NULL default '', skype varchar(75) NOT NULL default '', google varchar(75) NOT NULL default '',
|
Zeile 981 | Zeile 1000 |
---|
regip blob(16) NOT NULL default '', lastip blob(16) NOT NULL default '', language varchar(50) NOT NULL default '',
|
regip blob(16) NOT NULL default '', lastip blob(16) NOT NULL default '', language varchar(50) NOT NULL default '',
|
timeonline int unsigned NOT NULL default '0',
| timeonline int 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', moderateposts tinyint(1) 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', moderateposts tinyint(1) NOT NULL default '0',
|
moderationtime int unsigned NOT NULL default '0',
| moderationtime int NOT NULL default '0',
|
suspendposting tinyint(1) NOT NULL default '0',
|
suspendposting tinyint(1) NOT NULL default '0',
|
suspensiontime int unsigned NOT NULL default '0',
| suspensiontime int NOT NULL default '0',
|
suspendsignature tinyint(1) NOT NULL default '0',
|
suspendsignature tinyint(1) NOT NULL default '0',
|
suspendsigtime int unsigned NOT NULL default '0',
| suspendsigtime int NOT NULL default '0',
|
coppauser tinyint(1) NOT NULL default '0', classicpostbit tinyint(1) 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) NOT NULL default '0', loginlockoutexpiry int NOT NULL default '0',
|
usernotes TEXT NOT NULL, sourceeditor tinyint(1) NOT NULL default '0' );";
| usernotes TEXT NOT NULL, sourceeditor tinyint(1) NOT NULL default '0' );";
|
Zeile 1017 | Zeile 1037 |
---|
tid INTEGER PRIMARY KEY, title varchar(120) NOT NULL default '', points smallint NOT NULL default '0',
|
tid INTEGER PRIMARY KEY, title varchar(120) NOT NULL default '', points smallint NOT NULL default '0',
|
expirationtime int unsigned NOT NULL default '0'
| expirationtime int NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_warnings (
| );";
$tables[] = "CREATE TABLE mybb_warnings (
|
Zeile 1027 | Zeile 1047 |
---|
pid int NOT NULL default '0', title varchar(120) NOT NULL default '', points smallint NOT NULL default '0',
|
pid int NOT NULL default '0', title varchar(120) NOT NULL default '', points smallint NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int NOT NULL default '0',
|
issuedby int NOT NULL default '0',
|
issuedby int NOT NULL default '0',
|
expires int unsigned NOT NULL default '0',
| expires int NOT NULL default '0',
|
expired tinyint(1) NOT NULL default '0',
|
expired tinyint(1) NOT NULL default '0',
|
daterevoked int unsigned NOT NULL default '0',
| daterevoked int NOT NULL default '0',
|
revokedby int NOT NULL default '0', revokereason TEXT NOT NULL, notes TEXT NOT NULL
| revokedby int NOT NULL default '0', revokereason TEXT NOT NULL, notes TEXT NOT NULL
|