-- +--------------------------------------------------------------------+
--- | 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. |
-- | |
-- | GNU Affero General Public License or the licensing of CiviCRM, |
-- | see the CiviCRM license FAQ at http://civicrm.org/licensing |
-- +--------------------------------------------------------------------+
+--
+-- Generated from {$smarty.template}
+-- {$generated}
+--
/*!40101 SET NAMES utf8 */;
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"),
(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"),
(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"),
(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"),
(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"),
(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"),
(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\'"),
(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\'"),
(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"),
(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"),
(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");