[phpBT-dev] CVS: phpbt upgrade.php,1.38,1.39

[Ulf E. <ulf...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30944

Modified Files:
	upgrade.php 
Log Message:
Updated Oracle support.


Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.38
retrieving revision 1.39
diff -u -r1.38 -r1.39
--- upgrade.php	30 May 2005 19:32:27 -0000	1.38
+++ upgrade.php	30 May 2005 19:59:35 -0000	1.39
@@ -69,10 +69,21 @@
 				break;
 			case 'oci8' :
 				echo "Oracle is not supported in version 1.0";
+
+				echo "<p>An attempt to restore Oracle support has been made (by copy-paste-and-edit), but it is completely UNTESTED! Proceed At Your Own Risk...</p>";
+				echo "<p>Don't forget to report your success (or failure) story to <a href=\"mailto:php...@li...\">php...@li...</a> if you do proceed. We have interest in detailed error reports and patches from people who use Oracle.</p>";
 				exit;
+
 				$db->query("create table ".TBL_PROJECT_PERM." ( project_id number(10) default '0' NOT NULL, user_id number(10) default '0' NOT NULL )");
-				//! TBL_AUTH_GROUP
-				//! TBL_USER_PERM.def_results (see mysql)
+				if ($thisvers < 2) {
+					$db->query("alter table ".TBL_AUTH_GROUP." ADD (assignable number(1) default '0' NOT NULL)");
+				}
+				if ($thisvers < 3) {
+					$db->query("ALTER TABLE ".TBL_USER_PREF." ADD (def_results number(10) default '20' NOT NULL)");
+				}
+				if ($thisvers < 4) {
+					$db->query("ALTER TABLE ".TBL_STATUS." ADD (bug_open number(1) default '1' NOT NULL)");
+				}
 				break;
 		}