[MediaWiki-commits] [Gerrit] wikimedia...crm[master]: Add Index to contact.preferred_language

2016-09-21 Thread jenkins-bot (Code Review) 
jenkins-bot has submitted this change and it was merged.

Change subject: Add Index to contact.preferred_language
..


Add Index to contact.preferred_language

CRM-19350

Bug: T96410
Change-Id: If686ad6e20c2906221bc0b8c989ee2d913ad11e2
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
1 file changed, 10 insertions(+), 0 deletions(-)

Approvals:
  Ejegg: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install 
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index 9aeb973..ae26008 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -2213,3 +2213,13 @@
 )
   ");
 }
+
+/**
+ * T128221 add index to civicrm_contribution.total_amount.
+ *
+ * Bug: T96410
+ */
+function wmf_civicrm_update_7255() {
+  civicrm_initialize();
+  CRM_Core_BAO_SchemaHandler::createIndexes(array('civicrm_contact' => 
array('preferred_language')));
+}

-- 
To view, visit https://gerrit.wikimedia.org/r/310192
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: If686ad6e20c2906221bc0b8c989ee2d913ad11e2
Gerrit-PatchSet: 7
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Eileen 
Gerrit-Reviewer: Awight 
Gerrit-Reviewer: Cdentinger 
Gerrit-Reviewer: Eileen 
Gerrit-Reviewer: Ejegg 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] wikimedia...crm[master]: Add Index to contact.preferred_language

2016-09-12 Thread Eileen (Code Review) 
Eileen has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/310192

Change subject: Add Index to contact.preferred_language
..

Add Index to contact.preferred_language

CRM-19350

Bug: T96410
Change-Id: If686ad6e20c2906221bc0b8c989ee2d913ad11e2
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
1 file changed, 26 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm 
refs/changes/92/310192/1

diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install 
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index 1d84e5b..5ab003f 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -2188,3 +2188,29 @@
   civicrm_initialize();
   CRM_Core_DAO::executeQuery("DELETE FROM civicrm_email WHERE email = 
'nob...@wikimedia.org'");
 }
+
+/**
+ * T128221 add index to civicrm_contribution.total_amount.
+ *
+ * Bug: T96410
+ */
+function wmf_civicrm_update_7250() {
+  civicrm_initialize();
+  CRM_Core_BAO_SchemaHandler::createIndexes(array('civicrm_contact' => 
array('preferred_language')));
+}
+
+/**
+ * Clean up legacy junk data from preferred_language field.
+ *
+ * This nulls out '_' junk data string (19690 rows)
+ * and changes '_US' to 'en_US' (which is implied) (25387 rows).
+ *
+ * CRM-19350
+ *
+ * Bug: T96410
+ */
+function wmf_civicrm_update_7255() {
+  civicrm_initialize();
+  CRM_Core_DAO::executeQuery("UPDATE civicrm_contact SET preferred_language = 
NULL WHERE preferred_language = '_'");
+  CRM_Core_DAO::executeQuery("UPDATE civicrm_contact SET preferred_language = 
'en_US' WHERE preferred_language = '_US'");
+}

-- 
To view, visit https://gerrit.wikimedia.org/r/310192
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: If686ad6e20c2906221bc0b8c989ee2d913ad11e2
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Eileen 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits