Index: openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql,v diff -u -N -r1.10 -r1.11 --- openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql 9 Jan 2008 15:29:12 -0000 1.10 +++ openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql 9 Jan 2008 16:51:30 -0000 1.11 @@ -7,20 +7,28 @@ 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 text, - from_addr varchar(200), - subject varchar(200), - body text, - extra_headers text, - bcc text, - package_id integer - constraint acs_mail_lite_queue_pck_fk - references apm_packages, - valid_email_p boolean +CREATE TABLE acs_mail_lite_queue ( + message_id integer + constraint acs_mail_lite_queue_pk + primary key, + creation_date text, + locking_server text, + to_addr text, + cc_addr text, + bcc_addr text, + from_addr text, + reply_to text, + subject text, + body text, + package_id integer + constraint amlq_package_id_fk + references apm_packages, + file_ids text, + mime_type text, + object_id integer, + no_callback_p boolean, + extraheaders text, + use_sender_p boolean ); create table acs_mail_lite_mail_log (