Log_adv and derived tables removed.

[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 9ce5cfb..c927b0b 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -612,9 +612,34 @@ case 43:
      $local_sql .= " VALUES ('Warning detected',3,'A Warning is reported in the log', true) ";
      $dbms->query($local_sql);
 
+   case 48:
+
+     $dbms->query("GRANT SELECT ON service_pattern TO GROUP view, GROUP ops, GROUP admin");
+     $dbms->query("GRANT INSERT ON service_pattern TO GROUP admin");
+     $dbms->query("GRANT UPDATE ON service_pattern TO GROUP ops, GROUP admin");
+     $dbms->query("GRANT DELETE ON service_pattern TO GROUP admin");
+     $dbms->query("GRANT SELECT ON log_abuse TO GROUP view, GROUP ops, GROUP admin");
+
+   case 49:
+     $local_sql = "ALTER TABLE object_abuse ADD COLUMN  last_change   timestamp";
+     $dbms->query($local_sql);
+
+   case 50:
+
+     $dbms->query("DROP SEQUENCE log_advid_seq");
+     $dbms->query("DROP TABLE log_adv_kernel_network");
+     $dbms->query("DROP TABLE log_adv_daemon_email");
+     $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:
+
+GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin;
+
+*/
+/*
                          
      $local_sql = "ALTER TABLE log DROP COLUMN recognized";
      $dbms->query($local_sql);