diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-08-14 00:29:39 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-08-14 00:29:39 +0000 |
| commit | a34d5d2abb30ec692038f2875b78443507c70131 (patch) | |
| tree | 60b89db8e25266cb4c9d99c1da3c0768b3473bf7 /phpBB/db | |
| parent | 538b793e653a4e584b73200da54defe715c7c53a (diff) | |
| download | forums-a34d5d2abb30ec692038f2875b78443507c70131.tar forums-a34d5d2abb30ec692038f2875b78443507c70131.tar.gz forums-a34d5d2abb30ec692038f2875b78443507c70131.tar.bz2 forums-a34d5d2abb30ec692038f2875b78443507c70131.tar.xz forums-a34d5d2abb30ec692038f2875b78443507c70131.zip | |
Topic notification ... initial stuff
git-svn-id: file:///svn/phpbb/trunk@862 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 14 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 14 |
2 files changed, 28 insertions, 0 deletions
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 @@ -425,6 +425,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' # DROP TABLE IF EXISTS 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 @@ -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 ( |