diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-06-07 07:56:45 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-06-07 07:56:45 +0000 |
| commit | 1010b488ca951c141aa924d814755d97d1599e9b (patch) | |
| tree | 36b167ccc4ae0b5df18c9db0a58bbaf7d3da203a /phpBB/db/postgres_schema.sql | |
| parent | f49da7909befa8cb1745236bcb6e0b4d1ad87762 (diff) | |
| download | forums-1010b488ca951c141aa924d814755d97d1599e9b.tar forums-1010b488ca951c141aa924d814755d97d1599e9b.tar.gz forums-1010b488ca951c141aa924d814755d97d1599e9b.tar.bz2 forums-1010b488ca951c141aa924d814755d97d1599e9b.tar.xz forums-1010b488ca951c141aa924d814755d97d1599e9b.zip | |
Forum level annoucements and sticky topics are done.
Added topic_type field to the topics database in order to handle ordering. Would have used topic_status but that would have messed up the ordering when topics were locked
git-svn-id: file:///svn/phpbb/trunk@437 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 5863deac54..06e79697af 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -34,7 +34,7 @@ CREATE TABLE phpbb_auth_forums ( auth_announce int2 DEFAULT '0' NOT NULL, auth_sticky int2 DEFAULT '0' NOT NULL, auth_votecreate int2 DEFAULT '0' NOT NULL, - auth_vote int2 DEFAULT '0' NOT NULL, + auth_vote int2 DEFAULT '0' NOT NULL, auth_attachments int2 DEFAULT '0' NOT NULL ); @@ -53,8 +53,8 @@ CREATE TABLE phpbb_auth_access ( auth_delete int2 DEFAULT '0' NOT NULL, auth_announce int2 DEFAULT '0' NOT NULL, auth_sticky int2 DEFAULT '0' NOT NULL, - auth_votecreate int2 DEFAULT '0' NOT NULL, - auth_attachments int2 DEFAULT '0' NOT NULL, + auth_votecreate int2 DEFAULT '0' NOT NULL, + auth_attachments int2 DEFAULT '0' NOT NULL, auth_vote int2 DEFAULT '0' NOT NULL, auth_mod int2 DEFAULT '0' NOT NULL, auth_admin int2 DEFAULT '0' NOT NULL @@ -141,7 +141,7 @@ CREATE TABLE phpbb_config ( system_timezone int4 NOT NULL, sys_template varchar(50) NOT NULL, avatar_filesize int4 DEFAULT '6144' NOT NULL, - avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL, + avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL, override_themes int2 NOT NULL, flood_interval int NOT NULL, selected int2 NOT NULL, @@ -286,8 +286,8 @@ CREATE TABLE phpbb_session ( session_id char(32) DEFAULT '0' NOT NULL, session_user_id int4 DEFAULT '0' NOT NULL, session_start int4 DEFAULT '0' NOT NULL, - session_time int4 DEFAULT '0' NOT NULL, - session_last_visit int4 DEFAULT '0' NOT NULL, + session_time int4 DEFAULT '0' NOT NULL, + session_last_visit int4 DEFAULT '0' NOT NULL, session_ip char(8) DEFAULT '0' NOT NULL, session_page int4 DEFAULT '0' NOT NULL, session_logged_in int2 DEFAULT '0' NOT NULL, @@ -404,6 +404,7 @@ CREATE TABLE phpbb_topics ( topic_replies int4 DEFAULT '0' NOT NULL, forum_id int4 DEFAULT '0' NOT NULL, topic_status int2 DEFAULT '0' NOT NULL, + topic_type int2 DEFAULT '0' NOT NULL, topic_notify int2 DEFAULT '0', topic_last_post_id int4 DEFAULT '0' NOT NULL, CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_id) |