Vergleich install/resources/pgsql_db_tables.php - 1.8.5 - 1.8.7

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 46Zeile 46
	dateline int NOT NULL default '0',
lastactive int NOT NULL default '0',
data text NOT NULL default '',

	dateline int NOT NULL default '0',
lastactive int NOT NULL default '0',
data text NOT NULL default '',

	useragent varchar(100) NOT NULL default '',

	useragent varchar(200) NOT NULL default '',

	authenticated smallint NOT NULL default '0'
);";


	authenticated smallint NOT NULL default '0'
);";


Zeile 148Zeile 148

$tables[] = "CREATE TABLE mybb_buddyrequests (
id serial,


$tables[] = "CREATE TABLE mybb_buddyrequests (
id serial,

 uid int NOT NULL,
touid int NOT NULL,
date int NOT NULL,

 uid int NOT NULL default '0',
touid int NOT NULL default '0',
date int NOT NULL default '0',

 PRIMARY KEY (id)
);";


 PRIMARY KEY (id)
);";


Zeile 672Zeile 672
  ip bytea NOT NULL default '',
time int NOT NULL default '0',
location varchar(150) NOT NULL default '',

  ip bytea NOT NULL default '',
time int NOT NULL default '0',
location varchar(150) NOT NULL default '',

  useragent varchar(100) NOT NULL default '',

  useragent varchar(200) NOT NULL default '',

  anonymous smallint NOT NULL default '0',
nopermission smallint NOT NULL default '0',
location1 int NOT NULL default '0',

  anonymous smallint NOT NULL default '0',
nopermission smallint NOT NULL default '0',
location1 int NOT NULL default '0',

Zeile 878Zeile 878
  tid int NOT NULL default '0',
notification smallint NOT NULL default '0',
dateline int NOT NULL default '0',

  tid int NOT NULL default '0',
notification smallint NOT NULL default '0',
dateline int NOT NULL default '0',

  subscriptionkey varchar(32) NOT NULL default '',

 
  PRIMARY KEY (sid)
);";


  PRIMARY KEY (sid)
);";