| Zeile 6 | Zeile 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 21 | Zeile 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 164 | Zeile 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 178 | Zeile 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 576 | Zeile 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 585 | Zeile 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 602 | Zeile 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 617 | Zeile 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 633 | Zeile 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 659 | Zeile 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 771 | Zeile 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 912 | Zeile 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 953 | Zeile 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)
);";
|