From b56d80647ddf8be8b156c5cf95a0d279efbbe013 Mon Sep 17 00:00:00 2001 From: Dave Greenberg Date: Wed, 29 Jul 2015 16:27:10 -0700 Subject: [PATCH] CRM-16876 Set country names to UPPERCASE - rebasing. ---------------------------------------- * CRM-16876: Display Country in uppercase so that mailing labels comply with postal regulations https://issues.civicrm.org/jira/browse/CRM-16876 --- CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl index 238daaf4f2..3de4e3b9a5 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl @@ -35,3 +35,6 @@ ALTER TABLE civicrm_payment_processor_type ADD COLUMN `payment_instrument_id` int unsigned DEFAULT 1 COMMENT 'Payment Instrument ID'; +-- CRM-16876 Set country names to UPPERCASE +UPDATE civicrm_country SET `name` = UPPER( `name` ); + -- 2.25.1