-- 
-- packages/acs-mail-lite/sql/oracle/acs-mail-lite-complex-create.sql
-- 
-- @creation-date 2008-01-09
-- @arch-tag: 6011c305-fdb8-4b7b-ba68-3317a060a695
-- @cvs-id $Id: complex-create.sql,v 1.1 2008/01/09 14:35:12 emmar Exp $
--

CREATE TABLE acs_mail_lite_complex_queue (
    id 				integer
                                constraint acs_mail_lite_complex_queue_pk 
				PRIMARY KEY,
    creation_date 		varchar(4000),
    locking_server 		varchar(4000),
    to_party_ids 		varchar(4000),
    cc_party_ids 		varchar(4000),
    bcc_party_ids 		varchar(4000),
    to_group_ids 		varchar(4000),
    cc_group_ids		varchar(4000),
    bcc_group_ids 		varchar(4000),
    to_addr 			clob,
    cc_addr 			clob,
    bcc_addr			clob,
    from_addr 			varchar(400),
    reply_to 			varchar(400),
    subject 			varchar(4000),
    body 			clob,
    package_id 			integer,
    files 			varchar(4000),
    file_ids 			varchar(4000),
    folder_ids 			varchar(4000),
    mime_type 			varchar(200),
    object_id 			integer,
    single_email_p 		varchar2(1)
				constraint aml_co_qu_single_em_p_ck
				check (single_email_p in ('t','f')),
    no_callback_p 		varchar2(1)
				constraint aml_co_qu_no_callb_p_ck
				check (no_callback_p in ('t','f')),
    extraheaders 		clob,
    alternative_part_p		varchar2(1)
				constraint aml_co_qu_alt_part_p_ck
				check (alternative_part_p in ('t','f')),
    use_sender_p 		varchar2(1)
				constraint aml_co_qu_use_sender_p_ck
				check (use_sender_p in ('t','f'))
);
