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 -r1.4 -r1.5
--- 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	3 Sep 2024 15:37:35 -0000	1.5
@@ -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
@@ -30,6 +30,7 @@
     query                       clob
                                 constraint bm_messages_query_nn
                                 not null,
+    to_display_name             text,
     status                      varchar2(100)
                                 default 'pending'
                                 constraint bm_messages_status_ck
