+
+ 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.' ";
+ $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')";
+ $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')";
+ $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') ";
+ $dbms->query($local_sql);
+
+/*
+ //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);
+*/