Index: openacs-4/packages/bulk-mail/bulk-mail.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/bulk-mail.info,v
diff -u -N -r1.19 -r1.19.2.1
--- openacs-4/packages/bulk-mail/bulk-mail.info	11 Dec 2018 10:38:04 -0000	1.19
+++ openacs-4/packages/bulk-mail/bulk-mail.info	30 Jul 2020 16:36:23 -0000	1.19.2.1
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="2.10.0d1" url="http://openacs.org/repository/download/apm/bulk-mail-2.10.0d1.apm">
+    <version name="2.10.0d2" url="http://openacs.org/repository/download/apm/bulk-mail-2.10.0d2.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <release-date>2017-08-06</release-date>
         <vendor url="http://dotlrn.org">DotLRN Consortium</vendor>
@@ -16,7 +16,7 @@
         <description format="text/html">Provides an API for sending messages to a collection of users (which can be chosen via arbitrary sql).  Mails can be personalized and can be scheduled for a later date.</description>
 
 
-        <provides url="bulk-mail" version="2.10.0d1"/>
+        <provides url="bulk-mail" version="2.10.0d2"/>
         <requires url="acs-mail-lite" version="5.9.1"/>
 
         <callbacks>
Index: openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql,v
diff -u -N -r1.4 -r1.4.2.1
--- openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	11 Dec 2018 10:38:04 -0000	1.4
+++ openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	30 Jul 2020 16:36:23 -0000	1.4.2.1
@@ -7,11 +7,11 @@
 
 create table bulk_mail_messages (
     bulk_mail_id                constraint bm_messages_bulk_mail_id_fk
-                                references acs_objects (object_id)
+                                references acs_objects (object_id) on delete cascade
                                 constraint bm_messages_bulk_mail_id_pk
                                 primary key,
     package_id                  constraint bm_messages_package_id_fk
-                                references apm_packages (package_id)
+                                references apm_packages (package_id) on delete cascade
                                 constraint bm_messages_package_id_nn
                                 not null,
     send_date                   date
Index: openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/oracle/upgrade/Attic/upgrade-2.10.0d1-2.10.0d2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql	30 Jul 2020 16:36:23 -0000	1.1.2.1
@@ -0,0 +1,11 @@
+-- untested...
+
+begin;
+
+alter table bulk_mail_messages drop constraint bm_messages_bulk_mail_id_fk;
+alter table bulk_mail_messages add constraint bm_messages_bulk_mail_id_fk foreign key (bulk_mail_id) references acs_objects (object_id) on delete cascade;
+
+alter table bulk_mail_messages drop constraint bm_messages_package_id_fk;
+alter table bulk_mail_messages add constraint bm_messages_package_id_fk foreign key (package_id) references apm_packages (package_id) on delete cascade;
+
+end;
Index: openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql,v
diff -u -N -r1.6 -r1.6.2.1
--- openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql	11 Dec 2018 10:38:05 -0000	1.6
+++ openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql	30 Jul 2020 16:36:23 -0000	1.6.2.1
@@ -8,12 +8,12 @@
 create table bulk_mail_messages (
     bulk_mail_id                integer
                                 constraint bm_messages_bulk_mail_id_fk
-                                references acs_objects (object_id)
+                                references acs_objects (object_id) on delete cascade
                                 constraint bm_messages_bulk_mail_id_pk
                                 primary key,
     package_id                  integer
                                 constraint bm_messages_package_id_fk
-                                references apm_packages (package_id)
+                                references apm_packages (package_id) on delete cascade
                                 constraint bm_messages_package_id_nn
                                 not null,
     send_date                   timestamptz
Index: openacs-4/packages/bulk-mail/sql/postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/upgrade/Attic/upgrade-2.10.0d1-2.10.0d2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bulk-mail/sql/postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql	30 Jul 2020 16:36:23 -0000	1.1.2.1
@@ -0,0 +1,9 @@
+begin;
+
+alter table bulk_mail_messages drop constraint bm_messages_bulk_mail_id_fk;
+alter table bulk_mail_messages add constraint bm_messages_bulk_mail_id_fk foreign key (bulk_mail_id) references acs_objects (object_id) on delete cascade;
+
+alter table bulk_mail_messages drop constraint bm_messages_package_id_fk;
+alter table bulk_mail_messages add constraint bm_messages_package_id_fk foreign key (package_id) references apm_packages (package_id) on delete cascade;
+
+end;