projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Merge pull request #17656 from civicrm/5.27
[civicrm-core.git] / xml / schema / Case / CaseContact.xml
diff --git a/xml/schema/Case/CaseContact.xml b/xml/schema/Case/CaseContact.xml
index 43c83100954a9df49228a4233aa2220e6be1acc0..f4ae08f187057818e9da408d2394218b82135403 100644 (file)
--- a/xml/schema/Case/CaseContact.xml
+++ b/xml/schema/Case/CaseContact.xml
@@ -8,6 +8,7 @@
   <log>true</log>
   <field>
     <name>id</name>
+    <title>Case Contact ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Unique case-contact association id</comment>
@@ -19,6 +20,7 @@
   </primaryKey>
   <field>
     <name>case_id</name>
+    <title>Case</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Case ID of case-contact association.</comment>
@@ -32,27 +34,28 @@
     <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>contact_id</name>
-      <type>int unsigned</type>
-      <uniqueName>case_contact_id</uniqueName>
-      <required>true</required>
-      <comment>Contact ID of contact record given case belongs to.</comment>
-      <html>
-        <type>EntityRef</type>
-      </html>
-      <add>2.1</add>
+    <name>contact_id</name>
+    <title>Contact ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>Contact ID of contact record given case belongs to.</comment>
+    <html>
+      <type>EntityRef</type>
+    </html>
+    <add>2.1</add>
   </field>
   <foreignKey>
-       <name>contact_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>2.1</add>
-       <onDelete>CASCADE</onDelete>
+    <name>contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>2.1</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <index>
     <name>UI_case_contact_id</name>
     <fieldName>case_id</fieldName>
     <fieldName>contact_id</fieldName>
+    <unique>true</unique>
     <add>2.1</add>
   </index>
 </table>