Index: openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql	14 Jan 2004 17:34:52 -0000	1.1
+++ openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql	21 Jan 2004 14:51:49 -0000	1.2
@@ -1,14 +1,15 @@
 alter table acs_mail_lite_queue add column package_id integer constraint acs_mail_lite_queue_pck_fk references apm_packages;
-alter table acs_mail_lite_queue add column valid_email_p boolean;
+alter table acs_mail_lite_queue add column valid_email_p varchar2(1) constraint acs_mail_lite_qu_valid_em_p_ck check (valid_email_p in ('t','f'));
 
+
 create table acs_mail_lite_mail_log (
     user_id                     integer
                                 constraint acs_mail_lite_log_user_id_fk
                                 references users (user_id)
                                 on delete cascade
                                 constraint acs_mail_lite_log_pk
                                 primary key,
-    last_mail_date              timestamptz default current_timestamp
+    last_mail_date              date default sysdate
 );
 
 
@@ -30,7 +31,7 @@
                                 on delete cascade
                                 constraint acs_mail_lite_notif_pk
                                 primary key,
-    notification_time           timestamptz default current_timestamp,
+    notification_time           date default sysdate,
     notification_count          integer default 0
 );
  
\ No newline at end of file