From 3ebeaf7c3dd4c0674ceacbf72b647b1cc8782c26 Mon Sep 17 00:00:00 2001 From: crusonweb Date: Sat, 14 Jun 2014 09:31:44 -0400 Subject: [PATCH] Update 4.5.alpha2.mysql.tpl CRM-14843 - Add two missing regions for Chile (Los Rios and Arica y Parinacota) and update the name for Region Metropolitana de Santiago to Santiago Matropolitan for consistency. --- CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl index 09c0ab67de..42e888c1cb 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl @@ -13,3 +13,12 @@ UPDATE civicrm_dashboard UPDATE civicrm_dashboard SET civicrm_dashboard.fullscreen_url = CONCAT(SUBSTRING(fullscreen_url FROM 1 FOR LOCATE('&', fullscreen_url) - 1), '?', SUBSTRING(fullscreen_url FROM LOCATE('&', fullscreen_url) + 1)) WHERE civicrm_dashboard.fullscreen_url LIKE "%&%" AND civicrm_dashboard.fullscreen_url NOT LIKE "%?%"; + +-- CRM-14843 Added States for Chile and Modify Santiago Metropolitan for consistency +INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES + (NULL, 1044, "LR", "Los Rios"), + (NULL, 1044, "AP", "Arica y Parinacota"); + +UPDATE civicrm_state_province + SET name = "Santiago Metropolitan", abbreviation = "SM" + WHERE id = "2100"; -- 2.25.1