From 9433ff4f73b2717c5860a075f67c66bd1bba1bac Mon Sep 17 00:00:00 2001 From: demeritcowboy Date: Wed, 12 Oct 2022 09:26:04 -0400 Subject: [PATCH] ignore if present --- CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl index aabf417db0..f1c5306efb 100644 --- a/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl @@ -5,7 +5,7 @@ ALTER TABLE civicrm_job_log MODIFY COLUMN data LONGTEXT COMMENT 'Potential exten -- Add in missing indian states as per iso-3166-2 SELECT @indianCountryID := id FROM civicrm_country WHERE name = 'India' AND iso_code = 'IN'; -INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES +INSERT IGNORE INTO civicrm_state_province (country_id, abbreviation, name) VALUES (@indianCountryID, "LA", "Ladākh"), (@indianCountryID, "DH", "Dādra and Nagar Haveli and Damān and Diu"); -- 2.25.1