From 9649ececed8a283ff3c63c2db4f9a0ccc5d9763c Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Sat, 20 Apr 2002 23:43:46 +0000 Subject: Associated schema changes git-svn-id: file:///svn/phpbb/trunk@2537 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/schemas/ms_access_primer.zip | Bin 51985 -> 58105 bytes phpBB/db/schemas/mssql_basic.sql | 2 +- phpBB/db/schemas/mssql_schema.sql | 10 ++++++++++ phpBB/db/schemas/mysql_basic.sql | 2 +- phpBB/db/schemas/mysql_schema.sql | 14 ++++++++++++++ phpBB/db/schemas/postgres_basic.sql | 2 +- phpBB/db/schemas/postgres_schema.sql | 12 ++++++++++++ 7 files changed, 39 insertions(+), 3 deletions(-) (limited to 'phpBB') diff --git a/phpBB/db/schemas/ms_access_primer.zip b/phpBB/db/schemas/ms_access_primer.zip index 047823591c..d22c6f5bde 100644 Binary files a/phpBB/db/schemas/ms_access_primer.zip and b/phpBB/db/schemas/ms_access_primer.zip differ diff --git a/phpBB/db/schemas/mssql_basic.sql b/phpBB/db/schemas/mssql_basic.sql index 5a1a444275..efc3032ca1 100644 --- a/phpBB/db/schemas/mssql_basic.sql +++ b/phpBB/db/schemas/mssql_basic.sql @@ -67,7 +67,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_user INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020420]'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020421]'); /* -- Categories diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index ac95defdd6..4e3c5ccb75 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -88,6 +88,13 @@ CREATE TABLE [phpbb_forums] ( ) ON [PRIMARY] GO +CREATE TABLE [phpbb_forums_watch] ( + [forum_id] [int] NOT NULL , + [user_id] [int] NOT NULL , + [notify_status] [smallint] NOT NULL +) ON [PRIMARY] +GO + CREATE TABLE [phpbb_groups] ( [group_id] [int] NOT NULL , [group_type] [smallint] NULL , @@ -604,6 +611,9 @@ GO CREATE INDEX [IX_phpbb_forums] ON [phpbb_forums]([cat_id], [forum_order], [forum_last_post_id]) ON [PRIMARY] GO + CREATE INDEX [IX_phpbb_forums_watch] ON [phpbb_forums_watch]([forum_id], [user_id]) ON [PRIMARY] +GO + CREATE INDEX [IX_phpbb_groups] ON [phpbb_groups]([group_single_user]) ON [PRIMARY] GO diff --git a/phpBB/db/schemas/mysql_basic.sql b/phpBB/db/schemas/mysql_basic.sql index 4c77db59ef..bb3696b92d 100644 --- a/phpBB/db/schemas/mysql_basic.sql +++ b/phpBB/db/schemas/mysql_basic.sql @@ -60,7 +60,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020420]'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020421]'); # -- Categories diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 02459360d4..33bb2e84a8 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -150,6 +150,20 @@ CREATE TABLE phpbb_forums ( ); +# -------------------------------------------------------- +# +# Table structure for table 'phpbb_forums_watch' +# +CREATE TABLE phpbb_forums_watch ( + forum_id smallint(5) UNSIGNED NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + notify_status tinyint(1) NOT NULL default '0', + KEY forum_id (forum_id), + KEY user_id (user_id), + KEY notify_status (notify_status) +); + + # -------------------------------------------------------- # # Table structure for table 'phpbb_posts' diff --git a/phpBB/db/schemas/postgres_basic.sql b/phpBB/db/schemas/postgres_basic.sql index 884b7f6b96..6f820ebb08 100644 --- a/phpBB/db/schemas/postgres_basic.sql +++ b/phpBB/db/schemas/postgres_basic.sql @@ -61,7 +61,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020420]'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020421]'); -- Categories INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 10); 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 @@ -135,6 +135,18 @@ CREATE INDEX forums_order_phpbb_forums_index ON phpbb_forums (forum_order); CREATE INDEX forum_last_post_id_phpbb_forums_index ON phpbb_forums (forum_last_post_id); +/* -------------------------------------------------------- + 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 -------------------------------------------------------- */ -- cgit v1.2.1