Mwalker has submitted this change and it was merged.
Change subject: add keys to civicrm_entity_tag
......................................................................
add keys to civicrm_entity_tag
Change-Id: Id57af4da8d37be18dbc2a0b2cfde4e98ab8853d1
---
M sites/all/modules/wmf_common/wmf_civicrm/wmf_civicrm.install
1 file changed, 26 insertions(+), 0 deletions(-)
Approvals:
Mwalker: Looks good to me, approved
jenkins-bot: Verified
diff --git a/sites/all/modules/wmf_common/wmf_civicrm/wmf_civicrm.install
b/sites/all/modules/wmf_common/wmf_civicrm/wmf_civicrm.install
index ea063e6..5f5b035 100644
--- a/sites/all/modules/wmf_common/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_common/wmf_civicrm/wmf_civicrm.install
@@ -14,6 +14,8 @@
wmf_civicrm_update_6007();
wmf_civicrm_update_6008();
wmf_civicrm_update_6009();
+ wmf_civicrm_update_6010();
+ wmf_civicrm_update_6011();
}
/**
@@ -507,3 +509,27 @@
db_query("ALTER TABLE civicrm_address
MODIFY postal_code varchar(64) DEFAULT NULL");
}
+
+/**
+ * Improve civicrm_entity_tag indexing--DO NOT RUN ON PRODUCTION
+ */
+function wmf_civicrm_update_6010()
+{
+ $dbs = wmf_civicrm_get_dbs();
+ $dbs->push('civicrm');
+
+ db_query("ALTER TABLE civicrm_entity_tag
+ ADD KEY entity_id (entity_id)");
+}
+
+/**
+ * Improve civicrm_entity_tag indexing
+ */
+function wmf_civicrm_update_6011()
+{
+ $dbs = wmf_civicrm_get_dbs();
+ $dbs->push('civicrm');
+
+ db_query("ALTER TABLE civicrm_entity_tag
+ ADD KEY entity_table (entity_table)");
+}
--
To view, visit https://gerrit.wikimedia.org/r/92456
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Id57af4da8d37be18dbc2a0b2cfde4e98ab8853d1
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Adamw <[email protected]>
Gerrit-Reviewer: Adamw <[email protected]>
Gerrit-Reviewer: Katie Horn <[email protected]>
Gerrit-Reviewer: Mwalker <[email protected]>
Gerrit-Reviewer: jenkins-bot
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
