Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql,v diff -u -r1.5 -r1.5.2.1 --- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql 19 Sep 2002 13:40:01 -0000 1.5 +++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql 17 Jan 2003 14:37:17 -0000 1.5.2.1 @@ -39,12 +39,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 text, - envelope_to text + envelope_to text, + constraint acs_mail_queue_out_pk + primary key (message_id, envelope_to) ); -- API -----------------------------------------------------------------