-- DBA create the database and give access permissions.
--
-- $Log: create.sql,v $
--- Revision 1.12 2003-02-21 08:38:38 arjen
+-- Revision 1.13 2003-03-29 08:27:05 arjen
+-- New columns in the table 'log_adv_daemon_email': size, pri, relay,
+-- status_details and dsn.
+-- Added several indices for the table 'log_adv_daemon_email'.
+--
+-- Revision 1.12 2003/02/21 08:38:38 arjen
-- Added new table to the database: log_adv_daemon_email.
--
-- Revision 1.11 2003/02/16 08:24:38 arjen
COPY "db_value" FROM stdin;
-db_version 32
+db_version 36
gcm_daemon_version 1
log_processing 0
last_notification 0
xdelay TIME,
mailer TEXT,
status TEXT,
- pid INT
+ pid INT,
+ size INT,
+ pri INT,
+ relay TEXT,
+ status_details TEXT,
+ dsn TEXT
) INHERITS (log_adv_daemon);
+CREATE INDEX log_adv_daemon_email_s_ip ON log_adv_daemon_email (source_ip);
+CREATE INDEX log_adv_daemon_email_d_ip ON log_adv_daemon_email (destination_ip);
+CREATE INDEX log_adv_daemon_email_to ON log_adv_daemon_email (to_email);
+CREATE INDEX log_adv_daemon_email_from ON log_adv_daemon_email (from_email);
+CREATE INDEX log_adv_email_status ON log_adv_daemon_email (status);
+
+
/*
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER '';
CREATE FUNCTION "funct_processlog" () RETURNS opaque AS '
$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
/*