|
From: Benjamin C. <bc...@us...> - 2002-11-05 18:07:06
|
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 |