| Zeile 33 | Zeile 33 |
|---|
defaultviews text NOT NULL,
loginattempts smallint NOT NULL default '0',
loginlockoutexpiry int NOT NULL default '0',
|
defaultviews text NOT NULL,
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 '',
|
UNIQUE (uid)
);";
| UNIQUE (uid)
);";
|
| Zeile 44 | Zeile 46 |
|---|
dateline int NOT NULL default '0',
lastactive int NOT NULL default '0',
data text NOT NULL default '',
|
dateline int NOT NULL default '0',
lastactive int NOT NULL default '0',
data text NOT NULL default '',
|
useragent varchar(100) NOT NULL default ''
| useragent varchar(200) NOT NULL default '',
authenticated smallint NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_adminviews (
| );";
$tables[] = "CREATE TABLE mybb_adminviews (
|
| Zeile 100 | 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)
);";
| PRIMARY KEY (atid)
);";
|
| Zeile 145 | Zeile 152 |
|---|
$tables[] = "CREATE TABLE mybb_buddyrequests (
id serial,
|
$tables[] = "CREATE TABLE mybb_buddyrequests (
id serial,
|
uid int NOT NULL,
touid int NOT NULL,
date int NOT NULL,
| uid int NOT NULL default '0',
touid int NOT NULL default '0',
date int NOT NULL default '0',
|
PRIMARY KEY (id)
);";
| PRIMARY KEY (id)
);";
|
| Zeile 193 | Zeile 200 |
|---|
did serial,
type varchar(30) NOT NULL default '',
delaydateline int NOT NULL default '0',
|
did serial,
type varchar(30) NOT NULL default '',
delaydateline int NOT NULL default '0',
|
uid int NOT NULL default '0',
fid smallint NOT NULL default '0',
| uid int NOT NULL default '0',
fid smallint NOT NULL default '0',
|
tids text NOT NULL,
dateline int NOT NULL default '0',
inputs text NOT NULL default '',
| tids text NOT NULL,
dateline int NOT NULL default '0',
inputs text NOT NULL default '',
|
| Zeile 236 | Zeile 243 |
|---|
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',
|
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 264 | Zeile 272 |
|---|
lastposteruid int NOT NULL default '0',
lastposttid int NOT NULL default '0',
lastpostsubject varchar(120) NOT NULL default '',
|
lastposteruid int NOT NULL default '0',
lastposttid int NOT NULL default '0',
lastpostsubject varchar(120) NOT NULL default '',
|
allowhtml smallint NOT NULL default '0',
allowmycode smallint NOT NULL default '0',
allowsmilies smallint NOT NULL default '0',
allowimgcode smallint NOT NULL default '0',
allowvideocode smallint NOT NULL default '0',
| allowhtml smallint NOT NULL default '0',
allowmycode smallint NOT NULL default '0',
allowsmilies smallint NOT NULL default '0',
allowimgcode smallint NOT NULL default '0',
allowvideocode smallint NOT NULL default '0',
|
allowpicons smallint NOT NULL default '0',
allowtratings smallint NOT NULL default '0',
usepostcounts smallint NOT NULL default '0',
| allowpicons smallint NOT NULL default '0',
allowtratings smallint NOT NULL default '0',
usepostcounts smallint NOT NULL default '0',
|
| Zeile 295 | Zeile 303 |
|---|
fid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int NOT NULL default '0'
|
fid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid serial,
fid smallint NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid serial,
fid smallint NOT NULL default '0',
|
| Zeile 341 | Zeile 349 |
|---|
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)
|
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_joinrequests (
rid serial,
|
$tables[] = "CREATE TABLE mybb_joinrequests (
rid serial,
|
| Zeile 488 | Zeile 496 |
|---|
multiple smallint NOT NULL default '0',
public smallint NOT NULL default '0',
maxoptions smallint NOT NULL default '0',
|
multiple smallint NOT NULL default '0',
public smallint NOT NULL default '0',
maxoptions smallint NOT NULL default '0',
|
PRIMARY KEY (pid)
| PRIMARY KEY (pid)
|
);";
$tables[] = "CREATE TABLE mybb_pollvotes (
| );";
$tables[] = "CREATE TABLE mybb_pollvotes (
|
| Zeile 497 | 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)
);";
| PRIMARY KEY (vid)
);";
|
| Zeile 630 | 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 669 | Zeile 688 |
|---|
ip bytea NOT NULL default '',
time int NOT NULL default '0',
location varchar(150) NOT NULL default '',
|
ip bytea NOT NULL default '',
time int NOT NULL default '0',
location varchar(150) NOT NULL default '',
|
useragent varchar(100) NOT NULL default '',
| useragent varchar(200) NOT NULL default '',
|
anonymous smallint NOT NULL default '0',
nopermission smallint NOT NULL default '0',
location1 int NOT NULL default '0',
| anonymous smallint NOT NULL default '0',
nopermission smallint NOT NULL default '0',
location1 int NOT NULL default '0',
|
| Zeile 875 | Zeile 894 |
|---|
tid int NOT NULL default '0',
notification smallint NOT NULL default '0',
dateline int NOT NULL default '0',
|
tid int NOT NULL default '0',
notification smallint NOT NULL default '0',
dateline int NOT NULL default '0',
|
subscriptionkey varchar(32) NOT NULL default '',
| |
PRIMARY KEY (sid)
);";
| PRIMARY KEY (sid)
);";
|
| Zeile 927 | 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',
|
| Zeile 960 | Zeile 979 |
|---|
showforumteam smallint NOT NULL default '0',
usereputationsystem smallint NOT NULL default '0',
cangivereputations smallint NOT NULL default '0',
|
showforumteam smallint NOT NULL default '0',
usereputationsystem smallint NOT NULL default '0',
cangivereputations smallint NOT NULL default '0',
|
| | candeletereputations smallint NOT NULL default '0',
|
reputationpower int NOT NULL default '0',
maxreputationsday int NOT NULL default '0',
maxreputationsperuser int NOT NULL default '0',
| reputationpower int NOT NULL default '0',
maxreputationsday int NOT NULL default '0',
maxreputationsperuser int NOT NULL default '0',
|