| 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',
|
2fasecret varchar(16) NOT NULL default '',
| authsecret varchar(16) NOT NULL default '',
|
recovery_codes varchar(177) NOT NULL default '',
UNIQUE (uid)
);";
| recovery_codes varchar(177) NOT NULL default '',
UNIQUE (uid)
);";
|
| Zeile 46 | 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'
);";
| authenticated smallint NOT NULL default '0'
);";
|
| Zeile 64 | Zeile 64 |
|---|
perpage smallint NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY (vid)
|
perpage smallint NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY (vid)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_announcements (
aid serial,
fid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_announcements (
aid serial,
fid int NOT NULL default '0',
|
| Zeile 85 | Zeile 85 |
|---|
pid int NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int NOT NULL default '0',
|
pid int 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 NOT NULL default '0',
|
filetype varchar(120) NOT NULL default '',
filesize int NOT NULL default '0',
|
attachname varchar(120) NOT NULL default '',
| attachname varchar(255) NOT NULL default '',
|
downloads int NOT NULL default '0',
dateuploaded int NOT NULL default '0',
visible smallint NOT NULL default '0',
thumbnail varchar(120) NOT NULL default '',
|
downloads int NOT NULL default '0',
dateuploaded int NOT NULL default '0',
visible smallint NOT NULL default '0',
thumbnail varchar(120) NOT NULL default '',
|
PRIMARY KEY (aid)
);";
| PRIMARY KEY (aid)
);";
|
$tables[] = "CREATE TABLE mybb_attachtypes (
atid serial,
name varchar(120) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_attachtypes (
atid serial,
name varchar(120) NOT NULL default '',
|
| 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)
|
PRIMARY KEY (atid)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid serial,
|
$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid serial,
|
| Zeile 120 | Zeile 124 |
|---|
$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 '',
|
| | regex smallint NOT NULL default '0',
|
replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
|
replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_banfilters (
fid serial,
|
$tables[] = "CREATE TABLE mybb_banfilters (
fid serial,
|
| Zeile 148 | Zeile 153 |
|---|
$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 239 | Zeile 244 |
|---|
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 344 | Zeile 350 |
|---|
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,
uid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_joinrequests (
rid serial,
uid int NOT NULL default '0',
|
| Zeile 491 | Zeile 497 |
|---|
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 (
vid serial,
|
$tables[] = "CREATE TABLE mybb_pollvotes (
vid serial,
|
| Zeile 500 | Zeile 506 |
|---|
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 633 | Zeile 640 |
|---|
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 672 | Zeile 689 |
|---|
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 878 | Zeile 895 |
|---|
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 930 | Zeile 946 |
|---|
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 1016 | Zeile 1033 |
|---|
lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',
|
lastpost int NOT NULL default '0',
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 1076 | Zeile 1091 |
|---|
suspendsigtime int NOT NULL default '0',
coppauser smallint NOT NULL default '0',
classicpostbit smallint NOT NULL default '0',
|
suspendsigtime int NOT NULL default '0',
coppauser smallint NOT NULL default '0',
classicpostbit smallint NOT NULL default '0',
|
loginattempts smallint NOT NULL default '1',
| loginattempts smallint NOT NULL default '0',
loginlockoutexpiry int NOT NULL default '0',
|
usernotes text NOT NULL default '',
sourceeditor smallint NOT NULL default '0',
PRIMARY KEY (uid)
| usernotes text NOT NULL default '',
sourceeditor smallint NOT NULL default '0',
PRIMARY KEY (uid)
|