Vergleich install/resources/pgsql_db_tables.php - 1.4.2 - 1.4.7

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * $Id: pgsql_db_tables.php 3982 2008-07-04 21:25:56Z Tikitiki $

 * $Id: pgsql_db_tables.php 4290 2008-12-10 02:39:25Z Tikitiki $

 */

$tables[] = "CREATE TABLE mybb_adminlog (

 */

$tables[] = "CREATE TABLE mybb_adminlog (

Zeile 21Zeile 21
$tables[] = "CREATE TABLE mybb_adminoptions (
uid int NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_adminoptions (
uid int NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',

 
  codepress int NOT NULL default '1',

  notes text NOT NULL default '',
permissions text NOT NULL default '',
defaultviews text NOT NULL,

  notes text NOT NULL default '',
permissions text NOT NULL default '',
defaultviews text NOT NULL,

Zeile 164Zeile 165
$tables[] = "CREATE TABLE mybb_datacache (
title varchar(50) NOT NULL default '',
cache text NOT NULL default '',

$tables[] = "CREATE TABLE mybb_datacache (
title varchar(50) NOT NULL default '',
cache text NOT NULL default '',

  UNIQUE (title)

  PRIMARY KEY (title)

);";

$tables[] = "CREATE TABLE mybb_events (

);";

$tables[] = "CREATE TABLE mybb_events (

Zeile 178Zeile 179
  dateline int NOT NULL default '0',
starttime int NOT NULL default '0',
endtime int NOT NULL default '0',

  dateline int NOT NULL default '0',
starttime int NOT NULL default '0',
endtime int NOT NULL default '0',

  timezone int NOT NULL default '0',

  timezone varchar(4) NOT NULL default '0',

  ignoretimezone int NOT NULL default '0',
usingtime int NOT NULL default '0',
repeats text NOT NULL,

  ignoretimezone int NOT NULL default '0',
usingtime int NOT NULL default '0',
repeats text NOT NULL,

Zeile 576Zeile 577
  nopermission int NOT NULL default '0',
location1 int NOT NULL default '0',
location2 int NOT NULL default '0',

  nopermission int NOT NULL default '0',
location1 int NOT NULL default '0',
location2 int NOT NULL default '0',

  loginattempts smallint NOT NULL default '1',
failedlogin bigint NOT NULL default '0',

 
  UNIQUE (sid)
);";


  UNIQUE (sid)
);";


Zeile 585Zeile 584
  gid serial,
name varchar(100) NOT NULL default '',
title varchar(220) NOT NULL default '',

  gid serial,
name varchar(100) NOT NULL default '',
title varchar(220) NOT NULL default '',

  description text NOT NULL default '',
disporder smallint NOT NULL default '0',
isdefault int NOT NULL default '0',

  description text NOT NULL default '',
disporder smallint NOT NULL default '0',
isdefault int NOT NULL default '0',

  PRIMARY KEY (gid)
);";


  PRIMARY KEY (gid)
);";


Zeile 602Zeile 601
  disporder smallint NOT NULL default '0',
gid smallint NOT NULL default '0',
isdefault int NOT NULL default '0',

  disporder smallint NOT NULL default '0',
gid smallint NOT NULL default '0',
isdefault int NOT NULL default '0',

  PRIMARY KEY (sid)

  PRIMARY KEY (sid)

);";



);";



Zeile 617Zeile 616
);";

$tables[] = "CREATE TABLE mybb_spiders (

);";

$tables[] = "CREATE TABLE mybb_spiders (

	sid serial,

	sid serial,

	name varchar(100) NOT NULL default '',
theme int NOT NULL default '0',
language varchar(20) NOT NULL default '',

	name varchar(100) NOT NULL default '',
theme int NOT NULL default '0',
language varchar(20) NOT NULL default '',

Zeile 633Zeile 632
	numthreads numeric(10,0) NOT NULL default '0',
numposts numeric(10,0) NOT NULL default '0',
UNIQUE (dateline)

	numthreads numeric(10,0) NOT NULL default '0',
numposts numeric(10,0) NOT NULL default '0',
UNIQUE (dateline)

);";

);";

	
$tables[] = "CREATE TABLE mybb_tasks (
tid serial,

	
$tables[] = "CREATE TABLE mybb_tasks (
tid serial,

Zeile 659Zeile 658
	dateline bigint NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY(lid)

	dateline bigint NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY(lid)

);";

);";


$tables[] = "CREATE TABLE mybb_templategroups (
gid serial,


$tables[] = "CREATE TABLE mybb_templategroups (
gid serial,

Zeile 771Zeile 770
  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 (
gid serial,


$tables[] = "CREATE TABLE mybb_usergroups (
gid serial,

Zeile 912Zeile 923
  suspensiontime bigint NOT NULL default '0',
coppauser int NOT NULL default '0',
classicpostbit int NOT NULL default '0',

  suspensiontime bigint NOT NULL default '0',
coppauser int NOT NULL default '0',
classicpostbit int NOT NULL default '0',

 
  loginattempts smallint NOT NULL default '1',
failedlogin bigint NOT NULL default '0',

  PRIMARY KEY (uid)
);";


  PRIMARY KEY (uid)
);";


Zeile 953Zeile 966
	expired int NOT NULL default '0',
daterevoked bigint NOT NULL default '0',
revokedby int NOT NULL default '0',

	expired int NOT NULL default '0',
daterevoked bigint NOT NULL default '0',
revokedby int NOT NULL default '0',

	revokereason text NOT NULL,
notes text NOT NULL,

	revokereason text NOT NULL default '',
notes text NOT NULL default '',

	PRIMARY KEY(wid)
);";


	PRIMARY KEY(wid)
);";