From 5c3d289a10d76e2853b8bdd9003c43c69b6c5bf8 Mon Sep 17 00:00:00 2001 From: Jakub MacArthur Date: Thu, 19 Jan 2023 10:16:24 +0100 Subject: [PATCH] luxembourg-provinces added check for country ID --- CRM/Upgrade/Incremental/sql/5.59.alpha1.mysql.tpl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/5.59.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.59.alpha1.mysql.tpl index af3abf96a2..0e171395f5 100644 --- a/CRM/Upgrade/Incremental/sql/5.59.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.59.alpha1.mysql.tpl @@ -10,7 +10,7 @@ INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'RM', 'Remich'); INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'VD', 'Vianden'); INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'WI', 'Wiltz'); -UPDATE `civicrm_state_province` SET abbreviation = 'LU' WHERE name = 'Luxembourg'; -UPDATE `civicrm_state_province` SET abbreviation = 'DI' WHERE name = 'Diekirch'; -UPDATE `civicrm_state_province` SET name = 'Grevenmacher' WHERE name = 'GreveNmacher'; -UPDATE `civicrm_state_province` SET abbreviation = 'GR' WHERE name = 'Grevenmacher'; +UPDATE `civicrm_state_province` SET abbreviation = 'LU' WHERE name = 'Luxembourg' AND country_id = @country_id; +UPDATE `civicrm_state_province` SET abbreviation = 'DI' WHERE name = 'Diekirch' AND country_id = @country_id; +UPDATE `civicrm_state_province` SET name = 'Grevenmacher' WHERE name = 'GreveNmacher' AND country_id = @country_id; +UPDATE `civicrm_state_province` SET abbreviation = 'GR' WHERE name = 'Grevenmacher' AND country_id = @country_id; -- 2.25.1