touchup database structure

[diogenes.git] / config / updatedb.php

diff --git a/config/updatedb.php b/config/updatedb.php
index 3012f23..56c4803 100755 (executable)
--- a/config/updatedb.php
+++ b/config/updatedb.php
@@ -13,7 +13,7 @@ require_once("diogenes/diogenes.database-creator.inc.php");
 class DiogenesDbInit extends DiogenesDatabaseCreator
 {
   /** database versions history */
-  var $versions = array("0.9.9.3", "0.9.10", "0.9.12", "0.9.15", "0.9.16", "0.9.16+0.9.17pre15", "0.9.16+0.9.17pre19", "0.9.16+0.9.17pre21");
+  var $versions = array("0.9.9.3", "0.9.10", "0.9.12", "0.9.15", "0.9.16", "0.9.16+0.9.17pre15", "0.9.16+0.9.17pre19", "0.9.16+0.9.17pre21", "0.9.20");
 
   /**
    * Upgrades the database from one version to the next
@@ -38,6 +38,7 @@ class DiogenesDbInit extends DiogenesDatabaseCreator
     // upgrade master tables
     $this->info("* Upgrading master tables : diogenes_*");
     $this->upgradeMaster($newversion);
+    exit(1);
   }
 
   
@@ -213,6 +214,15 @@ class DiogenesDbInit extends DiogenesDatabaseCreator
       $this->dbh->query("INSERT INTO diogenes_logactions VALUES (16, 'page_plugins', 'the page plugins were modified');");
       break;
 
+    case "0.9.20":
+      $this->info(" - adding 'status' field to 'diogenes_plugin' table");
+      $this->dbh->query("ALTER TABLE `diogenes_plugin` ADD `status` INT( 1 ) UNSIGNED NOT NULL default '0'");
+      $this->dbh->query("update diogenes_plugin set status=0 where page=0");
+      $this->dbh->query("update diogenes_plugin set status=1 where page!=0");
+      $this->info(" - removing 'pos' field to 'diogenes_plugin' table");
+      $this->dbh->query("ALTER TABLE `diogenes_plugin` DROP `pos`");
+      break;
+    
     default:
       $this->info(" - no changes needed.");
       break;