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

  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 5379 2011-02-21 11:06:42Z Tomm $

 */

 */

 

// Disallow direct access to this file for security reasons
if(!defined("IN_MYBB"))
{
die("Direct initialization of this file is not allowed.<br /><br />Please make sure IN_MYBB is defined.");
}


$tables[] = "CREATE TABLE mybb_adminlog (
uid int NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_adminlog (
uid int NOT NULL default '0',

Zeile 21Zeile 27
$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 35Zeile 42
	dateline bigint NOT NULL default '0',
lastactive bigint NOT NULL default '0',
data text NOT NULL default ''

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

);";

);";


$tables[] = "CREATE TABLE mybb_adminviews (
vid serial,


$tables[] = "CREATE TABLE mybb_adminviews (
vid serial,

Zeile 63Zeile 70
  allowhtml int NOT NULL default '0',
allowmycode int NOT NULL default '0',
allowsmilies int NOT NULL default '0',

  allowhtml int NOT NULL default '0',
allowmycode int NOT NULL default '0',
allowsmilies int NOT NULL default '0',

  PRIMARY KEY (aid)

  PRIMARY KEY (aid)

);";

$tables[] = "CREATE TABLE mybb_attachments (

);";

$tables[] = "CREATE TABLE mybb_attachments (

Zeile 90Zeile 97
  maxsize int NOT NULL default '0',
icon varchar(100) NOT NULL default '',
PRIMARY KEY (atid)

  maxsize int NOT NULL default '0',
icon varchar(100) NOT NULL default '',
PRIMARY KEY (atid)

);";


);";


$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid serial,
uid int NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid serial,
uid int NOT NULL default '0',

Zeile 120Zeile 127
);";

$tables[] = "CREATE TABLE mybb_banned (

);";

$tables[] = "CREATE TABLE mybb_banned (

  uid int NOT NULL default '0',
gid int NOT NULL default '0',

  uid int NOT NULL default '0',
gid int NOT NULL default '0',

  oldgroup int NOT NULL default '0',
oldadditionalgroups text NOT NULL default '',
olddisplaygroup int NOT NULL default '0',

  oldgroup int NOT NULL default '0',
oldadditionalgroups text NOT NULL default '',
olddisplaygroup int NOT NULL default '0',

Zeile 164Zeile 171
$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 185
  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 348Zeile 355
$tables[] = "CREATE TABLE mybb_maillogs (
mid serial,
subject varchar(200) not null default '',

$tables[] = "CREATE TABLE mybb_maillogs (
mid serial,
subject varchar(200) not null default '',

	message text NOT NULL default '',

	message text NOT NULL default '',

	dateline bigint NOT NULL default '0',
fromuid int NOT NULL default '0',
fromemail varchar(200) not null default '',

	dateline bigint NOT NULL default '0',
fromuid int NOT NULL default '0',
fromemail varchar(200) not null default '',

Zeile 402Zeile 409
	postoptions text NOT NULL default '',
threadoptions text NOT NULL default '',
PRIMARY KEY (tid)

	postoptions text NOT NULL default '',
threadoptions text NOT NULL default '',
PRIMARY KEY (tid)

);";


);";


$tables[] = "CREATE TABLE mybb_mycode (
cid serial,
title varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_mycode (
cid serial,
title varchar(100) NOT NULL default '',

Zeile 416Zeile 423
);";

$tables[] = "CREATE TABLE mybb_polls (

);";

$tables[] = "CREATE TABLE mybb_polls (

  pid serial,
tid int NOT NULL default '0',

  pid serial,
tid int NOT NULL default '0',

  question varchar(200) NOT NULL default '',
dateline bigint NOT NULL default '0',
options text NOT NULL default '',

  question varchar(200) NOT NULL default '',
dateline bigint NOT NULL default '0',
options text NOT NULL default '',

Zeile 460Zeile 467
  visible int NOT NULL default '0',
posthash varchar(32) NOT NULL default '',
PRIMARY KEY (pid)

  visible int NOT NULL default '0',
posthash varchar(32) NOT NULL default '',
PRIMARY KEY (pid)

);";


);";



$tables[] = "CREATE TABLE mybb_privatemessages (
pmid serial,


$tables[] = "CREATE TABLE mybb_privatemessages (
pmid serial,

Zeile 576Zeile 583
  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 771Zeile 776
  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 929
  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 972
	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)
);";