| 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 145 | Zeile 148 |
|---|
$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 669 | Zeile 672 |
|---|
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 878 |
|---|
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 960 | Zeile 962 |
|---|
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',
|