diff options
Diffstat (limited to 'phpBB/db/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index e9502a743a..486cc52ab0 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -419,6 +419,20 @@ CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id); /* -------------------------------------------------------- + Table structure for table phpbb_topics_watch +-------------------------------------------------------- */ +CREATE TABLE phpbb_topics_watch ( + topic_id int4, + user_id int4, + notify_status int2 NOT NULL default '0', + CONSTRAINT phpbb_topics_watch_pkey PRIMARY KEY (topic_id), + KEY user_id (user_id) +); +CREATE INDEX _phpbb_topics_watch_index ON phpbb_topics_watch (topic_id, user_id); +CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id); + + +/* -------------------------------------------------------- Table structure for table phpbb_user_group -------------------------------------------------------- */ CREATE TABLE phpbb_user_group ( |