Vergleich install/resources/pgsql_db_tables.php - 1.8.38 - 1.8.39

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 520Zeile 520
  subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',

  subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',

  username varchar(80) NOT NULL default '',

  username varchar(120) NOT NULL default '',

  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 '',

Zeile 649Zeile 649
  reporters text NOT NULL default '',
dateline int NOT NULL default '0',
lastreport int NOT NULL default '0',

  reporters text NOT NULL default '',
dateline int NOT NULL default '0',
lastreport int NOT NULL default '0',

  PRIMARY KEY (rid)

  PRIMARY KEY (rid)

);";

$tables[] = "CREATE TABLE mybb_reportreasons (

);";

$tables[] = "CREATE TABLE mybb_reportreasons (

Zeile 777Zeile 777
	logging smallint NOT NULL default '0',
locked int NOT NULL default '0',
PRIMARY KEY(tid)

	logging smallint NOT NULL default '0',
locked int NOT NULL default '0',
PRIMARY KEY(tid)

);";


);";


$tables[] = "CREATE TABLE mybb_tasklog (
lid serial,
tid int NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_tasklog (
lid serial,
tid int NOT NULL default '0',

Zeile 803Zeile 803
  version varchar(20) NOT NULL default '0',
status varchar(10) NOT NULL default '',
dateline int NOT NULL default '0',

  version varchar(20) NOT NULL default '0',
status varchar(10) NOT NULL default '',
dateline int NOT NULL default '0',

  PRIMARY KEY (tid)
);";


  PRIMARY KEY (tid)
);";


$tables[] = "CREATE TABLE mybb_templatesets (
sid serial,
title varchar(120) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_templatesets (
sid serial,
title varchar(120) NOT NULL default '',

Zeile 821Zeile 821
  stylesheets text NOT NULL default '',
allowedgroups text NOT NULL default '',
PRIMARY KEY (tid)

  stylesheets text NOT NULL default '',
allowedgroups text NOT NULL default '',
PRIMARY KEY (tid)

);";

);";


$tables[] = "CREATE TABLE mybb_themestylesheets(
sid serial,


$tables[] = "CREATE TABLE mybb_themestylesheets(
sid serial,

Zeile 832Zeile 832
	cachefile varchar(100) NOT NULL default '',
lastmodified numeric(30,0) NOT NULL default '0',
PRIMARY KEY(sid)

	cachefile varchar(100) NOT NULL default '',
lastmodified numeric(30,0) NOT NULL default '0',
PRIMARY KEY(sid)

);";

);";


$tables[] = "CREATE TABLE mybb_threadprefixes (
pid serial,


$tables[] = "CREATE TABLE mybb_threadprefixes (
pid serial,

Zeile 841Zeile 841
	forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)

	forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)

);";


);";


$tables[] = "CREATE TABLE mybb_threadratings (
rid serial,
tid int NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_threadratings (
rid serial,
tid int NOT NULL default '0',

Zeile 864Zeile 864
  icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',

  icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',

  username varchar(80) NOT NULL default '',

  username varchar(120) NOT NULL default '',

  dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',

  dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',

Zeile 1026Zeile 1026
  lastvisit int NOT NULL default '0',
lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',

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

  icq varchar(10) 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 '',