Added new records to the 'type_of_issue' 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 2346e96..22385b4 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -14,12 +14,12 @@
      case 1:
        //DROP the rule that prohibits updates (change of spec).
        $local_sql = "DROP RULE log_update";
-       $dbms->query($local_sql);
+//       $dbms->query($local_sql); DISABLED FOR NEW ROLE LOG-tABLE
 
      case 2:
        //In the log table processed should be false by default
        $local_sql = "UPDATE log SET processed = false";
-       $dbms->query($local_sql);
+       $dbms->query($local_sql); 
 
      case 3:
        //In the log_adv a column is added that indicates where the detailed
@@ -106,6 +106,7 @@
        $dbms->query($local_sql);
 
     case 11:
+       //Recognize some more kernel_network fields
        $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN res varchar(5)";
        $dbms->query($local_sql);
 
@@ -116,13 +117,86 @@
        $dbms->query($local_sql);
 
    case 12:
+      //Add the gcm_daemon_version to the system
       $local_sql = "INSERT INTO db_value VALUES ('gcm_daemon_version', '1')";
       $dbms->query($local_sql);        
+
+   case 13:
+      //Create the table object_system_user
+      $local_sql = "CREATE TABLE object_system_user (objectid BIGINT, system_username TEXT, can_login BOOLEAN, can_be_root BOOLEAN)";
+      $dbms->query($local_sql);
+
+      $local_sql = "CREATE UNIQUE INDEX obsyus_id_name ON object_system_user (objectid, system_username)";
+      $dbms->query($local_sql);
+
+     
+      $local_sql = "CREATE INDEX obsyus_id ON object_system_user (objectid)";
+      $dbms->query($local_sql);
+
+
+      $local_sql = "CREATE INDEX obsyus_name ON object_system_user (system_username)";
+      $dbms->query($local_sql);
+
+   case 14:
+      //Make type_of_issue ready for automatic detection
+      $local_sql = "ALTER TABLE type_of_issue ADD COLUMN automated_check BOOLEAN";
+      $dbms->query($local_sql);
+
+      $local_sql = "ALTER TABLE type_of_issue ADD COLUMN alert_level INT";
+      $dbms->query($local_sql);
+
+      $local_sql = "ALTER TABLE type_of_issue ADD COLUMN last_run TIMESTAMP";
+      $dbms->query($local_sql);
+
+      $local_sql = "ALTER TABLE type_of_issue ADD COLUMN recheck_interval TIMESTAMP";
+      $dbms->query($local_sql);
+
+    case 15:
+      $local_sql = "INSERT INTO db_value (setting, setting_value) VALUES ('log_processing', '0')";
+      $dbms->query($local_sql);
+
+   case 16:
+      $local_sql = "ALTER TABLE log_adv_kernel_network DROP COLUMN hw_address";
+      $dbms->query($local_sql);
+      
+
+      $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN hw_address TEXT";
+      $dbms->query($local_sql);
+   case 17:
+      $local_sql = "DROP TABLE object_system_user";
+      $dbms->query($local_sql);
+
+   case 18:
+      $local_sql = "UPDATE action SET actionname = 'Investigation completed', statuscode = 'PEN', description = 'Investigation has been done.' ";
+      $local_sql .= "WHERE actionid = '9'";
+      $dbms->query($local_sql);
+
+   case 19:
+      $local_sql = "insert into type_of_issue (name, suggested_priority, description)";
+      $local_sql .= " values ('parameter created',3,'A new parameter was created')";
+      $dbms->query($local_sql);
+
+      $local_sql = "insert into type_of_issue (name, suggested_priority, description)";
+      $local_sql .= " values ('property modified',3,'The STATIC property of a parameter was modified')";
+      $dbms->query($local_sql);
+
+      $local_sql = "insert into type_of_issue (name, suggested_priority, description)";
+      $local_sql .= " values ('parameter removed',3,'A parameter was removed') ";
+      $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";
+     $dbms->query($local_sql);
+
+     $local_sql = "ALTER TABLE logng DROP COLUMN recognized";
+     $dbms->query($local_sql);
+*/
    }
 
-   $active_version++;
-   $local_sql = "UPDATE db_value SET setting_value = ".$active_version." WHERE setting = 'db_version'";
-   $dbms->query($local_sql);
+   $local_sql = "UPDATE db_value SET setting_value = ".$db_version." WHERE setting = 'db_version'";
 
+   $dbms->query($local_sql);
+   
 
 ?>