Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv19307/db/schemas
Modified Files:
ms_access_primer.zip mssql_basic.sql mssql_schema.sql
mysql_basic.sql mysql_schema.sql postgres_basic.sql
postgres_schema.sql
Log Message:
Associated schema changes
Index: ms_access_primer.zip
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/ms_access_primer.zip,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -r1.16 -r1.17
Binary files /tmp/cvsMsoO1u and /tmp/cvsEpF7vP differ
Index: mssql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_basic.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -r1.15 -r1.16
*** mssql_basic.sql 20 Apr 2002 00:22:28 -0000 1.15
--- mssql_basic.sql 20 Apr 2002 23:43:46 -0000 1.16
***************
*** 68,72 ****
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]');
/*
--- 68,72 ----
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 [20020421]');
/*
Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -r1.25 -r1.26
*** mssql_schema.sql 20 Apr 2002 00:22:28 -0000 1.25
--- mssql_schema.sql 20 Apr 2002 23:43:46 -0000 1.26
***************
*** 89,92 ****
--- 89,99 ----
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 ,
***************
*** 603,606 ****
--- 610,616 ----
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
Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_basic.sql,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -r1.16 -r1.17
*** mysql_basic.sql 20 Apr 2002 00:22:28 -0000 1.16
--- mysql_basic.sql 20 Apr 2002 23:43:46 -0000 1.17
***************
*** 61,65 ****
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]');
--- 61,65 ----
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 [20020421]');
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -r1.18 -r1.19
*** mysql_schema.sql 20 Apr 2002 00:22:28 -0000 1.18
--- mysql_schema.sql 20 Apr 2002 23:43:46 -0000 1.19
***************
*** 153,156 ****
--- 153,170 ----
# --------------------------------------------------------
#
+ # 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'
#
Index: postgres_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_basic.sql,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -r1.17 -r1.18
*** postgres_basic.sql 20 Apr 2002 00:22:28 -0000 1.17
--- postgres_basic.sql 20 Apr 2002 23:43:46 -0000 1.18
***************
*** 62,66 ****
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]');
-- Categories
--- 62,66 ----
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 [20020421]');
-- Categories
Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -r1.20 -r1.21
*** postgres_schema.sql 20 Apr 2002 00:22:28 -0000 1.20
--- postgres_schema.sql 20 Apr 2002 23:43:46 -0000 1.21
***************
*** 137,140 ****
--- 137,152 ----
/* --------------------------------------------------------
+ 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
-------------------------------------------------------- */
|