[phpBT-dev] CVS: phpbt upgrade.php,1.24,1.25

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

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

Modified Files:
	upgrade.php 
Log Message:
Added bug_closed configuration option.  Starting on postgres database changes.

Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.24
retrieving revision 1.25
diff -u -r1.24 -r1.25
--- upgrade.php	14 Sep 2002 19:03:48 -0000	1.24
+++ upgrade.php	23 Sep 2002 20:10:05 -0000	1.25
@@ -38,6 +38,9 @@
 		}
 		switch(DB_TYPE) {
 			case 'pgsql' :
+				$db->query("alter table ".TBL_USER_PREF." add saved_queries int2");
+				$db->query("alter table ".TBL_USER_PREF." alter saved_queries set default 1");
+				$db->query("update ".TBL_USER_PREF." set saved_queries = 1");
 				break;
 			case 'mysql' :
 				$db->query("alter table ".TBL_USER_PREF." add saved_queries tinyint(1) not null default '1' after email_notices");
@@ -59,6 +62,7 @@
 		$db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('BUG_PROMOTED', '2', 'The status to assign a bug when it is promoted (if enabled).', 'multi')");
 		$db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('BUG_ASSIGNED', '3', 'The status to assign a bug when it is assigned.', 'multi')");
 		$db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('BUG_REOPENED', '4', 'The status to assign a bug when it is reopened.', 'multi')");
+		$db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('BUG_CLOSED', '7', 'The status to assign a bug when it is closed.', 'multi')");
 		$db->query("INSERT INTO ".TBL_SITE." VALUES (0,'All',1), (1,'Development',2), (2,'Testing',3), (3,'Staging',4), (4,'Production',5)");
 		$db->query("INSERT INTO ".TBL_DATABASE." VALUES (1,'Oracle 8.1.7',1), (2,'MySQL 3.23.49',2), (3,'PostgreSQL 7.1.3',3");
 	}