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')";
- echo $local_sql;
$dbms->query ($local_sql);
-/*
- //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
+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);
+
+
+//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);