| 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 906 | Zeile 908 |
|---|
fid3 text NOT NULL default '',
PRIMARY KEY (ufid)
);";
|
fid3 text NOT NULL default '',
PRIMARY KEY (ufid)
);";
|
$query = $db->write_query("SELECT column_name
FROM information_schema.constraint_column_usage
WHERE table_name = '".$config['tableprefix']."userfields'
AND constraint_name = '".$config['tableprefix']."userfields_pkey'
LIMIT 1");
$main_field = $db->fetch_field($query, 'column_name');
if(!empty($main_field))
{
$tables[] = "DROP SEQUENCE mybb_userfields_ufid_seq;";
}
| |
$tables[] = "CREATE SEQUENCE mybb_userfields_ufid_seq;";
$tables[] = "CREATE TABLE mybb_usergroups (
| $tables[] = "CREATE SEQUENCE mybb_userfields_ufid_seq;";
$tables[] = "CREATE TABLE mybb_usergroups (
|
| Zeile 1034 | 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 '',
|