CRM-17016 -- State list for Fiji incomplete

[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.6.7.mysql.tpl

diff --git a/CRM/Upgrade/Incremental/sql/4.6.7.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.7.mysql.tpl
index 3371bfaf0f2ec578c448cc5ab414d594e915bcd5..665f8dcf9fe5a5828d3e3314dfa54c711504ef66 100644 (file)
--- a/CRM/Upgrade/Incremental/sql/4.6.7.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.6.7.mysql.tpl
@@ -1 +1,5 @@
 {* file to handle db changes in 4.6.7 during upgrade *}
+
+-- CRM-17016 State list for Fiji incomplete
+SELECT @country_id := id from civicrm_country where name = 'Fiji' AND iso_code = 'FJ';
+INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (@country_id, "C", "Central");