[phpBT-dev] CVS: phpbt upgrade.php,1.42,1.43

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

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

Modified Files:
	upgrade.php 
Log Message:
Upgrade for Postgres and Oracle


Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -r1.42 -r1.43
--- upgrade.php	29 Aug 2005 19:09:40 -0000	1.42
+++ upgrade.php	31 Aug 2005 20:11:06 -0000	1.43
@@ -121,6 +121,16 @@
 					log_query("ALTER TABLE ".TBL_STATUS." alter bug_open set NOT NULL");
 				}
 				if ($thisvers < 5) {
+					log_query("create table ".TBL_PRIORITY."( priority_id INT4  NOT NULL DEFAULT '0', priority_name varchar(30) NOT NULL DEFAULT '', priority_desc TEXT DEFAULT '' NOT NULL, sort_order INT2  NOT NULL DEFAULT '0', priority_color varchar(10) NOT NULL DEFAULT '#FFFFFF', PRIMARY KEY  (priority_id) )");
+					log_query("create table ".TBL_BOOKMARK."( user_id INT4  NOT NULL DEFAULT '0', bug_id INT4  NOT NULL DEFAULT '0' )");
+
+					log_query('ALTER TABLE '.TBL_COMPONENT.' ADD sort_order INT2');
+					log_query("ALTER TABLE ".TBL_COMPONENT." alter sort_order set DEFAULT 0");
+					log_query("ALTER TABLE ".TBL_COMPONENT." alter sort_order set NOT NULL");
+					log_query('ALTER TABLE '.TBL_VERSION.' ADD sort_order INT2');
+					log_query("ALTER TABLE ".TBL_VERSION." alter sort_order set DEFAULT 0");
+					log_query("ALTER TABLE ".TBL_VERSION." alter sort_order set NOT NULL");
+					log_query("CREATE SEQUENCE ".TBL_PRIORITY."_seq START 6");
 				}
 				break;
 			case 'mysqli' :
@@ -165,6 +175,11 @@
 					log_query("ALTER TABLE ".TBL_STATUS." ADD (bug_open number(1) default '1' NOT NULL)");
 				}
 				if ($thisvers < 5) {
+					log_query("create table ".TBL_PRIORITY." ( priority_id number(3)   default '0' NOT NULL, priority_name varchar2(30)  default '' NOT NULL, priority_desc varchar2(4000) NOT NULL, sort_order number(3)   default '0' NOT NULL, priority_color varchar2(10)  default '#FFFFFF' NOT NULL, PRIMARY KEY  (priority_id) )");
+					log_query("create table ".TBL_BOOKMARK." ( user_id number(10) default '0' NOT NULL, bug_id number(10) default '0' NOT NULL )");
+					log_query("ALTER TABLE ".TBL_COMPONENT." ADD ( sort_order number(3) default '0' NOT NULL )");
+					log_query("ALTER TABLE ".TBL_VERSION." ADD ( sort_order number(3) default '0' NOT NULL )");
+					log_query("CREATE SEQUENCE ".TBL_PRIORITY."_seq START WITH 6 NOCACHE");
 				}
 				break;
 		}