Added new table to the database: log_adv_daemon_email.

diff --git a/src/database/create.sql b/src/database/create.sql
index 219abe0..21d0ef6 100644 (file)
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -12,7 +12,10 @@
 -- DBA create the database and give access permissions.
 --
 --  $Log: create.sql,v $
---  Revision 1.11  2003-02-16 08:24:38  arjen
+--  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
 --  Added a new entry to the action table: Notification was displayed in the listing
 --
 --  Revision 1.10  2003/02/14 06:32:27  arjen
@@ -128,7 +131,7 @@ CREATE TABLE "db_value"
 
 
 COPY "db_value" FROM stdin;
-db_version     31
+db_version     32
 gcm_daemon_version     1
 log_processing 0
 last_notification      0
@@ -237,11 +240,26 @@ CREATE TABLE log_adv_kernel_network
 CREATE TABLE log_adv_daemon
 (
        service TEXT,
-       event TEXT
+       event   TEXT
 ) INHERITS (log_adv);
 
 CREATE INDEX log_adv_daemon_service ON log_adv_daemon (service);
 
+CREATE TABLE log_adv_daemon_email
+(
+     source_ip            INET,
+     destination_ip       INET,
+     internal_messageid   TEXT, 
+     external_messageid   TEXT,
+     to_email             TEXT,
+     from_email           TEXT,
+     delay                TIME,
+     xdelay               TIME,
+     mailer               TEXT,
+     status               TEXT,
+     pid                  INT
+) INHERITS (log_adv_daemon);
+
 /*
 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER '';
 CREATE FUNCTION "funct_processlog" () RETURNS opaque AS '

diff --git a/src/database/destroy.sql b/src/database/destroy.sql
index 550217d..f69b1ed 100644 (file)
--- a/src/database/destroy.sql
+++ b/src/database/destroy.sql
@@ -32,6 +32,7 @@ DROP TABLE "log";
 DROP SEQUENCE "log_advid_seq";
 
 DROP TABLE log_adv_kernel_network;
+DROP TABLE log_adv_daemon_email;
 DROP TABLE log_adv_daemon;
 DROP TABLE "log_adv";
 

diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index a32e8ed..9908b81 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -287,10 +287,17 @@ case 30:
      . "'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);
 
-/*    
-     //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
+//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);
 

diff --git a/src/gcm_daemon/gcm_daemon.php b/src/gcm_daemon/gcm_daemon.php
index 3be6fe2..1ed9bc9 100755 (executable)
--- a/src/gcm_daemon/gcm_daemon.php
+++ b/src/gcm_daemon/gcm_daemon.php
@@ -18,9 +18,14 @@
    First       : November 8th 2002
    Gnucomo-0.0.3: December 6th 2002
 
+ $Log: gcm_daemon.php,v $
+ Revision 1.9  2003-02-21 08:37:59  arjen
+ Added new table to the database: log_adv_daemon_email.
+
+
 */
 
-// $Id: gcm_daemon.php,v 1.8 2003-02-16 08:24:06 arjen Exp $
+// $Id: gcm_daemon.php,v 1.9 2003-02-21 08:37:59 arjen Exp $
 
 ini_set('include_path', '.:./classes:../phpclasses');
 
@@ -37,7 +42,7 @@ require_once "gnucomo.process_log.php";
 $project_name  = "gnucomo";    //name of the entire project
 $app_name      = "gcm_daemon"; //name of the application running
 $developrelease = "TRUE";      //Indicates if special debug settings are needed
-$db_version    = 31;           //The db_version indicates what the level of 
+$db_version    = 32;           //The db_version indicates what the level of 
                                //the database should be. If the database is 
                                //old an update will be generated.
 $gcmd_version   = 3;           //This value indicates the active version of the gcm_daemon,