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