From a34d5d2abb30ec692038f2875b78443507c70131 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Tue, 14 Aug 2001 00:29:39 +0000 Subject: Topic notification ... initial stuff git-svn-id: file:///svn/phpbb/trunk@862 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mysql_schema.sql | 14 ++++++++++++++ phpBB/db/postgres_schema.sql | 14 ++++++++++++++ 2 files changed, 28 insertions(+) (limited to 'phpBB/db') diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index f59e5200af..ec1cb6107b 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -423,6 +423,20 @@ CREATE TABLE phpbb_topics ( ); +# -------------------------------------------------------- +# +# Table structure for table 'phpbb_topics_watch' +# +DROP TABLE IF EXISTS phpbb_topics_watch; +CREATE TABLE phpbb_topics_watch ( + topic_id int(11), + user_id int(11), + notify_status tinyint(1) NOT NULL default '0', + PRIMARY KEY (topic_id), + KEY user_id (user_id) +); + + # -------------------------------------------------------- # # Table structure for table 'phpbb_users' 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 @@ -418,6 +418,20 @@ CREATE INDEX _phpbb_topics_index ON phpbb_topics (forum_id, topic_id); 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 -------------------------------------------------------- */ -- cgit v1.2.1