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