[Phpbb-checkins] CVS: phpBB2/db/schemas ms_access_primer.zip,1.11,1.12 mssql_schema.sql,1.20,1.21 mysql_schema.sql,1.15,1.16 postgres_schema.sql,1.17,1.18

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv5279/db/schemas

Modified Files:
	ms_access_primer.zip mssql_schema.sql mysql_schema.sql 
	postgres_schema.sql 
Log Message:
Remove auto increment/IDENTITY/autonumber/sequence from forum_id in _forums, this is set by the admin_forums app itself.

Index: ms_access_primer.zip
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/ms_access_primer.zip,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
Binary files /tmp/cvsMi0Fvf and /tmp/cvs65dNEm differ

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -r1.20 -r1.21
*** mssql_schema.sql	11 Feb 2002 00:08:14 -0000	1.20
--- mssql_schema.sql	11 Feb 2002 13:11:36 -0000	1.21
***************
*** 64,68 ****
  
  CREATE TABLE [phpbb_forums] (
! 	[forum_id] [int] IDENTITY (1, 1) NOT NULL ,
  	[cat_id] [int] NOT NULL ,
  	[forum_name] [varchar] (100) NOT NULL ,
--- 64,68 ----
  
  CREATE TABLE [phpbb_forums] (
! 	[forum_id] [int] NOT NULL ,
  	[cat_id] [int] NOT NULL ,
  	[forum_name] [varchar] (100) NOT NULL ,

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -r1.15 -r1.16
*** mysql_schema.sql	2 Feb 2002 18:10:53 -0000	1.15
--- mysql_schema.sql	11 Feb 2002 13:11:36 -0000	1.16
***************
*** 122,126 ****
  #
  CREATE TABLE phpbb_forums (
!    forum_id smallint(5) UNSIGNED NOT NULL auto_increment,
     cat_id mediumint(8) UNSIGNED NOT NULL,
     forum_name varchar(150),
--- 122,126 ----
  #
  CREATE TABLE phpbb_forums (
!    forum_id smallint(5) UNSIGNED NOT NULL,
     cat_id mediumint(8) UNSIGNED NOT NULL,
     forum_name varchar(150),

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -r1.17 -r1.18
*** postgres_schema.sql	2 Feb 2002 18:10:53 -0000	1.17
--- postgres_schema.sql	11 Feb 2002 13:11:36 -0000	1.18
***************
*** 9,13 ****
  CREATE SEQUENCE phpbb_categories_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  CREATE SEQUENCE phpbb_disallow_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
- CREATE SEQUENCE phpbb_forums_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  CREATE SEQUENCE phpbb_posts_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  CREATE SEQUENCE phpbb_privmsgs_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
--- 9,12 ----
***************
*** 107,111 ****
  -------------------------------------------------------- */
  CREATE TABLE phpbb_forums (
!    forum_id int4 DEFAULT nextval('phpbb_forums_id_seq'::text) NOT NULL,
     cat_id int4,
     forum_name varchar(150),
--- 106,110 ----
  -------------------------------------------------------- */
  CREATE TABLE phpbb_forums (
!    forum_id int4 DEFAULT '0' NOT NULL,
     cat_id int4,
     forum_name varchar(150),