|
From: Paul S. O. <ps...@us...> - 2002-02-11 13:11:39
|
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),
|