From b986bcd5b59ef5f516e2f7a94044c9c97481e961 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Sun, 19 Apr 2020 18:39:50 +0100 Subject: [PATCH] Update Colmbra state/province to Coimbra --- CRM/Upgrade/Incremental/sql/5.26.alpha1.mysql.tpl | 7 +++++++ xml/templates/civicrm_state_province.tpl | 2 +- 2 files changed, 8 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/5.26.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.26.alpha1.mysql.tpl index c0277ba54f..603c20132e 100644 --- a/CRM/Upgrade/Incremental/sql/5.26.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.26.alpha1.mysql.tpl @@ -2,3 +2,10 @@ UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL; ALTER TABLE civicrm_contact MODIFY COLUMN is_deceased TINYINT NOT NULL DEFAULT 0; + +-- Update Colmbra state/province to Coimbra +UPDATE civicrm_state_province s + INNER JOIN civicrm_country c + on c.id = s.country_id AND c.name = 'Portugal' + AND s.name = 'Colmbra' +SET s.name = 'Coimbra'; diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index d1755bb0c2..4fbf67a3dd 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -2568,7 +2568,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (4128, 1173, "03", "Braga"), (4129, 1173, "04", "Braganca"), (4130, 1173, "05", "Castelo Branco"), -(4131, 1173, "06", "Colmbra"), +(4131, 1173, "06", "Coimbra"), (4132, 1173, "07", "Ovora"), (4133, 1173, "08", "Faro"), (4134, 1173, "09", "Guarda"), -- 2.25.1