Index: openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql	16 Jan 2004 21:46:15 -0000	1.3
+++ openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql	21 Jan 2004 11:43:20 -0000	1.4
@@ -20,7 +20,10 @@
     package_id			integer
     				constraint acs_mail_lite_queue_pck_fk
 				references apm_packages,
-    valid_email_p		boolean
+    valid_email_p		varchar2(1)
+				-- Malte needs to check whether this needs a default
+				constraint acs_mail_lite_qu_valid_em_p_ck
+				check (valid_email_p in ('t','f'))
 );
 
 create table acs_mail_lite_mail_log (
@@ -30,7 +33,8 @@
                                 on delete cascade
 				constraint acs_mail_lite_log_pk
 				primary key,
-    last_mail_date		timestamptz default current_timestamp
+-- Dirk: changed from timestamp to date. Malte needs to doublecheck whether this is correct
+    last_mail_date		date default sysdate
 );
 
 
@@ -52,6 +56,7 @@
                                 on delete cascade
 				constraint acs_mail_lite_notif_pk
 				primary key,
-    notification_time		timestamptz default current_timestamp,
+-- Dirk: changed from timestamp to date. Malte needs to doublecheck whether this is correct
+    notification_time		date default sysdate,
     notification_count		integer default 0
 );