Merge pull request #17174 from pradpnayak/ruleTitle
[civicrm-core.git] / xml / schema / Dedupe / Exception.xml
index f5f095cdc8dfe844d53c3537f540a4e1f21ad9e4..77afb22248115e9cfd10492dbad333738bfbbe8c 100644 (file)
@@ -7,6 +7,7 @@
   <add>3.3</add>
   <field>
     <name>id</name>
+    <title>Dedupe Exception ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Unique dedupe exception id</comment>
     <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>contact_id1</name>
-      <title>First Dupe Contact ID</title>
-      <type>int unsigned</type>
-      <comment>FK to Contact ID</comment>
-      <add>3.3</add>
+    <name>contact_id1</name>
+    <title>First Dupe Contact ID</title>
+    <type>int unsigned</type>
+    <comment>FK to Contact ID</comment>
+    <add>3.3</add>
+    <required>TRUE</required>
   </field>
   <foreignKey>
-       <name>contact_id1</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>3.3</add>
-       <onDelete>CASCADE</onDelete>
+    <name>contact_id1</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>3.3</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>contact_id2</name>
-      <title>Second Dupe Contact ID</title>
-      <type>int unsigned</type>
-      <comment>FK to Contact ID</comment>
-      <add>3.3</add>
+    <name>contact_id2</name>
+    <title>Second Dupe Contact ID</title>
+    <type>int unsigned</type>
+    <comment>FK to Contact ID</comment>
+    <add>3.3</add>
+    <required>TRUE</required>
   </field>
   <foreignKey>
-       <name>contact_id2</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>3.3</add>
-       <onDelete>CASCADE</onDelete>
+    <name>contact_id2</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>3.3</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <index>
-     <name>UI_contact_id1_contact_id2</name>
-     <fieldName>contact_id1</fieldName>
-     <fieldName>contact_id2</fieldName>
-     <unique>true</unique>
-     <add>3.3</add>
+    <name>UI_contact_id1_contact_id2</name>
+    <fieldName>contact_id1</fieldName>
+    <fieldName>contact_id2</fieldName>
+    <unique>true</unique>
+    <add>3.3</add>
   </index>
  </table>