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;