diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-04-30 14:08:14 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-04-30 14:08:14 +0000 |
| commit | 20fda3315f10970d6fd81cfababbb4b65a3c20cd (patch) | |
| tree | ec6b35f8113e88d4c44a869ff87c4d4a90db5874 /phpBB/install/schemas/postgres_schema.sql | |
| parent | d1f3349f7b7cd7816c125cf83616db154a43b8b1 (diff) | |
| download | forums-20fda3315f10970d6fd81cfababbb4b65a3c20cd.tar forums-20fda3315f10970d6fd81cfababbb4b65a3c20cd.tar.gz forums-20fda3315f10970d6fd81cfababbb4b65a3c20cd.tar.bz2 forums-20fda3315f10970d6fd81cfababbb4b65a3c20cd.tar.xz forums-20fda3315f10970d6fd81cfababbb4b65a3c20cd.zip | |
- schema changes
git-svn-id: file:///svn/phpbb/trunk@5131 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 9879515815..b07992cdfe 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -671,6 +671,7 @@ CREATE TABLE phpbb_profile_fields ( field_required INT2 DEFAULT '0' NOT NULL, field_show_on_reg INT2 DEFAULT '0' NOT NULL, field_hide INT2 DEFAULT '0' NOT NULL, + field_no_view INT2 DEFAULT '0' NOT NULL, field_active INT2 DEFAULT '0' NOT NULL, field_order INT2 DEFAULT '0' NOT NULL, PRIMARY KEY (field_id), @@ -678,6 +679,7 @@ CREATE TABLE phpbb_profile_fields ( CHECK (field_required>=0), CHECK (field_show_on_reg>=0), CHECK (field_hide>=0), + CHECK (field_no_view>=0), CHECK (field_active>=0), CHECK (field_order>=0) ); @@ -1083,11 +1085,13 @@ SELECT SETVAL('phpbb_topics_topic_id_seq',(select case when max(topic_id)>0 then CREATE TABLE phpbb_topics_marking ( user_id INT4 DEFAULT '0' NOT NULL, topic_id INT4 DEFAULT '0' NOT NULL, + forum_id INT4 DEFAULT '0' NOT NULL, mark_type INT2 DEFAULT '0' NOT NULL, mark_time INT4 DEFAULT '0' NOT NULL, PRIMARY KEY (user_id,topic_id), CHECK (user_id>=0), - CHECK (topic_id>=0) + CHECK (topic_id>=0), + CHECK (forum_id>=0) ); /* Table: phpbb_topics_watch */ |