aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-04-20 23:43:46 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-04-20 23:43:46 +0000
commit9649ececed8a283ff3c63c2db4f9a0ccc5d9763c (patch)
tree95451f6b5e4c4e78d07487ae94b52eed13e0e13e /phpBB
parentfa3d0694a8ecdd6c4cfc59fa34d270ea50d22fb2 (diff)
downloadforums-9649ececed8a283ff3c63c2db4f9a0ccc5d9763c.tar
forums-9649ececed8a283ff3c63c2db4f9a0ccc5d9763c.tar.gz
forums-9649ececed8a283ff3c63c2db4f9a0ccc5d9763c.tar.bz2
forums-9649ececed8a283ff3c63c2db4f9a0ccc5d9763c.tar.xz
forums-9649ececed8a283ff3c63c2db4f9a0ccc5d9763c.zip
Associated schema changes
git-svn-id: file:///svn/phpbb/trunk@2537 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
-rw-r--r--phpBB/db/schemas/ms_access_primer.zipbin51985 -> 58105 bytes
-rw-r--r--phpBB/db/schemas/mssql_basic.sql2
-rw-r--r--phpBB/db/schemas/mssql_schema.sql10
-rw-r--r--phpBB/db/schemas/mysql_basic.sql2
-rw-r--r--phpBB/db/schemas/mysql_schema.sql14
-rw-r--r--phpBB/db/schemas/postgres_basic.sql2
-rw-r--r--phpBB/db/schemas/postgres_schema.sql12
7 files changed, 39 insertions, 3 deletions
diff --git a/phpBB/db/schemas/ms_access_primer.zip b/phpBB/db/schemas/ms_access_primer.zip
index 047823591c..d22c6f5bde 100644
--- a/phpBB/db/schemas/ms_access_primer.zip
+++ b/phpBB/db/schemas/ms_access_primer.zip
Binary files 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
@@ -152,6 +152,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'
#
CREATE 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
@@ -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 (
generated by cgit v1.2.1 (git 2.21.0) at 2025-03-19 09:23:46 +0000