Make an extra index on the log_abuse 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 c927b0b..d84a3e5 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -14,8 +14,8 @@
    {
      case 1:
        //DROP the rule that prohibits updates (change of spec).
-       //$local_sql = "DROP RULE log_update";
-       //$dbms->query($local_sql); //DISABLED FOR NEW ROLE LOG-tABLE  ???
+       $local_sql = "DROP RULE log_update ON log";
+       $dbms->query($local_sql); //DISABLED FOR NEW ROLE LOG-tABLE  ???
 
      case 2:
        //In the log table processed should be false by default
@@ -632,20 +632,54 @@ case 43:
      $dbms->query("DROP TABLE log_adv_daemon");
      $dbms->query("DROP TABLE log_adv");
 
-//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
-/*
-TODO:
+   case 51:
+
+     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
+     $local_sql .= " VALUES ('property out of range',5,'The DYNAMIC property of a parameter is out of range', true) ";
+     $dbms->query($local_sql);
+
+     $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
+     $local_sql .= " VALUES ('filesystem', 'device', 'Volume on which the filesystem resides', 'STATIC', 't')";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
+     $local_sql .= " VALUES ('filesystem', 'size', 'Total size in kilobytes', 'STATIC', 't')";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+     $local_sql .= " VALUES ('filesystem', 'used', 'Number of kilobytes used', 'DYNAMIC', 0, 1000000, 't')";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+     $local_sql .= " VALUES ('filesystem', 'available', 'Number of kilobytes available', 'DYNAMIC', 1000, 1000000, 't')";
+     $dbms->query($local_sql);
 
-GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin;
+   case 52:
 
+     $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
+     $local_sql .= " VALUES ('filesystem', 'Inodes', 'Total number of i-nodes', 'STATIC', 't')";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+     $local_sql .= " VALUES ('filesystem', 'Iused', 'Number of i-nodes used', 'DYNAMIC', 0, 1000000, 't')";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+     $local_sql .= " VALUES ('filesystem', 'Ifree', 'Number of i-nodes available', 'DYNAMIC', 1000, 1000000, 't')";
+     $dbms->query($local_sql);
+
+   case 53:
+
+     $dbms->query("GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin");
+
+     $dbms->query("GRANT INSERT ON property TO GROUP admin");
+     $dbms->query("GRANT UPDATE ON property TO GROUP admin");
+     $dbms->query("CREATE INDEX log_ab_src ON log_abuse (source, objectid)");
+
+/*
+TODO:
 */
+//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);
 */
 
    }