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

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 85Zeile 85
  pid int NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int NOT NULL default '0',

  pid int NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int NOT NULL default '0',

  filename varchar(120) NOT NULL default '',

  filename varchar(255) NOT NULL default '',

  filetype varchar(120) NOT NULL default '',
filesize int NOT NULL default '0',

  filetype varchar(120) NOT NULL default '',
filesize int NOT NULL default '0',

  attachname varchar(120) NOT NULL default '',

  attachname varchar(255) NOT NULL default '',

  downloads int NOT NULL default '0',
dateuploaded int NOT NULL default '0',
visible smallint NOT NULL default '0',

  downloads int NOT NULL default '0',
dateuploaded int NOT NULL default '0',
visible smallint NOT NULL default '0',

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 124Zeile 125
$tables[] = "CREATE TABLE mybb_badwords (
bid serial,
badword varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_badwords (
bid serial,
badword varchar(100) NOT NULL default '',

 
  regex smallint NOT NULL default '0',

  replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
);";

  replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
);";

Zeile 302Zeile 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 505Zeile 508
  uid int NOT NULL default '0',
voteoption smallint NOT NULL default '0',
dateline int NOT NULL default '0',

  uid int NOT NULL default '0',
voteoption smallint NOT NULL default '0',
dateline int NOT NULL default '0',

 
  ipaddress bytea NOT NULL default '',

  PRIMARY KEY (vid)
);";


  PRIMARY KEY (vid)
);";


Zeile 520Zeile 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 666Zeile 670
  dateline int NOT NULL default '0',
comments text NOT NULL default '',
PRIMARY KEY(rid)

  dateline int NOT NULL default '0',
comments text NOT NULL default '',
PRIMARY KEY(rid)

);";

);";


$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',


$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',

Zeile 884Zeile 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 903Zeile 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 974Zeile 969
  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',

Zeile 1031Zeile 1027
  lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',

  lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',

  aim varchar(50) NOT NULL default '',
yahoo varchar(50) 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 '',

Zeile 1091Zeile 1085
  suspendsigtime int NOT NULL default '0',
coppauser smallint NOT NULL default '0',
classicpostbit smallint NOT NULL default '0',

  suspendsigtime int NOT NULL default '0',
coppauser smallint NOT NULL default '0',
classicpostbit smallint NOT NULL default '0',

  loginattempts smallint NOT NULL default '1',


  loginattempts smallint NOT NULL default '0',
loginlockoutexpiry int NOT NULL default '0',

  usernotes text NOT NULL default '',
sourceeditor smallint NOT NULL default '0',
PRIMARY KEY (uid)

  usernotes text NOT NULL default '',
sourceeditor smallint NOT NULL default '0',
PRIMARY KEY (uid)