| 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'
2fasecret varchar(16) NOT NULL default '',
recovery_codes varchar(177) NOT NULL default '',
| 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'
);";
| authenticated tinyint(1) NOT NULL default '0'
);";
|
| Zeile 64 | 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 81 | 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 92 | 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 115 | 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 126 | 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,
|
$tables[] = "CREATE TABLE mybb_calendars (
cid INTEGER PRIMARY KEY,
|
| Zeile 166 | 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
);";
|
| Zeile 220 | 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 325 | 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 337 | 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 352 | 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 362 | 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 382 | 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 393 | 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 446 | 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 463 | 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 (
|
pid INTEGER PRIMARY KEY,
| pid INTEGER PRIMARY KEY,
|
tid int NOT NULL default '0',
replyto int NOT NULL default '0',
fid smallint NOT NULL default '0',
| tid int NOT NULL default '0',
replyto int NOT NULL default '0',
fid smallint NOT NULL default '0',
|
| Zeile 475 | 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 496 | 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 562 | 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 570 | 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 589 | 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 603 | 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 623 | 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 667 | 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 678 | 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 698 | 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 747 | 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 766 | 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 783 | 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 813 | 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 826 | 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 853 | 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 887 | Zeile 903 |
|---|
usereputationsystem tinyint(1) NOT NULL default '0',
cangivereputations tinyint(1) NOT NULL default '0',
candeletereputations 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',
maxreputationsperthread int unsigned 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 901 | 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 932 | 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 985 | 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 1021 | 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 1031 | 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
|