Added new table to the database: log_adv_daemon_email.

[gnucomo.git] / src / database / create.sql

diff --git a/src/database/create.sql b/src/database/create.sql
index 9cd0309..21d0ef6 100644 (file)
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -12,7 +12,13 @@
 -- DBA create the database and give access permissions.
 --
 --  $Log: create.sql,v $
 -- DBA create the database and give access permissions.
 --
 --  $Log: create.sql,v $

---  Revision 1.10  2003-02-14 06:32:27  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

 --  Setup the groups and database permissions. The three groups
 --  are: view, ops and admin.
 --  Added a new entry to the action table.
 --  Setup the groups and database permissions. The three groups
 --  are: view, ops and admin.
 --  Added a new entry to the action table.


@@ -70,6 +76,7 @@ COPY "action" FROM stdin;
 18     Notification closed     cls     The notification has been closed.
 19     Notification reopend    opn     The notification has been reopend.
 20     Redisplayed to user     \N      The notification has been presented to a user. This is not the first time
 18     Notification closed     cls     The notification has been closed.
 19     Notification reopend    opn     The notification has been reopend.
 20     Redisplayed to user     \N      The notification has been presented to a user. This is not the first time

+21     Displayed in list       \N      The notification has been presented in a list with other notifications.

 \.
 
 CREATE UNIQUE INDEX action_actionid_key ON "action" USING btree (actionid);
 \.
 
 CREATE UNIQUE INDEX action_actionid_key ON "action" USING btree (actionid);


@@ -124,7 +131,7 @@ CREATE TABLE "db_value"
 
 
 COPY "db_value" FROM stdin;
 
 
 COPY "db_value" FROM stdin;

-db_version     28
+db_version     32

 gcm_daemon_version     1
 log_processing 0
 last_notification      0
 gcm_daemon_version     1
 log_processing 0
 last_notification      0


@@ -233,11 +240,26 @@ CREATE TABLE log_adv_kernel_network
 CREATE TABLE log_adv_daemon
 (
        service TEXT,
 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);
 
 ) 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 '
 /*
 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER '';
 CREATE FUNCTION "funct_processlog" () RETURNS opaque AS '