Bug fix: action.statuscode was in upper case.

[gnucomo.git] / src / gcm_daemon / classes / gnucomo_db_version.php

diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index ccd3703..3eb32c9 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -10,7 +10,8 @@
  //Do while statement since all updateshave to be executed starting at the 
  //latest version. It's a walk through.
 
-   switch ($active_version) {
+   switch ($active_version)
+   {
      case 1:
        //DROP the rule that prohibits updates (change of spec).
        $local_sql = "DROP RULE log_update";
@@ -197,6 +198,10 @@
       $dbms->query($local_sql);
 
 
+  case 21:
+      $local_sql = "UPDATE action SET statuscode = LOWER(statuscode)";
+      $dbms->query($local_sql);
+
 /*    
      //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
      $local_sql = "ALTER TABLE log DROP COLUMN recognized";
@@ -210,6 +215,6 @@
    $local_sql = "UPDATE db_value SET setting_value = ".$db_version." WHERE setting = 'db_version'";
 
    $dbms->query($local_sql);
-   
+
 
 ?>