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 -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 @@
f
f
-
+
OpenACS
2017-08-06
DotLRN Consortium
@@ -16,7 +16,7 @@
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.
-
+
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.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
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql'.
Fisheye: No comparison available. Pass `N' to diff?
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.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
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/bulk-mail/sql/postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql'.
Fisheye: No comparison available. Pass `N' to diff?