projects
/
civicrm-core.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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>
<name>email_id</name>
<table>civicrm_email</table>
<key>id</key>
- <onDelete>
CASCADE
</onDelete>
+ <onDelete>
SET NULL
</onDelete>
</foreignKey>
<field>
<name>phone_id</name>
</foreignKey>
<field>
<name>phone_id</name>
@@
-66,6
+66,6
@@
<name>phone_id</name>
<table>civicrm_phone</table>
<key>id</key>
<name>phone_id</name>
<table>civicrm_phone</table>
<key>id</key>
- <onDelete>
CASCADE
</onDelete>
+ <onDelete>
SET NULL
</onDelete>
</foreignKey>
</table>
</foreignKey>
</table>