| Zeile 304 | Zeile 304 |
|---|
$tables[] = "CREATE TABLE mybb_forumsread (
fid int NOT NULL default '0',
uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_forumsread (
fid int NOT NULL default '0',
uid int NOT NULL default '0',
|
dateline int NOT NULL default '0'
| dateline int NOT NULL default '0',
UNIQUE (fid, uid)
|
);";
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
| );";
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
|
| Zeile 519 | Zeile 520 |
|---|
subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',
|
subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',
|
username varchar(80) NOT NULL default '',
| username varchar(120) NOT NULL default '',
|
dateline int NOT NULL default '0',
message text NOT NULL default '',
ipaddress bytea NOT NULL default '',
|
dateline int NOT NULL default '0',
message text NOT NULL default '',
ipaddress bytea NOT NULL default '',
|
includesig smallint NOT NULL default '0',
| includesig smallint NOT NULL default '0',
|
smilieoff smallint NOT NULL default '0',
edituid int NOT NULL default '0',
edittime int NOT NULL default '0',
| smilieoff smallint NOT NULL default '0',
edituid int NOT NULL default '0',
edittime int NOT NULL default '0',
|
| Zeile 738 | Zeile 739 |
|---|
ipaddress bytea NOT NULL default '',
dateline numeric(30,0) NOT NULL default '0',
data text NOT NULL default '',
|
ipaddress bytea NOT NULL default '',
dateline numeric(30,0) NOT NULL default '0',
data text NOT NULL default '',
|
PRIMARY KEY (sid)
);";
| PRIMARY KEY (sid)
);";
|
$tables[] = "CREATE TABLE mybb_spiders (
sid serial,
name varchar(100) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_spiders (
sid serial,
name varchar(100) NOT NULL default '',
|
| Zeile 863 | Zeile 864 |
|---|
icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',
|
icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',
|
username varchar(80) NOT NULL default '',
| username varchar(120) NOT NULL default '',
|
dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',
| dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',
|
| Zeile 887 | Zeile 888 |
|---|
$tables[] = "CREATE TABLE mybb_threadsread (
tid int NOT NULL default '0',
uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_threadsread (
tid int NOT NULL default '0',
uid int NOT NULL default '0',
|
dateline int NOT NULL default '0'
| dateline int NOT NULL default '0',
UNIQUE (tid, uid)
|
);";
$tables[] = "CREATE TABLE mybb_threadsubscriptions (
| );";
$tables[] = "CREATE TABLE mybb_threadsubscriptions (
|
| Zeile 1024 | Zeile 1026 |
|---|
lastvisit int NOT NULL default '0',
lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',
|
lastvisit int NOT NULL default '0',
lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',
|
icq varchar(10) 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 '',
|