Added log, notification and parameter counters to the 'object' table.

[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 08f386f..dccdfef 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -213,9 +213,30 @@
  case 23:
       $local_sql = "CREATE INDEX log_adv_daemon_service ON log_adv_daemon (service)";
       $dbms->query($local_sql);
+ 
+ case 24: 
+       $local_sql = "ALTER TABLE object ADD COLUMN log_count BIGINT";
+       $dbms->query($local_sql);
 
+       $local_sql = "ALTER TABLE object ADD COLUMN notification_count BIGINT";
+       $dbms->query($local_sql);
 
+       $local_sql = "ALTER TABLE object ADD COLUMN parameter_count BIGINT";
+       $dbms->query($local_sql);
+case 25:
+       $local_sql = "UPDATE object SET log_count = '0', "
+        . "notification_count = '0', " 
+       . "parameter_count = '0' ";
+       $dbms->query($local_sql);
 
+case 26:
+       $local_sql = "UPDATE type_of_issue SET name = TRIM(name)";
+       $dbms->query($local_sql);
+
+case 27: 
+       $local_sql = "INSERT INTO db_value VALUES ('last_notification', '0')";
+       $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";
@@ -224,6 +245,7 @@
      $local_sql = "ALTER TABLE logng DROP COLUMN recognized";
      $dbms->query($local_sql);
 */
+
    }
 
    $local_sql = "UPDATE db_value SET setting_value = ".$db_version." WHERE setting = 'db_version'";