From 32cdeda074f9ae1398b3fbc95f07fbf8cce417f3 Mon Sep 17 00:00:00 2001 From: ginkgoMZD Date: Mon, 2 May 2022 18:19:42 -0400 Subject: [PATCH] add missing Parishes of Bermuda (civicrm_state_province) --- .../Incremental/sql/5.50.alpha1.mysql.tpl | 14 ++++++++++++++ xml/templates/civicrm_state_province.tpl | 18 +++++++++++++++++- 2 files changed, 31 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl index 5c7cea28d1..108aea14b8 100644 --- a/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl @@ -18,3 +18,17 @@ CONSTRAINT FK_civicrm_user_job_created_id FOREIGN KEY (`created_id`) REFERENCES CONSTRAINT FK_civicrm_user_job_queue_id FOREIGN KEY (`queue_id`) REFERENCES `civicrm_queue`(`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; + +-- Add missing Parishes for Bermuda +SELECT @country_id := id from civicrm_country where name = 'Bermuda' AND iso_code = 'BM'; +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'DEV', 'Devonshire'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'HAM', 'Hamilton Parish'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'HA', 'City of Hamilton'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'PAG', 'Paget'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'PEM', 'Pembroke'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'SG', 'Town of St. George'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'SGE', 'Saint George\'s'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'SAN', 'Sandys'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'SMI', 'Smiths'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'SOU', 'Southampton'); +INSERT IGNORE INTO `civicrm_state_province` (`country_id`, `abbreviation`, `name`) VALUES (@country_id, 'WAR', 'Warwick'); diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index b4329945d6..2f344c32cf 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -4147,4 +4147,20 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (NULL, 1170, "DIN", "Dinagat Islands"), -- Add missing state for Colombia -(NULL, 1048, "HUI", "Huila"); +(NULL, 1048, "HUI", "Huila"), + +-- Add missing parishes for Bermuda + (NULL, 1023, 'DEV', 'Devonshire'), + (NULL, 1023, 'HAM', 'Hamilton Parish'), + (NULL, 1023, 'HA', 'City of Hamilton'), + (NULL, 1023, 'PAG', 'Paget'), + (NULL, 1023, 'PEM', 'Pembroke'), + (NULL, 1023, 'SG', 'Town of St. George'), + (NULL, 1023, 'SGE', 'Saint George\'s'), + (NULL, 1023, 'SAN', 'Sandys'), + (NULL, 1023, 'SMI', 'Smiths'), + (NULL, 1023, 'SOU', 'Southampton'), + (NULL, 1023, 'WAR', 'Warwick') + + -- end of statement: + ; -- 2.25.1