Index: openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql,v diff -u -N -r1.14 -r1.15 --- openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql 17 Feb 2018 17:08:31 -0000 1.14 +++ openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql 8 Mar 2018 11:09:02 -0000 1.15 @@ -406,13 +406,16 @@ msg_id text primary key, package_id integer constraint aml_package_id_fk - references apm_packages, + references apm_packages + on delete cascade, party_id integer constraint aml_from_external_party_id_fk - references parties (party_id), + references parties (party_id) + on delete cascade, object_id integer constraint aml_from_external_obect_id_fk - references acs_objects (object_id), + references acs_objects (object_id) + on delete cascade, -- Indicate approximate time when this email is created datetime_cs integer, -- other data or parameters to associate with email