Configuration from current directory

[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 d84a3e5..a172a44 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -83,9 +83,6 @@
        $dbms->query($local_sql);
       
     case 9:
-       $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN window TEXT";
-       $dbms->query($local_sql);
- 
        $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN urgp INT";
        $dbms->query($local_sql);
 
@@ -665,11 +662,45 @@ case 43:
 
    case 53:
 
+     $dbms->query("CREATE GROUP daemon");
+     $dbms->query("CREATE ROLE gnucomo LOGIN PASSWORD 'gnucomo' IN GROUP daemon");
+
      $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)");
+     $dbms->query("CREATE UNIQUE INDEX log_ab_log ON log_abuse (logid)");
+     $dbms->query("GRANT INSERT ON action_user TO GROUP daemon");
+     $dbms->query("GRANT DELETE ON action_user TO GROUP daemon");
+     $dbms->query("GRANT INSERT ON log_abuse TO GROUP daemon");
+     $dbms->query("GRANT DELETE ON log_abuse TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON log_abuse TO GROUP daemon");
+     $dbms->query("GRANT INSERT ON log_notification TO GROUP daemon");
+     $dbms->query("GRANT DELETE ON log_notification TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON log_notification TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT,DELETE ON log TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT,DELETE ON notification TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT,DELETE,UPDATE ON parameter_class TO GROUP admin");
+     $dbms->query("GRANT SELECT,INSERT ON parameter TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT ON parameter_notification TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT ON history TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT,UPDATE ON object_abuse TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT,UPDATE ON object_statistics TO GROUP daemon");
+     $dbms->query("GRANT SELECT,INSERT,UPDATE ON property TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON object_service TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON object_user TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON parameter_class TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON service_pattern TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON service TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON type_of_issue TO GROUP daemon");
+     $dbms->query("GRANT SELECT ON usr TO GROUP daemon");
+     $dbms->query("GRANT SELECT,UPDATE ON notification_notificationid_seq TO GROUP daemon");
+     $dbms->query("GRANT SELECT,UPDATE ON db_value TO GROUP daemon");
+     $dbms->query("GRANT SELECT,UPDATE ON object TO GROUP daemon");
+     $dbms->query("GRANT UPDATE ON SEQUENCE action_user_actionstepid_seq TO daemon");
+     $dbms->query("GRANT UPDATE ON SEQUENCE log_logid_seq TO daemon");
+     $dbms->query("GRANT UPDATE ON SEQUENCE paramid_seq TO daemon");
 
 /*
 TODO: