From 09e7aef1205423d9e438859deb85b24a7c5d1cb0 Mon Sep 17 00:00:00 2001 From: James Atkinson Date: Thu, 31 May 2001 20:06:23 +0000 Subject: Added post subject to postgres schema. Updated viewtopic query to include group by for the auth forums table when linking after posting git-svn-id: file:///svn/phpbb/trunk@389 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/postgres_schema.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'phpBB/db') diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 216fe4c532..82c04133bc 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -182,10 +182,10 @@ CREATE INDEX _phpbb_forum_mods_index ON phpbb_forum_mods (forum_id, user_id); -------------------------------------------------------- */ CREATE TABLE phpbb_forums ( forum_id int4 DEFAULT nextval('phpbb_forums_id_seq'::text) NOT NULL, + cat_id int4, forum_name varchar(150), forum_desc text, forum_access int2, - cat_id int4, forum_order int4 DEFAULT '1' NOT NULL, forum_type int2, forum_posts int4 DEFAULT '0' NOT NULL, @@ -234,6 +234,7 @@ CREATE INDEX topic_id_phpbb_posts_index ON phpbb_posts (topic_id); -------------------------------------------------------- */ CREATE TABLE phpbb_posts_text ( post_id int4 DEFAULT '0' NOT NULL, + post_subject varchar(255), post_text text, CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id) ); -- cgit v1.2.1