projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Add html tag to all files in xml/schema
[civicrm-core.git] / xml / schema / Mailing / Recipients.xml
diff --git a/xml/schema/Mailing/Recipients.xml b/xml/schema/Mailing/Recipients.xml
index 188f64dbb1fa9942446e328ce1c57c0559debb19..e909c87994b33f62dd08b3080047c05e4fb46e51 100644 (file)
--- a/xml/schema/Mailing/Recipients.xml
+++ b/xml/schema/Mailing/Recipients.xml
@@ -6,11 +6,17 @@
   <name>civicrm_mailing_recipients</name>
   <comment>Stores information about the recipients of a mailing.</comment>
   <archive>true</archive>
+  <component>CiviMail</component>
+  <title>Recipient</title>
+  <titlePlural>Recipients</titlePlural>
   <field>
     <name>id</name>
     <title>Mailing Recipients ID</title>
     <type>int unsigned</type>
     <required>true</required>
+    <html>
+      <type>Number</type>
+    </html>
   </field>
   <primaryKey>
     <name>id</name>
@@ -53,7 +59,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 +72,6 @@
     <name>phone_id</name>
     <table>civicrm_phone</table>
     <key>id</key>
-    <onDelete>CASCADE</onDelete>
+    <onDelete>SET NULL</onDelete>
   </foreignKey>
 </table>