Merge pull request #18478 from seamuslee001/api_v4_fin_acl_test
[civicrm-core.git] / xml / schema / ACL / Cache.xml
index 36e9123dc337054b30afab0416b850652eac0208..8b54897737aecde817c4d499b65cfa57a1b1b39e 100644 (file)
@@ -23,6 +23,9 @@
     <title>Cache Contact</title>
     <type>int unsigned</type>
     <comment>Foreign Key to Contact</comment>
+    <html>
+      <type>EntityRef</type>
+    </html>
     <add>1.6</add>
   </field>
   <foreignKey>
     <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>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Foreign Key to ACL</comment>
+    <pseudoconstant>
+      <table>civicrm_acl</table>
+      <keyColumn>id</keyColumn>
+      <labelColumn>name</labelColumn>
+    </pseudoconstant>
     <add>1.6</add>
   </field>
   <foreignKey>