Vergleich install/resources/pgsql_db_tables.php - 1.8.30 - 1.8.37

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 304Zeile 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 523Zeile 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 887Zeile 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 906Zeile 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 (