diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-05-31 20:06:23 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-05-31 20:06:23 +0000 |
| commit | 09e7aef1205423d9e438859deb85b24a7c5d1cb0 (patch) | |
| tree | e05b7be1d42e63009fdaaac580fd6805fefbda2c /phpBB/db | |
| parent | 3ed50ce0b7665fcd6a2a80d1f5bc6630089382d5 (diff) | |
| download | forums-09e7aef1205423d9e438859deb85b24a7c5d1cb0.tar forums-09e7aef1205423d9e438859deb85b24a7c5d1cb0.tar.gz forums-09e7aef1205423d9e438859deb85b24a7c5d1cb0.tar.bz2 forums-09e7aef1205423d9e438859deb85b24a7c5d1cb0.tar.xz forums-09e7aef1205423d9e438859deb85b24a7c5d1cb0.zip | |
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
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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) ); |