<?PHP

/* This 'function' updates the gnucomo database to the correct version it will make changes to the 
 * database. It is called within an if-statement when needed.
 * INPUT      : NONE (everything is available within the class)
 * OUTPUT     : Success TRUE/FALSE 
 * VALUES SET : NONE 
 */

 //Do while statement since all updateshave to be executed starting at the 
 //latest version. It's a walk through.

   switch ($active_version)
   {
     case 1:
       //DROP the rule that prohibits updates (change of spec).
       $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
       $local_sql = "UPDATE log SET processed = false";
       $dbms->query($local_sql); 

     case 3:
       //In the log_adv a column is added that indicates where the detailed
       //data has been written to
       $local_sql = "ALTER TABLE log_adv ADD COLUMN detailed_table VARCHAR(75)";
       $dbms->query($local_sql);

     case 4:
       //Create a log_adv_kernel_network table that recognizes the log-records
       //that have come from the kernel-network interface (typically iptables).
       $local_sql  = "CREATE TABLE log_adv_kernel_network (";
       $local_sql .= "device_in VARCHAR(15), device_out VARCHAR(15), hw_address  MACADDR, ";
       $local_sql .= "source_ip INET, destination_ip INET, packet_length BIGINT, ";
       $local_sql .= "tos_bit VARCHAR(5), ";
       $local_sql .= "prec_bit VARCHAR(5), ttl INT, header_id BIGINT, source_port INT, ";
       $local_sql .= "destination_port INT, body_length INT, protocol VARCHAR(5), ";
       $local_sql .= "body_len INT";
       $local_sql .= ") INHERITS (log_adv)"; 
       $dbms->query($local_sql);

     case 5:
       //Add the operating system to the object-table
       //COLUMN os (VARCHAR - 25)
       //COLUMN os_version (VARCHAR - 15)
       $local_sql = "ALTER TABLE object ADD COLUMN os TEXT";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE object ADD COLUMN os_version TEXT";
       $dbms->query($local_sql);

       $local_sql = "CREATE INDEX os ON object (os)";
       $dbms->query($local_sql);

       $local_sql = "CREATE INDEX os_version ON object (os, os_version)";
       $dbms->query($local_sql);

     case 6:
       //Create a table with supported operating systems. Only after a implementation of a
       //log-processing application a new OS will be added. This ensures the correctness of
       //the entire system.
       $local_sql = "CREATE TABLE supported_os (os_name TEXT, remarks TEXT)";
       $dbms->query($local_sql);

       $local_sql = "CREATE UNIQUE INDEX spp_os ON supported_os (os_name)";
       $dbms->query($local_sql);

     case 7:
       //Create a column in the log table that indicates if the daemon did recognize the 
       //log-record. This makes it easier to trace which log-records still have to be added
       //to the daemon.
       $local_sql = "ALTER TABLE log ADD COLUMN recognized BOOLEAN";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE log ALTER COLUMN recognized SET DEFAULT FALSE";
       $dbms->query($local_sql);
  
    case 8: 
       //Set the default value of processed to FALSE
       $local_sql = "ALTER TABLE log ALTER COLUMN processed SET DEFAULT FALSE";
       $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);

       $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN syn BOOLEAN";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE log_adv_kernel_network ALTER COLUMN syn SET DEFAULT FALSE";
       $dbms->query($local_sql);

    case 10:

       $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN type INT";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN code INT";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN sequence_number INT";
       $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);

       $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN rst BOOLEAN";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN df BOOLEAN";
       $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. 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, 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, 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, active)";
      $local_sql .= " values ('parameter removed',3,'A parameter was removed', true) ";
      $dbms->query($local_sql);

 case 20:
      $local_sql = "CREATE TABLE parameter_notification (notificationid bigint, paramid bigint,  primary key (notificationid, paramid))";
      $dbms->query($local_sql);
  
      $local_sql = "CREATE TABLE parameter_class (name text, property_name text, description text, property_type text, ";
      $local_sql .= "min float, max float, notify boolean, primary key (name, property_name));";
      $dbms->query($local_sql);

      $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
      $local_sql .= "VALUES ('package', 'version', 'The installed version of the package', 'STATIC', 't')";
      $dbms->query($local_sql);


case 21:
      $local_sql = "UPDATE action SET statuscode = LOWER(statuscode)";
      $dbms->query($local_sql);

case 22:
       //Create a log_adv_kernel_network table that recognizes the log-records
       //that have come from the kernel-network interface (typically iptables).
       $local_sql  = "CREATE TABLE log_adv_daemon (";
       $local_sql .= "service TEXT, event TEXT";
       $local_sql .= ") INHERITS (log_adv)";
       $dbms->query($local_sql);

case 23:
      $local_sql = "CREATE INDEX log_adv_daemon_service ON log_adv_daemon (service)";
      $dbms->query($local_sql);
 
case 24: 
       $local_sql = "ALTER TABLE object ADD COLUMN log_count BIGINT";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE object ADD COLUMN notification_count BIGINT";
       $dbms->query($local_sql);

       $local_sql = "ALTER TABLE object ADD COLUMN parameter_count BIGINT";
       $dbms->query($local_sql);
case 25:
       $local_sql = "UPDATE object SET log_count = '0', "
        . "notification_count = '0', " 
	. "parameter_count = '0' ";
       $dbms->query($local_sql);

case 26:
       $local_sql = "UPDATE type_of_issue SET name = TRIM(name)";
       $dbms->query($local_sql);

case 27: 
       $local_sql = "INSERT INTO db_value VALUES ('last_notification', '0')";
       $dbms->query($local_sql);

case 28:
       $dbms->query("CREATE GROUP view");
       $dbms->query("CREATE GROUP ops");
       $dbms->query("CREATE GROUP admin");

       $dbms->query("GRANT SELECT ON action TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON action_user TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON db_value TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON history TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON log TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON log_adv TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON log_adv_daemon TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON log_adv_kernel_network TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON log_notification TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON notification TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON object TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON object_issue TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON object_priority TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON object_service TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON object_user TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON parameter TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON parameter_class TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON parameter_notification TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON priority TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON property TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON service TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON status TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON supported_os TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON type_of_issue TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT SELECT ON usr TO GROUP view, GROUP ops, GROUP admin");
	
	$dbms->query("GRANT INSERT ON action_user TO GROUP ops, GROUP admin");
	$dbms->query("GRANT UPDATE ON notification TO GROUP ops, GROUP admin");
	$dbms->query("GRANT INSERT ON object TO GROUP admin");
	$dbms->query("GRANT UPDATE ON object TO GROUP ops, GROUP admin");
	$dbms->query("GRANT DELETE ON object TO GROUP admin");
	$dbms->query("GRANT UPDATE ON usr TO GROUP view, GROUP ops, GROUP admin");
	$dbms->query("GRANT INSERT ON usr TO GROUP admin");
	$dbms->query("GRANT DELETE ON usr TO GROUP admin");

case 29:
     $local_sql = "INSERT INTO action (actionname, description) VALUES ('Redisplayed to user', "
      . "'The notification has been presented to a user. This is not the first time')";
     $dbms->query ($local_sql);

case 30:
    $local_sql = "INSERT INTO action (actionname, description) VALUES ('Displayed in list', "
     . "'The notification has been presented in a list with other notifications.')";
    $dbms->query ($local_sql);

case 31:
     $local_sql  = "CREATE TABLE log_adv_daemon_email (";
     $local_sql .= "source_ip INET, destination_ip INET, internal_messageid TEXT, ";
     $local_sql .= "external_messageid TEXT, to_email TEXT, from_email TEXT, delay TIME, xdelay TIME, ";
     $local_sql .= "mailer TEXT, status TEXT, pid INT";
     $local_sql .= ") INHERITS (log_adv_daemon)";
     $dbms->query($local_sql);

case 32:
     $local_sql = "CREATE INDEX log_adv_daemon_email_s_ip ON log_adv_daemon_email (source_ip)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_daemon_email_d_ip ON log_adv_daemon_email (destination_ip)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_daemon_email_to   ON log_adv_daemon_email (to_email)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_daemon_email_from ON log_adv_daemon_email (from_email)";
     $dbms->query($local_sql);


case 33:
     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN size INT";
     $dbms->query($local_sql);

case 34:
     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN pri INT";
     $dbms->query($local_sql);

     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN relay TEXT";
     $dbms->query($local_sql);

     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN status_details TEXT";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_email_status ON log_adv_daemon_email (status)";
     $dbms->query($local_sql);
	       
case 35:
     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN dsn TEXT";
     $dbms->query($local_sql);

case 36:
     //Create a notification check
    
     $local_sql  = "CREATE SEQUENCE checkid_seq";
     $dbms->query($local_sql);
    
     $local_sql  = "CREATE TABLE notification_check (";
     $local_sql .= "checkid bigint DEFAULT nextval('checkid_seq'::text) NOT NULL,";
     $local_sql .= "checkname TEXT, description TEXT, time_between_executions INTERVAL, ";
     $local_sql .= "last_execution timestamp, execution_counter BIGINT,";
     $local_sql .= "notificationcounter BIGINT)";
     $dbms->query($local_sql);

     $local_sql = "CREATE UNIQUE INDEX not_check_checkid ON notification_check (checkid)";
     $dbms->query($local_sql);

     $local_sql = "CREATE UNIQUE INDEX not_check_checkname ON notification_check (checkname)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX not_check_check_lastexec ON notification_check (last_execution)";
     $dbms->query($local_sql);

case 37:
     $local_sql = "ALTER TABLE notification_check ADD COLUMN decreasinglist BOOLEAN";
     $dbms->query($local_sql);


     $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";
     $dbms->query($local_sql);

     $local_sql  = "CREATE SEQUENCE checklineid_seq";
     $dbms->query($local_sql);
     
     $local_sql  = "CREATE TABLE notification_check_line (";
     $local_sql .= "checklineid BIGINT DEFAULT nextval('checklineid_seq'::text) NOT NULL,";
     $local_sql .= "checkid BIGINT, sortorder INTEGER, last_logid BIGINT, ";
     $local_sql .= "historicboundary INTERVAL, use_logid BOOLEAN, sql_query TEXT";
     $local_sql .= ")";
     $dbms->query($local_sql);
     
     $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";
     $dbms->query($local_sql);
     
     $local_sql = "ALTER TABLE notification_check_line ALTER COLUMN last_logid       SET DEFAULT 0";
     $dbms->query($local_sql);

case 38:
     $local_sql = "CREATE UNIQUE INDEX notcheckline_checklineid ON notification_check_line (checklineid)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX notcheckline_checkid            ON notification_check_line (checkid)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX notcheckline_sort               ON notification_check_line (sortorder)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX notcheckline_check_sort         ON notification_check_line (checkid, sortorder)";
     $dbms->query($local_sql);

case 39: 
     $local_sql  = "CREATE TABLE notification_check_buffer (";
     $local_sql .= "checkid BIGINT, sortorder INTEGER, pid INTEGER, logid bigint";
     $local_sql .= ")";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX notcheckbuffer_checkid ON notification_check_buffer(checkid)";
     $dbms->query($local_sql);
     
     $local_sql = "CREATE INDEX notcheckbuffer_sort ON notification_check_buffer(sortorder)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX notcheckbuffer_pid ON notification_check_buffer(pid)";
     $dbms->query($local_sql);
     
     $local_sql = "CREATE INDEX notcheckbuffer_logid ON notification_check_buffer(logid)";
     $dbms->query($local_sql);
     
case 40:
     $local_sql  = "CREATE TABLE object_statistics (";
     $local_sql .= "objectid       bigint,";
     $local_sql .= "statname       text,";
     $local_sql .= "statvalue      double precision,";
     $local_sql .= "primary key (objectid, statname)";
     $local_sql .= ")";
     $dbms->query($local_sql);

     $local_sql  = "CREATE INDEX obj_stat_objid ON object_statistics USING btree (objectid)";
     $dbms->query($local_sql);

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);

case 43:

     //  We need to change the type of the 'delay' and 'xdelay' fields in
     //  the 'log_adv_daemon_email' table from type time to type interval.
     //  This can not be done directly; it requires recreating the entire
     //  table and copying data from the old table.

     $local_sql = "ALTER TABLE log_adv_daemon_email RENAME TO old_table";
     $dbms->query($local_sql);

     $local_sql = "CREATE TABLE log_adv_daemon_email
                   (
                      source_ip            INET,
                      destination_ip       INET,
                      internal_messageid   TEXT, 
                      external_messageid   TEXT,
                      to_email             TEXT,
                      from_email           TEXT,
                      delay                interval,
                      xdelay               interval,
                      mailer               TEXT,
                      status               TEXT,
                      pid                  INT,
                      size                 INT,
                      pri                  INT,
                      relay                TEXT,
                      status_details       TEXT,
                      dsn                  TEXT
                 ) INHERITS (log_adv_daemon)";
     $dbms->query($local_sql);

     $local_sql = "INSERT INTO log_adv_daemon_email SELECT * FROM old_table";
     $dbms->query($local_sql);

     $local_sql = "DROP TABLE old_table";
     $dbms->query($local_sql);

     // The indices need to be recreated as well.

     $local_sql = "CREATE INDEX log_adv_daemon_email_s_ip ON log_adv_daemon_email (source_ip)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_daemon_email_d_ip ON log_adv_daemon_email (destination_ip)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_daemon_email_to   ON log_adv_daemon_email (to_email)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_daemon_email_from ON log_adv_daemon_email (from_email)";
     $dbms->query($local_sql);

     $local_sql = "CREATE INDEX log_adv_email_status      ON log_adv_daemon_email (status)";
     $dbms->query($local_sql);

   case 44:

     $local_sql = "CREATE TABLE object_abuse
                   (
                           objectid   bigint,
                           source     inet,
                           nr_abuses  integer,
                           status     text,

                           primary key (objectid, source)
                   );";
     $dbms->query($local_sql);
     $dbms->query("GRANT SELECT ON log_adv_daemon_email TO GROUP view, GROUP ops, GROUP admin");
     $dbms->query("GRANT SELECT ON object_abuse TO GROUP view, GROUP ops, GROUP admin");
     $dbms->query("GRANT INSERT ON object_abuse TO GROUP admin");
     $dbms->query("GRANT UPDATE ON object_abuse TO GROUP ops, GROUP admin");
     $dbms->query("GRANT DELETE ON object_abuse TO GROUP admin");
     $dbms->query("GRANT SELECT ON object_statistics TO GROUP view, GROUP ops, GROUP admin");

     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
     $local_sql .= " VALUES ('abuses exceeded',5,'Abuse treshold exceeded from an IP address', true) ";
     $dbms->query($local_sql);

   case 45:

     $local_sql = "CREATE TABLE service_pattern
                   (
                         service   text,
                         rank      int,
                         pattern   text,
                         action    text,
                         argument  text,

                         primary key (service, rank)
                   )";
     $dbms->query($local_sql);
     $local_sql = "INSERT INTO service_pattern VALUES ('ANY', 999999, '.+', 'notify', 'unmatched log')";
     $dbms->query($local_sql);
     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
     $local_sql .= " VALUES ('unmatched log',5,'Log entries could not be matched', true) ";
     $dbms->query($local_sql);

   case 46:

     $local_sql = "CREATE TABLE log_abuse
                   (
                           logid      bigint,
	                   objectid   bigint,
                           source     inet
                   )";
     $dbms->query($local_sql);

   case 47:

     $local_sql = "INSERT INTO service_pattern VALUES ('ANY', 999990, '[Ee][Rr][Rr][Oo][Rr]', 'notify', 'Error detected')";
     $dbms->query($local_sql);
     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
     $local_sql .= " VALUES ('Error detected',5,'An Error is reported in the log', true) ";
     $dbms->query($local_sql);

     $local_sql = "INSERT INTO service_pattern VALUES ('ANY', 999991, '[Ff][Aa][Ii][Ll]', 'notify', 'Failure detected')";
     $dbms->query($local_sql);
     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
     $local_sql .= " VALUES ('Failure detected',5,'A Failure is reported in the log', true) ";
     $dbms->query($local_sql);

     $local_sql = "INSERT INTO service_pattern VALUES ('ANY', 999992, '[Ww][Aa][Rr][Nn]', 'notify', 'Warning detected')";
     $dbms->query($local_sql);
     $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
     $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");

   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);

   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 = "UPDATE db_value SET setting_value = ".$db_version." WHERE setting = 'db_version'";

   $dbms->query($local_sql);


?>