|
From: Benjamin C. <bc...@us...> - 2002-03-18 17:53:02
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv27598
Modified Files:
upgrade.php
Log Message:
Added some comments
Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- upgrade.php 18 Mar 2002 15:54:39 -0000 1.12
+++ upgrade.php 18 Mar 2002 17:52:56 -0000 1.13
@@ -28,6 +28,7 @@
function upgrade() {
global $db;
+ // Note, no upgrades for oracle since we didn't support oracle before 0.8.0
$upgraded = $db->getOne('select count(*) from '.TBL_BUG.'_seq');
if (!$upgraded or DB::isError($upgraded)) {
// Convert the sequences
@@ -37,10 +38,12 @@
}
$rs = $db->query("select * from ".TBL_DB_SEQUENCE);
if (DB_TYPE == 'pgsql') {
+ // Move the sequences
while ($rs->fetchInto($row)) {
$db->query("create sequence {$row['seq_name']}_seq start {$row['nextid']}");
}
} else {
+ // Move the sequences
while ($rs->fetchInto($row)) {
$db->query("create table {$row['seq_name']}_seq (id int unsigned auto_increment not null primary key)");
$db->query("insert into {$row['seq_name']}_seq values ({$row['nextid']})");
|