Merge pull request #15421 from artfulrobot/queue-safety

[civicrm-core.git] / xml / schema / Mailing / Recipients.xml

diff --git a/xml/schema/Mailing/Recipients.xml b/xml/schema/Mailing/Recipients.xml
index 188f64dbb1fa9942446e328ce1c57c0559debb19..729354c184b0a3ce1bbb7047e43bba2a6eac7f7d 100644 (file)
--- a/xml/schema/Mailing/Recipients.xml
+++ b/xml/schema/Mailing/Recipients.xml
@@ -53,7 +53,7 @@
     <name>email_id</name>
     <table>civicrm_email</table>
     <key>id</key>
-    <onDelete>CASCADE</onDelete>
+    <onDelete>SET NULL</onDelete>
   </foreignKey>
   <field>
     <name>phone_id</name>
@@ -66,6 +66,6 @@
     <name>phone_id</name>
     <table>civicrm_phone</table>
     <key>id</key>
-    <onDelete>CASCADE</onDelete>
+    <onDelete>SET NULL</onDelete>
   </foreignKey>
 </table>