Zeile 104 | Zeile 104 |
---|
maxsize int NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled smallint NOT NULL default '1',
|
maxsize int NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled smallint NOT NULL default '1',
|
| forcedownload smallint NOT NULL default '0',
|
groups text NOT NULL default '-1', forums text NOT NULL default '-1', avatarfile smallint NOT NULL default '0',
| groups text NOT NULL default '-1', forums text NOT NULL default '-1', avatarfile smallint NOT NULL default '0',
|
Zeile 303 | 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 522 | Zeile 524 |
---|
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 886 | 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 905 | 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 (
|