diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-09 23:17:03 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-09 23:17:03 +0000 |
| commit | 130f401866b5684c154a9fdff3ee448cb25942c8 (patch) | |
| tree | 9824991c7c8e4462fd0d9ab4b0b4de6c937d8cd9 /phpBB | |
| parent | 8d7c6d37ec40b5776e1ee7ed0a42cae2717fe85d (diff) | |
| download | forums-130f401866b5684c154a9fdff3ee448cb25942c8.tar forums-130f401866b5684c154a9fdff3ee448cb25942c8.tar.gz forums-130f401866b5684c154a9fdff3ee448cb25942c8.tar.bz2 forums-130f401866b5684c154a9fdff3ee448cb25942c8.tar.xz forums-130f401866b5684c154a9fdff3ee448cb25942c8.zip | |
Fixed various errors
git-svn-id: file:///svn/phpbb/trunk@612 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 1e5813bdf1..bad7d810a8 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -19,7 +19,7 @@ CREATE SEQUENCE phpbb_topics_id_seq start 1 increment 1 maxvalue 2147483647 minv CREATE SEQUENCE phpbb_users_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_words_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_groups_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; - +CREATE SEQUENCE phpbb_forum_prune_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; /* -------------------------------------------------------- Table structure for table phpbb_auth_access @@ -39,7 +39,9 @@ CREATE TABLE phpbb_auth_access ( auth_attachments int2 DEFAULT '0' NOT NULL, auth_vote int2 DEFAULT '0' NOT NULL, auth_mod int2 DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_auth_access_pkey PRIMARY KEY (group_id) ); +CREATE INDEX group_id_phpbb_auth_access_index ON phpbb_auth_access (forum_id); /* -------------------------------------------------------- @@ -164,13 +166,13 @@ 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, + prune_id int4 DEFAULT nextval('phpbb_forum_prune_id_seq'::text) NOT NULL, 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 prune_id_phpbb_forum_prune_index ON phpbb_forum_prune (prune_id); CREATE INDEX forum_id_phpbb_forum_prune_index ON phpbb_forum_prune (forum_id); @@ -178,12 +180,11 @@ CREATE INDEX forum_id_phpbb_forum_prune_index ON phpbb_forum_prune (forum_id); Table structure for table phpbb_groups -------------------------------------------------------- */ CREATE TABLE phpbb_groups ( - group_id int4 DEFAULT '0' NOT NULL, - group_name varchar(100) DEFAULT '' NOT NULL, - group_description varchar(255) DEFAULT '' NOT NULL, + group_id int4 DEFAULT nextval('phpbb_groups_id_seq'::text) NOT NULL, + group_name varchar(100) NOT NULL, + group_description varchar(255) NOT NULL, group_moderator int4 NOT NULL, - group_single_user int2 NOT NULL, - CONSTRAINT phpbb_groups_pkey PRIMARY_KEY (group_id) + group_single_user int2 NOT NULL ); |