[phpBT-dev] CVS: phpbt CHANGELOG,1.60,1.60.2.1 upgrade.php,1.27.2.1,1.27.2.2

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

Update of /cvsroot/phpbt/phpbt
In directory sc8-pr-cvs1:/tmp/cvs-serv32729

Modified Files:
      Tag: phpbt-0_9_0
	CHANGELOG upgrade.php 
Log Message:


Index: CHANGELOG
===================================================================
RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v
retrieving revision 1.60
retrieving revision 1.60.2.1
diff -u -r1.60 -r1.60.2.1
--- CHANGELOG	2 Oct 2002 18:45:49 -0000	1.60
+++ CHANGELOG	4 Jan 2003 19:17:32 -0000	1.60.2.1
@@ -1,4 +1,7 @@
--- 0.9.0 --
+-- 0.9.1 --
+: Fixed bugs with PostgreSQL
+
+-- 0.9.0 -- 25 Oct 2002
 : Replaced the mail function with one that encodes (i18n support).
 : Added four additional fields for tracking bug information: Database type
   and version, Environment, Closed Version, To-be-closed Version.

Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.27.2.1
retrieving revision 1.27.2.2
diff -u -r1.27.2.1 -r1.27.2.2
--- upgrade.php	5 Nov 2002 18:05:16 -0000	1.27.2.1
+++ upgrade.php	4 Jan 2003 19:17:32 -0000	1.27.2.2
@@ -49,6 +49,7 @@
 				$db->query("alter table ".TBL_BUG." add site_id int4");
 				$db->query("alter table ".TBL_BUG." add closed_in_version_id int4");
 				$db->query("alter table ".TBL_BUG." add to_be_closed_in_version_id int4");
+				$db->query("update ".TBL_BUG." set database_id = 0, site_id = 0, closed_in_version_id = 0, to_be_closed_in_version_id = 0");
 				$db->query("create table ".TBL_SITE." ( site_id INT2 NOT NULL DEFAULT '0', site_name varchar(50) NOT NULL DEFAULT '', sort_order INT2 NOT NULL DEFAULT '0', PRIMARY KEY (site_id) )");
 				$db->query("INSERT INTO ".TBL_SITE." VALUES (0,'All',1)");
 				$db->query("INSERT INTO ".TBL_SITE." VALUES (1,'Development',2)");