-- 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 '