| 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 905 | Zeile 906 |
|---|
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 976 | Zeile 967 |
|---|
canratemembers smallint NOT NULL default '0',
canchangename smallint NOT NULL default '0',
canbereported smallint NOT NULL default '0',
|
canratemembers smallint NOT NULL default '0',
canchangename smallint NOT NULL default '0',
canbereported smallint NOT NULL default '0',
|
| | canbeinvisible smallint NOT NULL default '1',
|
canchangewebsite smallint NOT NULL default '1',
showforumteam smallint NOT NULL default '0',
usereputationsystem smallint NOT NULL default '0',
| canchangewebsite smallint NOT NULL default '1',
showforumteam smallint NOT NULL default '0',
usereputationsystem smallint NOT NULL default '0',
|