Index: openacs-4/packages/acs-mail/acs-mail.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/acs-mail.info,v
diff -u -r1.8.2.1 -r1.8.2.2
--- openacs-4/packages/acs-mail/acs-mail.info	29 Oct 2002 01:51:47 -0000	1.8.2.1
+++ openacs-4/packages/acs-mail/acs-mail.info	17 Jan 2003 14:37:16 -0000	1.8.2.2
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="4.6" url="http://www.arsdigita.com/acs-repository/download/apm/acs-mail-4.6.apm">
+    <version name="4.6.1" url="http://www.arsdigita.com/acs-repository/download/apm/acs-mail-4.6.1.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -19,7 +19,7 @@
         <vendor url="http://www.openacs.org/">OpenACS</vendor>
         <description format="text/html">Provides generic message services, with email sending.</description>
 
-        <provides url="acs-mail" version="4.6"/>
+        <provides url="acs-mail" version="4.6.1"/>
         <requires url="acs-content-repository" version="4.1"/>
         <requires url="acs-kernel" version="4.1"/>
 
@@ -34,13 +34,15 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/acs-mail-packages-create.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/acs-mail-queue-create.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.5-4.6.sql"/>
+            <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.6-4.6.1.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/acs-mail-create.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/acs-mail-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/acs-mail-nt-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/acs-mail-nt-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/acs-mail-packages-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/acs-mail-queue-create.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.5-4.6.sql"/>
+            <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql"/>
             <file type="tcl_init" path="tcl/acs-mail-init.tcl"/>
             <file type="query_file" db_type="oracle" path="tcl/acs-mail-procs-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="tcl/acs-mail-procs-postgresql.xql"/>
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 -r1.3 -r1.3.2.1
--- 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:37:16 -0000	1.3.2.1
@@ -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 -----------------------------------------------------------------
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 -----------------------------------------------------------------