Merge pull request #4223 from atif-shaikh/CRM-15366

[civicrm-core.git] / xml / templates / civicrm_state_province.tpl

diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl
index fa6913ab685bab4cb14d317c9fe00e487101df8a..c643bd3aff300f4ba0e72c3c1495c00c853a89ee 100644 (file)
--- a/xml/templates/civicrm_state_province.tpl
+++ b/xml/templates/civicrm_state_province.tpl
@@ -1,7 +1,7 @@
 -- +--------------------------------------------------------------------+
--- | CiviCRM version 4.3                                                |
+-- | CiviCRM version 4.5                                                |
 -- +--------------------------------------------------------------------+
--- | Copyright CiviCRM LLC (c) 2004-2013                                |
+-- | Copyright CiviCRM LLC (c) 2004-2014                                |
 -- +--------------------------------------------------------------------+
 -- | This file is a part of CiviCRM.                                    |
 -- |                                                                    |
@@ -733,7 +733,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (2097, 1044, "LL", "Los Lagos"),
 (2098, 1044, "MA", "Magallanes"),
 (2099, 1044, "ML", "Maule"),
-(2100, 1044, "RM", "Region Metropolitana de Santiago"),
+(2100, 1044, "SM", "Santiago Metropolitan"),
 (2101, 1044, "TA", "Tarapaca"),
 (2102, 1044, "VS", "Valparaiso"),
 (2103, 1038, "AD", "Adamaoua"),
@@ -1412,8 +1412,8 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (2927, 1085, "72", "Xanthi"),
 (2928, 1085, "21", "Zakynthos"),
 (2929, 1085, "69", "Agio Oros"),
-(2930, 1090, "AV", "Alta Verapez"),
-(2931, 1090, "BV", "Baja Verapez"),
+(2930, 1090, "AV", "Alta Verapaz"),
+(2931, 1090, "BV", "Baja Verapaz"),
 (2932, 1090, "CM", "Chimaltenango"),
 (2933, 1090, "CQ", "Chiquimula"),
 (2934, 1090, "PR", "El Progreso"),
@@ -1426,11 +1426,11 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (2941, 1090, "PE", "Peten"),
 (2942, 1090, "QZ", "Quetzaltenango"),
 (2943, 1090, "QC", "Quiche"),
-(2944, 1090, "RE", "Reta.thuleu"),
+(2944, 1090, "RE", "Retalhuleu"),
 (2945, 1090, "SA", "Sacatepequez"),
 (2946, 1090, "SM", "San Marcos"),
 (2947, 1090, "SR", "Santa Rosa"),
-(2948, 1090, "SO", "Solol6"),
+(2948, 1090, "SO", "Sololá"),
 (2949, 1090, "SU", "Suchitepequez"),
 (2950, 1090, "TO", "Totonicapan"),
 (2951, 1090, "ZA", "Zacapa"),
@@ -2338,7 +2338,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (3879, 1156, "S", "Tahoua"),
 (3880, 1156, "6", "Tillaberi"),
 (3881, 1156, "7", "Zinder"),
-(3882, 1157, "FC", "Abuja Capital Territory"),
+(3882, 1157, "FC", "Abuja Federal Capital Territory"),
 (3883, 1157, "AB", "Abia"),
 (3884, 1157, "AD", "Adamawa"),
 (3885, 1157, "AK", "Akwa Ibom"),
@@ -2407,7 +2407,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (3948, 1161, "20", "Finnmark"),
 (3949, 1161, "04", "Hedmark"),
 (3950, 1161, "12", "Hordaland"),
-(3951, 1161, "15", "Møre ag Romsdal"),
+(3951, 1161, "15", "Møre og Romsdal"),
 (3952, 1161, "18", "Nordland"),
 (3953, 1161, "17", "Nord-Trøndelag"),
 (3954, 1161, "05", "Oppland"),
@@ -2435,7 +2435,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (3976, 1154, "STL", "Southland"),
 (3977, 1154, "TKI", "Taranaki"),
 (3978, 1154, "TAS", "Tasman"),
-(3979, 1154, "WKO", "waikato"),
+(3979, 1154, "WKO", "Waikato"),
 (3980, 1154, "WGN", "Wellington"),
 (3981, 1154, "WTC", "West Coast"),
 (3982, 1162, "DA", "Ad Dakhillyah"),
@@ -2703,12 +2703,12 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4244, 1177, "BEL", "Belgorodskaya oblast\'"),
 (4245, 1177, "BRY", "Bryanskaya oblast\'"),
 (4246, 1177, "CHE", "Chelyabinskaya oblast\'"),
-(4247, 1177, "CHI", "Chitinskaya oblast\'"),
+(4247, 1177, "ZSK", "Zabaykalsky Krai\'"),
 (4248, 1177, "IRK", "Irkutskaya oblast\'"),
 (4249, 1177, "IVA", "Ivanovskaya oblast\'"),
 (4250, 1177, "KGD", "Kaliningradskaya oblast\'"),
 (4251, 1177, "KLU", "Kaluzhskaya oblast\'"),
-(4252, 1177, "KAM", "Kamchatskaya oblast\'"),
+(4252, 1177, "KAM", "Kamchatka Krai\'"),
 (4253, 1177, "KEM", "Kemerovskaya oblast\'"),
 (4254, 1177, "KIR", "Kirovskaya oblast\'"),
 (4255, 1177, "KOS", "Kostromskaya oblast\'"),
@@ -2726,7 +2726,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4267, 1177, "ORE", "Orenburgskaya oblast\'"),
 (4268, 1177, "ORL", "Orlovskaya oblast\'"),
 (4269, 1177, "PNZ", "Penzenskaya oblast\'"),
-(4270, 1177, "PER", "Permskaya oblast\'"),
+(4270, 1177, "PEK", "Perm krai\'"),
 (4271, 1177, "PSK", "Pskovskaya oblast\'"),
 (4272, 1177, "ROS", "Rostovskaya oblast\'"),
 (4273, 1177, "RYA", "Ryazanskaya oblast\'"),
@@ -2749,15 +2749,9 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4290, 1177, "MOW", "Moskva"),
 (4291, 1177, "SPE", "Sankt-Peterburg"),
 (4292, 1177, "YEV", "Yevreyskaya avtonomnaya oblast\'"),
-(4293, 1177, "AGB", "Aginskiy Buryatskiy avtonomnyy"),
 (4294, 1177, "CHU", "Chukotskiy avtonomnyy okrug"),
-(4295, 1177, "EVE", "Evenkiyskiy avtonomnyy okrug"),
 (4296, 1177, "KHM", "Khanty-Mansiyskiy avtonomnyy okrug"),
-(4297, 1177, "KOP", "Komi-Permyatskiy avtonomnyy okrug"),
-(4298, 1177, "KOR", "Koryakskiy avtonomnyy okrug"),
 (4299, 1177, "NEN", "Nenetskiy avtonomnyy okrug"),
-(4300, 1177, "TAY", "Taymyrskiy (Dolgano-Nenetskiy)"),
-(4301, 1177, "UOB", "Ust\'-Ordynskiy Buryatskiy"),
 (4302, 1177, "YAN", "Yamalo-Nenetskiy avtonomnyy okrug"),
 (4303, 1178, "C", "Butare"),
 (4304, 1178, "I", "Byumba"),
@@ -3696,7 +3690,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (9993, 1226, "BRK", "Berkshire"),
 (9994, 1226, "WMD", "West Midlands"),
 (9998, 1226, "WGM", "West Glamorgan"),
-(9999, 1226, "LON", "Greater London"),
+(9999, 1226, "LON", "London"),
 
 (10000, 1107, "CI", "Carbonia-Iglesias"),
 (10001, 1107, "OT", "Olbia-Tempio"),
@@ -3898,4 +3892,23 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (NULL, 1119, "064", "Naukšēnu novads"),
 (NULL, 1119, "106", "Ventspils novads"),
 (NULL, 1119, "JKB", "Jēkabpils"),
-(NULL, 1119, "VMR", "Valmiera");
\ No newline at end of file
+(NULL, 1119, "VMR", "Valmiera"),
+
+-- CRM-13314 Added States for Uruguay
+(NULL, 1229, "FL", "Florida"),
+(NULL, 1229, "RN", "Rio Negro"),
+(NULL, 1229, "SJ", "San Jose"),
+
+-- Added Nigeria States(CRM-14183)
+(NULL, 1157, "PL", "Plateau"),
+
+
+-- CRM-14493 Added State for Greece
+(NULL, 1085, "61", "Pieria"),
+
+-- CRM-14843 Added States for Chile and Modify Santiago Metropolitan for consistency
+(NULL, 1044, "LR", "Los Rios"),
+(NULL, 1044, "AP", "Arica y Parinacota"),
+
+-- Add missing Peruvian State (Amazonas)
+(NULL, 1169, "AMA", "Amazonas");