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 -N -r1.11 -r1.12
--- openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql	9 Jan 2008 15:37:21 -0000	1.11
+++ openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql	9 Jan 2008 16:51:29 -0000	1.12
@@ -7,22 +7,32 @@
 
 create sequence acs_mail_lite_id_seq;
 
-create table acs_mail_lite_queue (
-    message_id                  integer
-                                constraint acs_mail_lite_queue_pk
-                                primary key,
-    to_addr                     varchar(400),
-    from_addr                   varchar(200),
-    subject                     varchar(200),
-    body                        clob,
-    extra_headers               clob,
-    bcc                         clob,
-    package_id			integer
-    				constraint acs_mail_lite_queue_pck_fk
-				references apm_packages,
-    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_queue (
+    message_id          integer
+                        constraint acs_mail_lite_queue_pk 
+                        PRIMARY KEY,
+    creation_date       varchar(4000),
+    locking_server      varchar(4000),
+    to_addr             varchar(4000),
+    cc_addr             clob,
+    bcc_addr            clob,
+    from_addr           varchar(400),
+    reply_to            varchar(400),
+    subject             varchar(4000),
+    body                clob,
+    package_id          integer
+                        constraint amlq_package_id_fk
+                        references apm_packages,
+    file_ids            varchar(4000),
+    mime_type           varchar(200),
+    object_id           integer,
+    no_callback_p       char(1)
+                        constraint amlq_no_callback_p_ck
+                        check (no_callback_p in ('t','f')),
+    extraheaders        clob,
+    use_sender_p        char(1)
+                        constraint amlq_use_sender_p_ck
+                        check (use_sender_p in ('t','f'))
 );
 
 create table acs_mail_lite_mail_log (
