Merge pull request #18158 from mattwire/createProfileContact
[civicrm-core.git] / xml / schema / ACL / Cache.xml
index 869eadb96189744be50660dfdd48f49ffabca427..9de0714950ab106bbe8e0dd32a8705ddcfacc506 100644 (file)
@@ -12,6 +12,9 @@
     <type>int unsigned</type>
     <required>true</required>
     <comment>Unique table ID</comment>
+    <html>
+      <type>Number</type>
+    </html>
     <add>1.6</add>
   </field>
   <primaryKey>
   </primaryKey>
   <field>
     <name>contact_id</name>
-    <title>Cache Contact</title>
+    <title>Contact ID</title>
     <type>int unsigned</type>
     <comment>Foreign Key to Contact</comment>
     <html>
       <type>EntityRef</type>
+      <label>Contact</label>
     </html>
     <add>1.6</add>
   </field>
     <table>civicrm_contact</table>
     <key>id</key>
     <add>1.6</add>
+    <drop>5.31</drop>
     <onDelete>CASCADE</onDelete>
   </foreignKey>
+  <index>
+    <name>index_contact_id</name>
+    <fieldName>contact_id</fieldName>
+    <add>5.31</add>
+  </index>
   <field>
     <name>acl_id</name>
-    <title>Cache ACL</title>
+    <title>ACL ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Foreign Key to ACL</comment>
@@ -46,6 +56,9 @@
       <keyColumn>id</keyColumn>
       <labelColumn>name</labelColumn>
     </pseudoconstant>
+    <html>
+      <label>ACL</label>
+    </html>
     <add>1.6</add>
   </field>
   <foreignKey>