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