Merge pull request #17079 from yashodha/dev-1704
[civicrm-core.git] / xml / schema / ACL / Cache.xml
index 38c9df70bb819a94e7efe151c0ee1da9912ed3f8..869eadb96189744be50660dfdd48f49ffabca427 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>
     <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>
@@ -60,4 +68,9 @@
     <comment>When was this cache entry last modified</comment>
     <add>1.6</add>
   </field>
+  <index>
+    <name>index_modified_date</name>
+    <fieldName>modified_date</fieldName>
+    <add>5.22</add>
+  </index>
 </table>