| Zeile 103 | Zeile 103 |
|---|
extension varchar(10) NOT NULL default '',
maxsize int NOT NULL default '0',
icon varchar(100) NOT NULL default '',
|
extension varchar(10) NOT NULL default '',
maxsize int NOT NULL default '0',
icon varchar(100) NOT NULL default '',
|
| | enabled smallint NOT NULL default '1',
groups text NOT NULL default '-1',
forums text NOT NULL default '-1',
avatarfile smallint NOT NULL default '0',
|
PRIMARY KEY (atid)
);";
$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid serial,
|
PRIMARY KEY (atid)
);";
$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid serial,
|
uid int NOT NULL default '0',
dateline int NOT NULL default '0',
| uid int NOT NULL default '0',
dateline int NOT NULL default '0',
|
code varchar(100) NOT NULL default '',
type char(1) NOT NULL default '',
validated smallint NOT NULL default '0',
misc varchar(255) NOT NULL default '',
PRIMARY KEY (aid)
|
code varchar(100) NOT NULL default '',
type char(1) NOT NULL default '',
validated smallint NOT NULL default '0',
misc varchar(255) NOT NULL default '',
PRIMARY KEY (aid)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_badwords (
bid serial,
badword varchar(100) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_badwords (
bid serial,
badword varchar(100) NOT NULL default '',
|
| Zeile 131 | Zeile 135 |
|---|
lastuse int NOT NULL default '0',
dateline int NOT NULL default '0',
PRIMARY KEY (fid)
|
lastuse int NOT NULL default '0',
dateline int NOT NULL default '0',
PRIMARY KEY (fid)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_banned (
uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_banned (
uid int NOT NULL default '0',
|
| Zeile 162 | Zeile 166 |
|---|
showbirthdays smallint NOT NULL default '0',
eventlimit smallint NOT NULL default '0',
moderation smallint NOT NULL default '0',
|
showbirthdays smallint NOT NULL default '0',
eventlimit smallint NOT NULL default '0',
moderation smallint NOT NULL default '0',
|
allowhtml smallint NOT NULL default '0',
allowmycode smallint NOT NULL default '0',
allowimgcode smallint NOT NULL default '0',
allowvideocode smallint NOT NULL default '0',
allowsmilies smallint NOT NULL default '0',
PRIMARY KEY(cid)
);";
| allowhtml smallint NOT NULL default '0',
allowmycode smallint NOT NULL default '0',
allowimgcode smallint NOT NULL default '0',
allowvideocode smallint NOT NULL default '0',
allowsmilies smallint NOT NULL default '0',
PRIMARY KEY(cid)
);";
|
$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid serial,
gid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_calendarpermissions (
cid serial,
gid int NOT NULL default '0',
|
| Zeile 177 | Zeile 181 |
|---|
canaddevents smallint NOT NULL default '0',
canbypasseventmod smallint NOT NULL default '0',
canmoderateevents smallint NOT NULL default '0'
|
canaddevents smallint NOT NULL default '0',
canbypasseventmod smallint NOT NULL default '0',
canmoderateevents smallint NOT NULL default '0'
|
);";
| );";
|
$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 '',
|
| Zeile 202 | Zeile 206 |
|---|
dateline int NOT NULL default '0',
inputs text NOT NULL default '',
PRIMARY KEY (did)
|
dateline int NOT NULL default '0',
inputs text NOT NULL default '',
PRIMARY KEY (did)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_events (
eid serial,
cid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_events (
eid serial,
cid int NOT NULL default '0',
|
| Zeile 235 | Zeile 239 |
|---|
canonlyreplyownthreads smallint NOT NULL default '0',
canpostattachments smallint NOT NULL default '0',
canratethreads smallint NOT NULL default '0',
|
canonlyreplyownthreads smallint NOT NULL default '0',
canpostattachments smallint NOT NULL default '0',
canratethreads smallint NOT NULL default '0',
|
caneditposts smallint NOT NULL default '0',
candeleteposts smallint NOT NULL default '0',
| caneditposts smallint NOT NULL default '0',
candeleteposts smallint NOT NULL default '0',
|
candeletethreads smallint NOT NULL default '0',
caneditattachments smallint NOT NULL default '0',
|
candeletethreads smallint NOT NULL default '0',
caneditattachments smallint NOT NULL default '0',
|
| | canviewdeletionnotice smallint NOT NULL default '0',
|
modposts smallint NOT NULL default '0',
modthreads smallint NOT NULL default '0',
mod_edit_posts smallint NOT NULL default '0',
| modposts smallint NOT NULL default '0',
modthreads smallint NOT NULL default '0',
mod_edit_posts smallint NOT NULL default '0',
|
| Zeile 302 | Zeile 307 |
|---|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid serial,
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid serial,
|
fid smallint NOT NULL default '0',
uid int NOT NULL default '0',
| fid smallint NOT NULL default '0',
uid int NOT NULL default '0',
|
PRIMARY KEY (fsid)
);";
| PRIMARY KEY (fsid)
);";
|
| Zeile 500 | Zeile 505 |
|---|
uid int NOT NULL default '0',
voteoption smallint NOT NULL default '0',
dateline int NOT NULL default '0',
|
uid int NOT NULL default '0',
voteoption smallint NOT NULL default '0',
dateline int NOT NULL default '0',
|
| | ipaddress bytea NOT NULL default '',
|
PRIMARY KEY (vid)
);";
$tables[] = "CREATE TABLE mybb_posts (
|
PRIMARY KEY (vid)
);";
$tables[] = "CREATE TABLE mybb_posts (
|
pid serial,
| pid serial,
|
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 633 | Zeile 639 |
|---|
id3 int NOT NULL default '0',
uid int NOT NULL default '0',
reportstatus smallint NOT NULL default '0',
|
id3 int NOT NULL default '0',
uid int NOT NULL default '0',
reportstatus smallint 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 default '',
dateline int NOT NULL default '0',
lastreport int 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 default '',
dateline int NOT NULL default '0',
lastreport int NOT NULL default '0',
|
| | PRIMARY KEY (rid)
);";
$tables[] = "CREATE TABLE mybb_reportreasons (
rid serial,
title varchar(250) NOT NULL default '',
appliesto varchar(250) NOT NULL default '',
extra smallint NOT NULL default '0',
disporder smallint NOT NULL default '0',
|
PRIMARY KEY (rid)
);";
| PRIMARY KEY (rid)
);";
|
| Zeile 929 | Zeile 945 |
|---|
candeleteposts smallint NOT NULL default '0',
candeletethreads smallint NOT NULL default '0',
caneditattachments smallint NOT NULL default '0',
|
candeleteposts smallint NOT NULL default '0',
candeletethreads smallint NOT NULL default '0',
caneditattachments smallint NOT NULL default '0',
|
| | canviewdeletionnotice smallint NOT NULL default '0',
|
canpostpolls smallint NOT NULL default '0',
canvotepolls smallint NOT NULL default '0',
canundovotes smallint NOT NULL default '0',
| canpostpolls smallint NOT NULL default '0',
canvotepolls smallint NOT NULL default '0',
canundovotes smallint NOT NULL default '0',
|