| 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 (
| );";
$tables[] = "CREATE TABLE mybb_adminsessions (
|
| Zeile 34 | Zeile 36 |
|---|
uid int NOT NULL default '0',
loginkey varchar(50) NOT NULL default '',
ip blob(16) NOT NULL default '',
|
uid int NOT NULL default '0',
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 58 | Zeile 61 |
|---|
$tables[] = "CREATE TABLE mybb_announcements (
aid INTEGER PRIMARY KEY,
fid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_announcements (
aid INTEGER PRIMARY KEY,
fid int NOT NULL default '0',
|
uid int NOT NULL default '0',
| uid int NOT NULL default '0',
|
subject varchar(120) NOT NULL default '',
message TEXT NOT NULL,
|
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 73 | Zeile 76 |
|---|
pid int(10) NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int NOT NULL default '0',
|
pid int(10) NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int NOT NULL default '0',
|
filename varchar(120) NOT NULL default '',
| filename varchar(255) NOT NULL default '',
|
filetype varchar(120) NOT NULL default '',
filesize int(10) NOT NULL default '0',
|
filetype varchar(120) NOT NULL default '',
filesize int(10) NOT NULL default '0',
|
attachname varchar(120) NOT NULL default '',
| attachname varchar(255) NOT NULL default '',
|
downloads int NOT NULL default '0',
|
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',
| code varchar(100) NOT NULL default '',
type char(1) NOT NULL default '',
validated tinyint(1) NOT NULL default '0',
|
| Zeile 105 | Zeile 112 |
|---|
$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 (
| );";
$tables[] = "CREATE TABLE mybb_calendars (
|
| 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'
);";
| used tinyint(1) NOT NULL default '0'
);";
|
| Zeile 175 | Zeile 183 |
|---|
$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 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',
allowmycode 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',
allowvideocode tinyint(1) NOT NULL default '0',
| allowsmilies tinyint(1) NOT NULL default '0',
allowimgcode tinyint(1) NOT NULL default '0',
allowvideocode tinyint(1) NOT NULL default '0',
|
| Zeile 272 | Zeile 281 |
|---|
$tables[] = "CREATE TABLE mybb_forumsread (
fid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_forumsread (
fid int NOT NULL default '0',
|
uid int NOT NULL default '0',
| uid int NOT NULL default '0',
|
dateline int(10) NOT NULL default '0'
);";
| dateline int(10) NOT NULL default '0'
);";
|
| Zeile 280 | Zeile 289 |
|---|
fsid INTEGER PRIMARY KEY,
fid smallint NOT NULL default '0',
uid int NOT NULL default '0'
|
fsid INTEGER PRIMARY KEY,
fid smallint NOT NULL default '0',
uid int NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_groupleaders (
lid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_groupleaders (
lid INTEGER PRIMARY KEY,
|
| Zeile 289 | Zeile 298 |
|---|
canmanagemembers tinyint(1) NOT NULL default '0',
canmanagerequests tinyint(1) NOT NULL default '0',
caninvitemembers tinyint(1) NOT NULL default '0'
|
canmanagemembers tinyint(1) NOT NULL default '0',
canmanagerequests tinyint(1) NOT NULL default '0',
caninvitemembers tinyint(1) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_helpdocs (
hid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_helpdocs (
hid INTEGER PRIMARY KEY,
|
| Zeile 297 | Zeile 306 |
|---|
name varchar(120) NOT NULL default '',
description TEXT NOT NULL,
document TEXT NOT NULL,
|
name varchar(120) NOT NULL default '',
description TEXT NOT NULL,
document TEXT NOT NULL,
|
usetranslation tinyint(1) NOT NULL default '0',
enabled tinyint(1) NOT NULL default '0',
| usetranslation tinyint(1) NOT NULL default '0',
enabled tinyint(1) NOT NULL default '0',
|
disporder smallint NOT NULL default '0'
);";
| disporder smallint NOT NULL default '0'
);";
|
| Zeile 315 | Zeile 324 |
|---|
iid INTEGER PRIMARY KEY,
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default ''
|
iid INTEGER PRIMARY KEY,
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default ''
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_joinrequests (
rid INTEGER PRIMARY KEY,
uid int NOT NULL default '0',
gid smallint NOT NULL default '0',
reason varchar(250) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_joinrequests (
rid INTEGER PRIMARY KEY,
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 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 879 | Zeile 898 |
|---|
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',
|
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 918 |
|---|
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 949 |
|---|
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 '',
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 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
|