From 1ec2637ae55c60f05b5914177b781a5594efdab9 Mon Sep 17 00:00:00 2001
From: eileen <emcnaughton@wikimedia.org>
Date: Mon, 23 Dec 2019 11:32:14 +1300
Subject: [PATCH] Add index to civicrm_acl.modified_date

---
 CRM/ACL/DAO/ACLCache.php | 10 +++++++++-
 xml/schema/ACL/Cache.xml |  5 +++++
 2 files changed, 14 insertions(+), 1 deletion(-)

diff --git a/CRM/ACL/DAO/ACLCache.php b/CRM/ACL/DAO/ACLCache.php
index e18812036f..ba8d6d7018 100644
--- a/CRM/ACL/DAO/ACLCache.php
+++ b/CRM/ACL/DAO/ACLCache.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/ACL/ACLCache.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:a7bccfc35714fdcf0fdb6f4cd24842bd)
+ * (GenCodeChecksum:9428e81469c11a64dc2e7490da81a439)
  */
 
 /**
@@ -215,6 +215,14 @@ class CRM_ACL_DAO_ACLCache extends CRM_Core_DAO {
         'localizable' => FALSE,
         'sig' => 'civicrm_acl_cache::0::acl_id',
       ],
+      'index_modified_date' => [
+        'name' => 'index_modified_date',
+        'field' => [
+          0 => 'modified_date',
+        ],
+        'localizable' => FALSE,
+        'sig' => 'civicrm_acl_cache::0::modified_date',
+      ],
     ];
     return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
   }
diff --git a/xml/schema/ACL/Cache.xml b/xml/schema/ACL/Cache.xml
index 38c9df70bb..36e9123dc3 100644
--- a/xml/schema/ACL/Cache.xml
+++ b/xml/schema/ACL/Cache.xml
@@ -60,4 +60,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>
-- 
2.25.1