Index: openacs-4/packages/acs-mail/sql/oracle/acs-mail-queue-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/oracle/acs-mail-queue-create.sql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/acs-mail/sql/oracle/acs-mail-queue-create.sql 19 Sep 2002 13:40:00 -0000 1.3 +++ openacs-4/packages/acs-mail/sql/oracle/acs-mail-queue-create.sql 17 Jan 2003 14:32:32 -0000 1.4 @@ -38,11 +38,12 @@ create table acs_mail_queue_outgoing ( message_id integer - constraint acs_mail_queue_out_mlid_pk primary key constraint acs_mail_queue_out_mlid_fk references acs_mail_queue_messages on delete cascade, envelope_from varchar2(4000), - envelope_to varchar2(4000) + envelope_to varchar2(4000), + constraint acs_mail_queue_out_pk + primary key (message_id, envelope_to) ); -- API -----------------------------------------------------------------