[phpBT-dev] CVS: phpbt upgrade.php,1.27,1.28

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

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

Modified Files:
	upgrade.php 
Log Message:
Fixed postgres sequence problem.

Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.27
retrieving revision 1.28
diff -u -r1.27 -r1.28
--- upgrade.php	19 Oct 2002 19:02:10 -0000	1.27
+++ upgrade.php	5 Nov 2002 18:07:03 -0000	1.28
@@ -55,12 +55,12 @@
 				$db->query("INSERT INTO ".TBL_SITE." VALUES (2,'Testing',3)");
 				$db->query("INSERT INTO ".TBL_SITE." VALUES (3,'Staging',4)");
 				$db->query("INSERT INTO ".TBL_SITE." VALUES (4,'Production',5)");
-				$db->query("CREATE SEQUENCE ".TBL_SITE."_seq START 4");
+				$db->query("CREATE SEQUENCE ".TBL_SITE."_seq START 5");
 				$db->query("create table ".TBL_DATABASE." ( database_id INT2 NOT NULL DEFAULT '0', database_name varchar(40) NOT NULL DEFAULT '', sort_order INT2 NOT NULL DEFAULT '0', PRIMARY KEY (database_id) )");
 				$db->query("INSERT INTO ".TBL_DATABASE." VALUES (1,'Oracle 8.1.7',1)");
 				$db->query("INSERT INTO ".TBL_DATABASE." VALUES (2,'MySQL 3.23.49',2)");
 				$db->query("INSERT INTO ".TBL_DATABASE." VALUES (3,'PostgreSQL 7.1.3',3)");
-				$db->query("CREATE SEQUENCE ".TBL_DATABASE."_seq START 3");
+				$db->query("CREATE SEQUENCE ".TBL_DATABASE."_seq START 4");
 				break;
 			case 'mysql' :
 				$db->query("alter table ".TBL_USER_PREF." add saved_queries tinyint(1) not null default '1' after email_notices");