jenkins-bot has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/334236 )
Change subject: Add index to nick_name field.
......................................................................
Add index to nick_name field.
Bug: T115044
Change-Id: I86b1e82503f71636c74de984c1595b84ec723caa
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
1 file changed, 16 insertions(+), 0 deletions(-)
Approvals:
jenkins-bot: Verified
Ejegg: Looks good to me, approved
diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index 96d1c9a..80f6a23 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -2482,3 +2482,19 @@
wmf_civicrm_update_7310();
wmf_civicrm_update_7320();
}
+
+/**
+ * Add index to nick_name column as we have decided to use it for imports.
+ *
+ * We have decided the Benevity Import should accept org matches on nick_name
+ * or organization_name in order to provide the option to refer to them with
+ * 2 names. In order to use it it must be indexed. Note that I believe the
index size
+ * is relative to the number of values in it (currently a few hundred).
+ *
+ * Bug: T115044
+ */
+function wmf_civicrm_update_7455() {
+ civicrm_initialize();
+ $tables = array('civicrm_contact' => array('nick_name'));
+ CRM_Core_BAO_SchemaHandler::createIndexes($tables);
+}
--
To view, visit https://gerrit.wikimedia.org/r/334236
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I86b1e82503f71636c74de984c1595b84ec723caa
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Eileen <emcnaugh...@wikimedia.org>
Gerrit-Reviewer: Awight <awi...@wikimedia.org>
Gerrit-Reviewer: Cdentinger <cdentin...@wikimedia.org>
Gerrit-Reviewer: Eileen <emcnaugh...@wikimedia.org>
Gerrit-Reviewer: Ejegg <eeggles...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
