| 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 4392 2009-07-05 21:36:50Z RyanGordon $
|
*/
|
*/
|
| |
// 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 21 | Zeile 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 35 | Zeile 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 63 | Zeile 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 90 | Zeile 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 120 | Zeile 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 164 | Zeile 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 178 | Zeile 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 348 | Zeile 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 402 | Zeile 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 416 | Zeile 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 460 | Zeile 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 576 | Zeile 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 771 | Zeile 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 912 | Zeile 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 953 | Zeile 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)
);";
|