Vergleich install/resources/pgsql_db_tables.php - 1.8.25 - 1.8.32

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 104Zeile 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 905Zeile 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 976Zeile 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',