Index: openacs-4/packages/acs-mail-lite/acs-mail-lite.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/acs-mail-lite.info,v
diff -u -r1.57 -r1.58
--- openacs-4/packages/acs-mail-lite/acs-mail-lite.info	20 Feb 2018 09:07:27 -0000	1.57
+++ openacs-4/packages/acs-mail-lite/acs-mail-lite.info	8 Mar 2018 11:09:02 -0000	1.58
@@ -9,7 +9,7 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
     
-    <version name="5.10.0d3" url="http://openacs.org/repository/download/apm/acs-mail-lite-5.10.0d3.apm">
+    <version name="5.10.0d4" url="http://openacs.org/repository/download/apm/acs-mail-lite-5.10.0d4.apm">
         <owner url="mailto:timo@studio-k4.de">Timo Hentschel</owner>
         <owner url="mailto:malte.sussdorff@cognovis.de">Malte Sussdorff</owner>
         <summary>Simplified reliable email transmission with bounce management.</summary>
@@ -18,7 +18,7 @@
         <description format="text/html">This package provides a service for sending and receiving messages, messages are queued in the database to ensure reliable sending and make sending a message &#39;transactional&#39;. Replacement for acs-mail.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-mail-lite" version="5.10.0d3"/>
+        <provides url="acs-mail-lite" version="5.10.0d4"/>
         <requires url="acs-kernel" version="5.9.0"/>
         <requires url="acs-service-contract" version="5.9.0"/>
         <requires url="acs-tcl" version="5.9.0"/>
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 -r1.14 -r1.15
--- openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	17 Feb 2018 17:08:31 -0000	1.14
+++ openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	8 Mar 2018 11:09:02 -0000	1.15
@@ -406,13 +406,16 @@
        msg_id        text primary key,
        package_id    integer
                      constraint aml_package_id_fk
-                     references apm_packages,
+                     references apm_packages
+                     on delete cascade,
        party_id      integer
                      constraint aml_from_external_party_id_fk
-                     references parties (party_id),
+                     references parties (party_id)
+                     on delete cascade,
        object_id     integer 
                      constraint aml_from_external_obect_id_fk
-                     references acs_objects (object_id),
+                     references acs_objects (object_id)
+                     on delete cascade,
        -- Indicate approximate time when this email is created
        datetime_cs   integer,
        -- other data or parameters to associate with email
Index: openacs-4/packages/acs-mail-lite/sql/postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-mail-lite/sql/postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql	8 Mar 2018 11:09:02 -0000	1.1
@@ -0,0 +1,15 @@
+
+-- add on delete cascade on foreign key constraints for acs_mail_lite_send_msg_id_map table
+
+alter table acs_mail_lite_send_msg_id_map
+  drop constraint if exists aml_package_id_fk,  
+  add constraint aml_package_id_fk foreign key (package_id)
+     references apm_packages(package_id) on delete cascade,
+     
+  drop constraint if exists aml_from_external_party_id_fk,     
+  add constraint aml_from_external_party_id_fk foreign key (party_id)   
+     references parties(party_id) on delete cascade,
+                
+  drop constraint if exists aml_from_external_obect_id_fk,     
+  add constraint aml_from_external_object_id_fk foreign key (object_id)
+     references acs_objects(object_id) on delete cascade;