diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-20 20:56:02 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-20 20:56:02 +0000 |
| commit | 4dd500a575ac76ee324714cd7e5a7ec88c44f01d (patch) | |
| tree | 96f250712f2eda5729a381a8acb6f2f5ecc1d954 /phpBB/db/postgres_schema.sql | |
| parent | 29ba71e5aa641129671d8e2c8b6e92a018ae21cd (diff) | |
| download | forums-4dd500a575ac76ee324714cd7e5a7ec88c44f01d.tar forums-4dd500a575ac76ee324714cd7e5a7ec88c44f01d.tar.gz forums-4dd500a575ac76ee324714cd7e5a7ec88c44f01d.tar.bz2 forums-4dd500a575ac76ee324714cd7e5a7ec88c44f01d.tar.xz forums-4dd500a575ac76ee324714cd7e5a7ec88c44f01d.zip | |
Various minorish updates
git-svn-id: file:///svn/phpbb/trunk@518 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 22 |
1 files changed, 19 insertions, 3 deletions
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) ); @@ -157,6 +158,20 @@ 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 -------------------------------------------------------- */ CREATE 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); |