[phpBT-dev] CVS: phpbt/schemas pgsql.in,1.36,1.37

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv15006/schemas

Modified Files:
	pgsql.in 
Log Message:
Fixed postgres sequence problem.

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.36
retrieving revision 1.37
diff -u -r1.36 -r1.37
--- pgsql.in	23 Sep 2002 20:09:09 -0000	1.36
+++ pgsql.in	5 Nov 2002 18:07:02 -0000	1.37
@@ -275,13 +275,13 @@
 	(user_id, login, first_name, last_name, email, password)
 	values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL',
 		'OPTION_ADMIN_PASS');
-CREATE SEQUENCE TBL_AUTH_USER_seq START 1;
+CREATE SEQUENCE TBL_AUTH_USER_seq START 2;
 
 -- Start off with three user levels...
 INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1);
 INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1);
 INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
-CREATE SEQUENCE TBL_AUTH_GROUP_seq START 3;
+CREATE SEQUENCE TBL_AUTH_GROUP_seq START 4;
 
 -- ... and only two permissions
 INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
@@ -360,7 +360,7 @@
 INSERT INTO TBL_OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
 INSERT INTO TBL_OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
 INSERT INTO TBL_OS VALUES (31,'other',31,'');
-CREATE SEQUENCE TBL_OS_seq START 31;
+CREATE SEQUENCE TBL_OS_seq START 32;
 
 INSERT INTO TBL_RESOLUTION VALUES (1,'Fixed','Bug was eliminated',1);
 INSERT INTO TBL_RESOLUTION VALUES (2,'Not a bug','It''s not a bug -- it''s a feature!',2);
@@ -368,7 +368,7 @@
 INSERT INTO TBL_RESOLUTION VALUES (4,'Deferred','We''ll get around to it later',4);
 INSERT INTO TBL_RESOLUTION VALUES (5,'Works for me','Can''t replicate the bug',5);
 INSERT INTO TBL_RESOLUTION VALUES (6,'Duplicate','',6);
-CREATE SEQUENCE TBL_RESOLUTION_seq START 6;
+CREATE SEQUENCE TBL_RESOLUTION_seq START 7;
 
 INSERT INTO TBL_SEVERITY VALUES (1,'Unassigned','Default bug creation',1,'#dadada');
 INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2,'#dad0d0');
@@ -377,7 +377,7 @@
 INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5,'#dababa');
 INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6,'#dab0b0');
 INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
-CREATE SEQUENCE TBL_SEVERITY_seq START 7;
+CREATE SEQUENCE TBL_SEVERITY_seq START 8;
 
 INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1);
 INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2);
@@ -386,19 +386,19 @@
 INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5);
 INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
 INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
-CREATE SEQUENCE TBL_STATUS_seq START 7;
+CREATE SEQUENCE TBL_STATUS_seq START 8;
 
 INSERT INTO TBL_DATABASE VALUES (1,'Oracle 8.1.7',1);
 INSERT INTO TBL_DATABASE VALUES (2,'MySQL 3.23.49',2);
 INSERT INTO TBL_DATABASE VALUES (3,'PostgreSQL 7.1.3',3);
-CREATE SEQUENCE TBL_DATABASE_seq START 3;
+CREATE SEQUENCE TBL_DATABASE_seq START 4;
 
 INSERT INTO TBL_SITE VALUES (0,'All',1);
 INSERT INTO TBL_SITE VALUES (1,'Production - location 1',2);
 INSERT INTO TBL_SITE VALUES (2,'Production - location 2',3);
 INSERT INTO TBL_SITE VALUES (3,'Test site - location 1',4);
 INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5);
-CREATE SEQUENCE TBL_SITE_seq START 4;
+CREATE SEQUENCE TBL_SITE_seq START 5;
 
 --
 -- Indexes for table TBL_GROUP_PERM