diff options
Diffstat (limited to 'phpBB/db/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 92be0f31ca..981cfb07a4 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -136,6 +136,18 @@ CREATE INDEX forum_last_post_id_phpbb_forums_index ON phpbb_forums (forum_last_ /* -------------------------------------------------------- + Table structure for table phpbb_forums_watch +-------------------------------------------------------- */ +CREATE TABLE phpbb_forums_watch ( + forum_id int4, + user_id int4, + notify_status int2 NOT NULL default '0' +); +CREATE INDEX forum_id_phpbb_forums_watch_index ON phpbb_forums_watch (forum_id); +CREATE INDEX user_id_phpbb_forums_watch_index ON phpbb_forums_watch (user_id); + + +/* -------------------------------------------------------- Table structure for table phpbb_forum_prune -------------------------------------------------------- */ CREATE TABLE phpbb_forum_prune ( |