From e5362e31bcb654017ee60cc651360dbf3c40637f Mon Sep 17 00:00:00 2001
From: arjen <arjen>
Date: Sat, 29 Mar 2003 08:26:44 +0000
Subject: [PATCH] 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'.

---
 src/database/create.sql                       | 23 ++++++++++++++---
 src/gcm_daemon/classes/gnucomo_db_version.php | 36 +++++++++++++++++++++++++++
 2 files changed, 56 insertions(+), 3 deletions(-)

diff --git a/src/database/create.sql b/src/database/create.sql
index 21d0ef6..b43289f 100644
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -12,7 +12,12 @@
 -- 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
@@ -131,7 +136,7 @@ CREATE TABLE "db_value"
 
 
 COPY "db_value" FROM stdin;
-db_version	32
+db_version	36
 gcm_daemon_version	1
 log_processing	0
 last_notification	0
@@ -257,9 +262,21 @@ CREATE TABLE log_adv_daemon_email
      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 '
diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index 9908b81..f28e62c 100644
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -295,6 +295,42 @@ case 31:
      $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
 /*
 			  
-- 
2.11.0