From 4dd500a575ac76ee324714cd7e5a7ec88c44f01d Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Wed, 20 Jun 2001 20:56:02 +0000
Subject: Various minorish updates
git-svn-id: file:///svn/phpbb/trunk@518 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/db/postgres_schema.sql | 22 +++++++++++++++++++---
1 file changed, 19 insertions(+), 3 deletions(-)
(limited to 'phpBB/db/postgres_schema.sql')
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql
index a25d7cb9ed..b433a191da 100644
--- a/phpBB/db/postgres_schema.sql
+++ b/phpBB/db/postgres_schema.sql
@@ -84,6 +84,8 @@ CREATE TABLE phpbb_categories (
-------------------------------------------------------- */
CREATE TABLE phpbb_config (
config_id int2 NOT NULL,
+ selected int2 NOT NULL,
+ disable_board int2 DEFAULT '0' NOT NULL,
sitename varchar(100) NOT NULL,
allow_html int2 NOT NULL,
allow_bbcode int2 NOT NULL,
@@ -110,8 +112,7 @@ CREATE TABLE phpbb_config (
avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL,
override_themes int2 NOT NULL,
flood_interval int NOT NULL,
- selected int2 NOT NULL,
- disable_board int2 DEFAULT '0' NOT NULL,
+ prune_enable int2 DEFAULT '1' NOT NULL,
CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_id)
);
@@ -156,6 +157,20 @@ CREATE INDEX forum_id_phpbb_forums_index ON phpbb_forums (forum_id);
CREATE INDEX forums_order_phpbb_forums_index ON phpbb_forums (forum_order);
+/* --------------------------------------------------------
+ Table structure for table phpbb_forum_prune
+-------------------------------------------------------- */
+CREATE TABLE phpbb_forum_prune (
+ prune_id int4 NOT NULL auto_increment,
+ forum_id int4 NOT NULL,
+ prune_days int4 NOT NULL,
+ prune_freq int4 NOT NULL,
+ CONSTRAINT phpbb_forum_prune_pkey PRIMARY KEY (prune_id)
+);
+CREATE INDEX prune_id_phpbb_forum_prune_index ON phpbb_forum_prune (cat_id);
+CREATE INDEX forum_id_phpbb_forum_prune_index ON phpbb_forum_prune (forum_id);
+
+
/* --------------------------------------------------------
Table structure for table phpbb_groups
-------------------------------------------------------- */
@@ -373,7 +388,8 @@ CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id);
-------------------------------------------------------- */
CREATE TABLE phpbb_user_group (
group_id int DEFAULT '0' NOT NULL,
- user_id int DEFAULT '0' NOT NULL
+ user_id int DEFAULT '0' NOT NULL,
+ user_pending int2
);
CREATE INDEX group_id_phpbb_user_group_index ON phpbb_user_group (group_id);
CREATE INDEX user_id_phpbb_user_group_index ON phpbb_user_group (user_id);
--
cgit v1.2.1