From 4edfa3eafe960e468cfdb9f3bf95de956ea2dc70 Mon Sep 17 00:00:00 2001
From: eileen <emcnaughton@wikimedia.org>
Date: Thu, 31 Dec 2020 10:14:23 +1300
Subject: [PATCH] Add index to campaign.name

---
 CRM/Campaign/DAO/Campaign.php    | 10 +++++++++-
 xml/schema/Campaign/Campaign.xml |  6 +++++-
 2 files changed, 14 insertions(+), 2 deletions(-)

diff --git a/CRM/Campaign/DAO/Campaign.php b/CRM/Campaign/DAO/Campaign.php
index caa08bdaf1..69092b2960 100644
--- a/CRM/Campaign/DAO/Campaign.php
+++ b/CRM/Campaign/DAO/Campaign.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/Campaign/Campaign.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:c86618236efd91af786b98c3f359e321)
+ * (GenCodeChecksum:4de7a73b3f3921098ac11b6d5acee061)
  */
 
 /**
@@ -578,6 +578,14 @@ class CRM_Campaign_DAO_Campaign extends CRM_Core_DAO {
    */
   public static function indices($localize = TRUE) {
     $indices = [
+      'UI_campaign_name' => [
+        'name' => 'UI_campaign_name',
+        'field' => [
+          0 => 'name',
+        ],
+        'localizable' => FALSE,
+        'sig' => 'civicrm_campaign::0::name',
+      ],
       'UI_campaign_type_id' => [
         'name' => 'UI_campaign_type_id',
         'field' => [
diff --git a/xml/schema/Campaign/Campaign.xml b/xml/schema/Campaign/Campaign.xml
index 19d5df80b9..99f1c19cf3 100644
--- a/xml/schema/Campaign/Campaign.xml
+++ b/xml/schema/Campaign/Campaign.xml
@@ -39,7 +39,11 @@
     </html>
     <add>3.3</add>
   </field>
-
+  <index>
+    <name>UI_campaign_name</name>
+    <fieldName>name</fieldName>
+    <add>5.34</add>
+  </index>
   <field>
     <name>title</name>
     <title>Campaign Title</title>
-- 
2.25.1