Changed the type of log_adv_daemon_email.delay and log_adv_daemon_email.xdelay

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

diff --git a/src/database/create.sql b/src/database/create.sql
index e497a25..33909f0 100644 (file)
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -12,7 +12,11 @@
 -- DBA create the database and give access permissions.
 --
 --  $Log: create.sql,v $
---  Revision 1.17  2003-09-02 12:49:47  arjen
+--  Revision 1.18  2003-12-03 08:06:57  arjen
+--  Changed the type of log_adv_daemon_email.delay and log_adv_daemon_email.xdelay
+--  from time to interval. These delays can be more than 24 hours.
+--
+--  Revision 1.17  2003/09/02 12:49:47  arjen
 --  BUGFIX: Secondary indices on log_notification were unique.
 --  Additional information in the 'usr' table: 'display_name' and 'email'.
 --  Added new issues and services.
@@ -151,7 +155,7 @@ CREATE TABLE "db_value"
 
 
 COPY "db_value" FROM stdin;
-db_version     43
+db_version     44
 gcm_daemon_version     5
 log_processing 0
 last_notification      0
@@ -275,8 +279,8 @@ CREATE TABLE log_adv_daemon_email
      external_messageid   TEXT,
      to_email             TEXT,
      from_email           TEXT,
-     delay                TIME,
-     xdelay               TIME,
+     delay                interval,
+     xdelay               interval,
      mailer               TEXT,
      status               TEXT,
      pid                  INT,