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.13 -r1.13.8.1 --- openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql 18 Mar 2009 22:41:15 -0000 1.13 +++ openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql 25 Jul 2014 16:49:35 -0000 1.13.8.1 @@ -8,31 +8,33 @@ create sequence acs_mail_lite_id_seq; 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')) + 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), + filesystem_files varchar(4000), + delete_filesystem_files_p boolean, + 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 (