BUGFIX: Secondary indices on log_notification were unique.

[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 caea052..a83930a 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -15,7 +15,7 @@
      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
+       $dbms->query($local_sql); //DISABLED FOR NEW ROLE LOG-tABLE  ???
 
      case 2:
        //In the log table processed should be false by default
@@ -168,21 +168,21 @@
       $dbms->query($local_sql);
 
    case 18:
-      $local_sql = "UPDATE action SET actionname = 'Investigation completed', statuscode = 'PEN', description = 'Investigation has been done.' ";
+      $local_sql = "UPDATE action SET actionname = 'Investigation completed', statuscode = 'PEN', description = 'Investigation has been done. Information is available to fix the problem.' ";
       $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')";
+      $local_sql = "insert into type_of_issue (name, suggested_priority, description, active)";
+      $local_sql .= " values ('parameter created',3,'A new parameter was created', true)";
       $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')";
+      $local_sql = "insert into type_of_issue (name, suggested_priority, description, active)";
+      $local_sql .= " values ('property modified',3,'The STATIC property of a parameter was modified', true)";
       $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') ";
+      $local_sql = "insert into type_of_issue (name, suggested_priority, description, active)";
+      $local_sql .= " values ('parameter removed',3,'A parameter was removed', true) ";
       $dbms->query($local_sql);
 
  case 20:
@@ -360,7 +360,7 @@ case 37:
      $local_sql = "ALTER TABLE notification_check ADD COLUMN type_of_issueid BIGINT";
      $dbms->query($local_sql);
 
-     $local_sql = "ALTER TABLE notification_check ALTER COLUMN decreasinglist SET DEFAULT 'FALSE'";
+     $local_sql = "ALTER TABLE notification_check ALTER COLUMN decreasinglist SET DEFAULT false";
      $dbms->query($local_sql);
 
      $local_sql  = "CREATE SEQUENCE checklineid_seq";
@@ -376,10 +376,10 @@ case 37:
      $local_sql = "ALTER TABLE notification_check_line ALTER COLUMN historicboundary SET DEFAULT '0'";
      $dbms->query($local_sql);
      
-     $local_sql = "ALTER TABLE notification_check_line ALTER COLUMN use_logid        SET DEFAULT 'FALSE'";
+     $local_sql = "ALTER TABLE notification_check_line ALTER COLUMN use_logid        SET DEFAULT false";
      $dbms->query($local_sql);
      
-     $local_sql = "ALTER TABLE notification_check_line ALTER COLUMN last_logid       SET DEFAULT '0'";
+     $local_sql = "ALTER TABLE notification_check_line ALTER COLUMN last_logid       SET DEFAULT 0";
      $dbms->query($local_sql);
 
 case 38:
@@ -429,6 +429,63 @@ case 41:
      $local_sql = "CREATE INDEX history_pid_mod  ON history(paramid, modified)";
      $dbms->query($local_sql);
 
+case 42:
+
+     //  The secondary indices on log_notification should not be unique
+
+     $local_sql = "DROP INDEX lon_notificationid";
+     $dbms->query($local_sql);
+     $local_sql = "CREATE INDEX lon_notificationid ON log_notification USING btree (notificationid)";
+     $dbms->query($local_sql);
+
+     $local_sql = "DROP INDEX lon_logid";
+     $dbms->query($local_sql);
+     $local_sql = "CREATE INDEX lon_logid ON log_notification USING btree (logid)";
+     $dbms->query($local_sql);
+
+     //   Additional information for the users
+
+     $local_sql = "ALTER TABLE usr ADD COLUMN display_name text";
+     $dbms->query($local_sql);
+     $local_sql = "ALTER TABLE usr ADD COLUMN email text";
+     $dbms->query($local_sql);
+
+     //  Add issues for the services check
+
+     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
+     $local_sql .= " VALUES ('service unknown',5,'Service in log entry is unknown', true) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
+     $local_sql .= " VALUES ('service not used',5,'Service in log entry is not used', true) ";
+     $dbms->query($local_sql);
+
+     //  Add a few more services
+
+     $local_sql = "INSERT INTO service VALUES ('CROND','Cron Daemon', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('gnucomo','Gnucomo Daemon', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('sendmail','Mail Transport Agent', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('dhcpd','DHCP Daemon', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('rpc','NFS Services', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('named','DNS Services', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('xinetd','Internet Daemon', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('ipop','Post Office Protocol', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('mgetty','Serial port login and fax', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('login','User login', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('pam','Authentication modules', 1, 5) ";
+     $dbms->query($local_sql);
+     $local_sql = "INSERT INTO service VALUES ('modprobe','Kernel modules', 1, 5) ";
+     $dbms->query($local_sql);
+
 //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
 /*