#

# * Country/Zones Zen Cart SQL Load for MySQL databases

# * @package Installer

# * @access private

# * @copyright Copyright 2003-2012 Zen Cart Development Team

# * @copyright Portions Copyright 2003 osCommerce

# * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

# * @version GIT: $Id: Author: DrByte  Wed Jul 18 16:51:48 2012 -0400 Modified in v1.5.1 $

#

# NOTE: UTF8 files need to be saved with encoding format set to UTF8-without-BOM.

#

 

 

## SQL Sections Specific to UTF8 character set

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Convert currencies for Text emails', 'CURRENCIES_TRANSLATIONS', '', 'What currency conversions do you need for Text emails?<br />Example = &amp;pound;,&pound;:&amp;euro;,&euro;', 12, 120, NULL, '2003-11-21 00:00:00', NULL, 'zen_cfg_textarea_small(');

 

INSERT INTO countries VALUES (240,'Aaland Islands','AX','ALA','1');

INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1');

INSERT INTO countries VALUES (2,'Albania','AL','ALB','1');

INSERT INTO countries VALUES (3,'Algeria','DZ','DZA','1');

INSERT INTO countries VALUES (4,'American Samoa','AS','ASM','1');

INSERT INTO countries VALUES (5,'Andorra','AD','AND','1');

INSERT INTO countries VALUES (6,'Angola','AO','AGO','1');

INSERT INTO countries VALUES (7,'Anguilla','AI','AIA','1');

INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA','1');

INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG','1');

INSERT INTO countries VALUES (10,'Argentina','AR','ARG','1');

INSERT INTO countries VALUES (11,'Armenia','AM','ARM','1');

INSERT INTO countries VALUES (12,'Aruba','AW','ABW','1');

INSERT INTO countries VALUES (13,'Australia','AU','AUS','1');

INSERT INTO countries VALUES (14,'Austria','AT','AUT','5');

INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE','1');

INSERT INTO countries VALUES (16,'Bahamas','BS','BHS','1');

INSERT INTO countries VALUES (17,'Bahrain','BH','BHR','1');

INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD','1');

INSERT INTO countries VALUES (19,'Barbados','BB','BRB','1');

INSERT INTO countries VALUES (20,'Belarus','BY','BLR','1');

INSERT INTO countries VALUES (21,'Belgium','BE','BEL','1');

INSERT INTO countries VALUES (22,'Belize','BZ','BLZ','1');

INSERT INTO countries VALUES (23,'Benin','BJ','BEN','1');

INSERT INTO countries VALUES (24,'Bermuda','BM','BMU','1');

INSERT INTO countries VALUES (25,'Bhutan','BT','BTN','1');

INSERT INTO countries VALUES (26,'Bolivia','BO','BOL','1');

INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1');

INSERT INTO countries VALUES (28,'Botswana','BW','BWA','1');

INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT','1');

INSERT INTO countries VALUES (30,'Brazil','BR','BRA','1');

INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1');

INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN','1');

INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR','1');

INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA','1');

INSERT INTO countries VALUES (35,'Burundi','BI','BDI','1');

INSERT INTO countries VALUES (36,'Cambodia','KH','KHM','1');

INSERT INTO countries VALUES (37,'Cameroon','CM','CMR','1');

INSERT INTO countries VALUES (38,'Canada','CA','CAN','2');

INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV','1');

INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM','1');

INSERT INTO countries VALUES (41,'Central African Republic','CF','CAF','1');

INSERT INTO countries VALUES (42,'Chad','TD','TCD','1');

INSERT INTO countries VALUES (43,'Chile','CL','CHL','1');

INSERT INTO countries VALUES (44,'China','CN','CHN','1');

INSERT INTO countries VALUES (45,'Christmas Island','CX','CXR','1');

INSERT INTO countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','1');

INSERT INTO countries VALUES (47,'Colombia','CO','COL','1');

INSERT INTO countries VALUES (48,'Comoros','KM','COM','1');

INSERT INTO countries VALUES (49,'Congo','CG','COG','1');

INSERT INTO countries VALUES (50,'Cook Islands','CK','COK','1');

INSERT INTO countries VALUES (51,'Costa Rica','CR','CRI','1');

INSERT INTO countries VALUES (52,'Cote D\'Ivoire','CI','CIV','1');

INSERT INTO countries VALUES (53,'Croatia','HR','HRV','1');

INSERT INTO countries VALUES (54,'Cuba','CU','CUB','1');

INSERT INTO countries VALUES (55,'Cyprus','CY','CYP','1');

INSERT INTO countries VALUES (56,'Czech Republic','CZ','CZE','1');

INSERT INTO countries VALUES (57,'Denmark','DK','DNK','1');

INSERT INTO countries VALUES (58,'Djibouti','DJ','DJI','1');

INSERT INTO countries VALUES (59,'Dominica','DM','DMA','1');

INSERT INTO countries VALUES (60,'Dominican Republic','DO','DOM','1');

INSERT INTO countries VALUES (61,'Timor-Leste','TL','TLS','1');

INSERT INTO countries VALUES (62,'Ecuador','EC','ECU','1');

INSERT INTO countries VALUES (63,'Egypt','EG','EGY','1');

INSERT INTO countries VALUES (64,'El Salvador','SV','SLV','1');

INSERT INTO countries VALUES (65,'Equatorial Guinea','GQ','GNQ','1');

INSERT INTO countries VALUES (66,'Eritrea','ER','ERI','1');

INSERT INTO countries VALUES (67,'Estonia','EE','EST','1');

INSERT INTO countries VALUES (68,'Ethiopia','ET','ETH','1');

INSERT INTO countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','1');

INSERT INTO countries VALUES (70,'Faroe Islands','FO','FRO','1');

INSERT INTO countries VALUES (71,'Fiji','FJ','FJI','1');

INSERT INTO countries VALUES (72,'Finland','FI','FIN','1');

INSERT INTO countries VALUES (73,'France','FR','FRA','1');

INSERT INTO countries VALUES (75,'French Guiana','GF','GUF','1');

INSERT INTO countries VALUES (76,'French Polynesia','PF','PYF','1');

INSERT INTO countries VALUES (77,'French Southern Territories','TF','ATF','1');

INSERT INTO countries VALUES (78,'Gabon','GA','GAB','1');

INSERT INTO countries VALUES (79,'Gambia','GM','GMB','1');

INSERT INTO countries VALUES (80,'Georgia','GE','GEO','1');

INSERT INTO countries VALUES (81,'Germany','DE','DEU','5');

INSERT INTO countries VALUES (82,'Ghana','GH','GHA','1');

INSERT INTO countries VALUES (83,'Gibraltar','GI','GIB','1');

INSERT INTO countries VALUES (84,'Greece','GR','GRC','1');

INSERT INTO countries VALUES (85,'Greenland','GL','GRL','1');

INSERT INTO countries VALUES (86,'Grenada','GD','GRD','1');

INSERT INTO countries VALUES (87,'Guadeloupe','GP','GLP','1');

INSERT INTO countries VALUES (88,'Guam','GU','GUM','1');

INSERT INTO countries VALUES (89,'Guatemala','GT','GTM','1');

INSERT INTO countries VALUES (90,'Guinea','GN','GIN','1');

INSERT INTO countries VALUES (91,'Guinea-bissau','GW','GNB','1');

INSERT INTO countries VALUES (92,'Guyana','GY','GUY','1');

INSERT INTO countries VALUES (93,'Haiti','HT','HTI','1');

INSERT INTO countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','1');

INSERT INTO countries VALUES (95,'Honduras','HN','HND','1');

INSERT INTO countries VALUES (96,'Hong Kong','HK','HKG','1');

INSERT INTO countries VALUES (97,'Hungary','HU','HUN','1');

INSERT INTO countries VALUES (98,'Iceland','IS','ISL','1');

INSERT INTO countries VALUES (99,'India','IN','IND','1');

INSERT INTO countries VALUES (100,'Indonesia','ID','IDN','1');

INSERT INTO countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','1');

INSERT INTO countries VALUES (102,'Iraq','IQ','IRQ','1');

INSERT INTO countries VALUES (103,'Ireland','IE','IRL','1');

INSERT INTO countries VALUES (104,'Israel','IL','ISR','1');

INSERT INTO countries VALUES (105,'Italy','IT','ITA','1');

INSERT INTO countries VALUES (106,'Jamaica','JM','JAM','1');

INSERT INTO countries VALUES (107,'Japan','JP','JPN','1');

INSERT INTO countries VALUES (108,'Jordan','JO','JOR','1');

INSERT INTO countries VALUES (109,'Kazakhstan','KZ','KAZ','1');

INSERT INTO countries VALUES (110,'Kenya','KE','KEN','1');

INSERT INTO countries VALUES (111,'Kiribati','KI','KIR','1');

INSERT INTO countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','1');

INSERT INTO countries VALUES (113,'Korea, Republic of','KR','KOR','1');

INSERT INTO countries VALUES (114,'Kuwait','KW','KWT','1');

INSERT INTO countries VALUES (115,'Kyrgyzstan','KG','KGZ','1');

INSERT INTO countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO','1');

INSERT INTO countries VALUES (117,'Latvia','LV','LVA','1');

INSERT INTO countries VALUES (118,'Lebanon','LB','LBN','1');

INSERT INTO countries VALUES (119,'Lesotho','LS','LSO','1');

INSERT INTO countries VALUES (120,'Liberia','LR','LBR','1');

INSERT INTO countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','1');

INSERT INTO countries VALUES (122,'Liechtenstein','LI','LIE','1');

INSERT INTO countries VALUES (123,'Lithuania','LT','LTU','1');

INSERT INTO countries VALUES (124,'Luxembourg','LU','LUX','1');

INSERT INTO countries VALUES (125,'Macao','MO','MAC','1');

INSERT INTO countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','1');

INSERT INTO countries VALUES (127,'Madagascar','MG','MDG','1');

INSERT INTO countries VALUES (128,'Malawi','MW','MWI','1');

INSERT INTO countries VALUES (129,'Malaysia','MY','MYS','1');

INSERT INTO countries VALUES (130,'Maldives','MV','MDV','1');

INSERT INTO countries VALUES (131,'Mali','ML','MLI','1');

INSERT INTO countries VALUES (132,'Malta','MT','MLT','1');

INSERT INTO countries VALUES (133,'Marshall Islands','MH','MHL','1');

INSERT INTO countries VALUES (134,'Martinique','MQ','MTQ','1');

INSERT INTO countries VALUES (135,'Mauritania','MR','MRT','1');

INSERT INTO countries VALUES (136,'Mauritius','MU','MUS','1');

INSERT INTO countries VALUES (137,'Mayotte','YT','MYT','1');

INSERT INTO countries VALUES (138,'Mexico','MX','MEX','1');

INSERT INTO countries VALUES (139,'Micronesia, Federated States of','FM','FSM','1');

INSERT INTO countries VALUES (140,'Moldova','MD','MDA','1');

INSERT INTO countries VALUES (141,'Monaco','MC','MCO','1');

INSERT INTO countries VALUES (142,'Mongolia','MN','MNG','1');

INSERT INTO countries VALUES (143,'Montserrat','MS','MSR','1');

INSERT INTO countries VALUES (144,'Morocco','MA','MAR','1');

INSERT INTO countries VALUES (145,'Mozambique','MZ','MOZ','1');

INSERT INTO countries VALUES (146,'Myanmar','MM','MMR','1');

INSERT INTO countries VALUES (147,'Namibia','NA','NAM','1');

INSERT INTO countries VALUES (148,'Nauru','NR','NRU','1');

INSERT INTO countries VALUES (149,'Nepal','NP','NPL','1');

INSERT INTO countries VALUES (150,'Netherlands','NL','NLD','1');

INSERT INTO countries VALUES (151,'Netherlands Antilles','AN','ANT','1');

INSERT INTO countries VALUES (152,'New Caledonia','NC','NCL','1');

INSERT INTO countries VALUES (153,'New Zealand','NZ','NZL','1');

INSERT INTO countries VALUES (154,'Nicaragua','NI','NIC','1');

INSERT INTO countries VALUES (155,'Niger','NE','NER','1');

INSERT INTO countries VALUES (156,'Nigeria','NG','NGA','1');

INSERT INTO countries VALUES (157,'Niue','NU','NIU','1');

INSERT INTO countries VALUES (158,'Norfolk Island','NF','NFK','1');

INSERT INTO countries VALUES (159,'Northern Mariana Islands','MP','MNP','1');

INSERT INTO countries VALUES (160,'Norway','NO','NOR','1');

INSERT INTO countries VALUES (161,'Oman','OM','OMN','1');

INSERT INTO countries VALUES (162,'Pakistan','PK','PAK','1');

INSERT INTO countries VALUES (163,'Palau','PW','PLW','1');

INSERT INTO countries VALUES (164,'Panama','PA','PAN','1');

INSERT INTO countries VALUES (165,'Papua New Guinea','PG','PNG','1');

INSERT INTO countries VALUES (166,'Paraguay','PY','PRY','1');

INSERT INTO countries VALUES (167,'Peru','PE','PER','1');

INSERT INTO countries VALUES (168,'Philippines','PH','PHL','1');

INSERT INTO countries VALUES (169,'Pitcairn','PN','PCN','1');

INSERT INTO countries VALUES (170,'Poland','PL','POL','1');

INSERT INTO countries VALUES (171,'Portugal','PT','PRT','1');

INSERT INTO countries VALUES (172,'Puerto Rico','PR','PRI','1');

INSERT INTO countries VALUES (173,'Qatar','QA','QAT','1');

INSERT INTO countries VALUES (174,'Reunion','RE','REU','1');

INSERT INTO countries VALUES (175,'Romania','RO','ROU','1');

INSERT INTO countries VALUES (176,'Russian Federation','RU','RUS','1');

INSERT INTO countries VALUES (177,'Rwanda','RW','RWA','1');

INSERT INTO countries VALUES (178,'Saint Kitts and Nevis','KN','KNA','1');

INSERT INTO countries VALUES (179,'Saint Lucia','LC','LCA','1');

INSERT INTO countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT','1');

INSERT INTO countries VALUES (181,'Samoa','WS','WSM','1');

INSERT INTO countries VALUES (182,'San Marino','SM','SMR','1');

INSERT INTO countries VALUES (183,'Sao Tome and Principe','ST','STP','1');

INSERT INTO countries VALUES (184,'Saudi Arabia','SA','SAU','1');

INSERT INTO countries VALUES (185,'Senegal','SN','SEN','1');

INSERT INTO countries VALUES (186,'Seychelles','SC','SYC','1');

INSERT INTO countries VALUES (187,'Sierra Leone','SL','SLE','1');

INSERT INTO countries VALUES (188,'Singapore','SG','SGP', '4');

INSERT INTO countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK','1');

INSERT INTO countries VALUES (190,'Slovenia','SI','SVN','1');

INSERT INTO countries VALUES (191,'Solomon Islands','SB','SLB','1');

INSERT INTO countries VALUES (192,'Somalia','SO','SOM','1');

INSERT INTO countries VALUES (193,'South Africa','ZA','ZAF','1');

INSERT INTO countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS','1');

INSERT INTO countries VALUES (195,'Spain','ES','ESP','3');

INSERT INTO countries VALUES (196,'Sri Lanka','LK','LKA','1');

INSERT INTO countries VALUES (197,'St. Helena','SH','SHN','1');

INSERT INTO countries VALUES (198,'St. Pierre and Miquelon','PM','SPM','1');

INSERT INTO countries VALUES (199,'Sudan','SD','SDN','1');

INSERT INTO countries VALUES (200,'Suriname','SR','SUR','1');

INSERT INTO countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM','1');

INSERT INTO countries VALUES (202,'Swaziland','SZ','SWZ','1');

INSERT INTO countries VALUES (203,'Sweden','SE','SWE','1');

INSERT INTO countries VALUES (204,'Switzerland','CH','CHE','1');

INSERT INTO countries VALUES (205,'Syrian Arab Republic','SY','SYR','1');

INSERT INTO countries VALUES (206,'Taiwan','TW','TWN','1');

INSERT INTO countries VALUES (207,'Tajikistan','TJ','TJK','1');

INSERT INTO countries VALUES (208,'Tanzania, United Republic of','TZ','TZA','1');

INSERT INTO countries VALUES (209,'Thailand','TH','THA','1');

INSERT INTO countries VALUES (210,'Togo','TG','TGO','1');

INSERT INTO countries VALUES (211,'Tokelau','TK','TKL','1');

INSERT INTO countries VALUES (212,'Tonga','TO','TON','1');

INSERT INTO countries VALUES (213,'Trinidad and Tobago','TT','TTO','1');

INSERT INTO countries VALUES (214,'Tunisia','TN','TUN','1');

INSERT INTO countries VALUES (215,'Turkey','TR','TUR','1');

INSERT INTO countries VALUES (216,'Turkmenistan','TM','TKM','1');

INSERT INTO countries VALUES (217,'Turks and Caicos Islands','TC','TCA','1');

INSERT INTO countries VALUES (218,'Tuvalu','TV','TUV','1');

INSERT INTO countries VALUES (219,'Uganda','UG','UGA','1');

INSERT INTO countries VALUES (220,'Ukraine','UA','UKR','1');

INSERT INTO countries VALUES (221,'United Arab Emirates','AE','ARE','1');

INSERT INTO countries VALUES (222,'United Kingdom','GB','GBR','6');

INSERT INTO countries VALUES (223,'United States','US','USA', '2');

INSERT INTO countries VALUES (224,'United States Minor Outlying Islands','UM','UMI','1');

INSERT INTO countries VALUES (225,'Uruguay','UY','URY','1');

INSERT INTO countries VALUES (226,'Uzbekistan','UZ','UZB','1');

INSERT INTO countries VALUES (227,'Vanuatu','VU','VUT','1');

INSERT INTO countries VALUES (228,'Vatican City State (Holy See)','VA','VAT','1');

INSERT INTO countries VALUES (229,'Venezuela','VE','VEN','1');

INSERT INTO countries VALUES (230,'Viet Nam','VN','VNM','1');

INSERT INTO countries VALUES (231,'Virgin Islands (British)','VG','VGB','1');

INSERT INTO countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR','1');

INSERT INTO countries VALUES (233,'Wallis and Futuna Islands','WF','WLF','1');

INSERT INTO countries VALUES (234,'Western Sahara','EH','ESH','1');

INSERT INTO countries VALUES (235,'Yemen','YE','YEM','1');

INSERT INTO countries VALUES (236,'Serbia','RS','SRB','1');

INSERT INTO countries VALUES (238,'Zambia','ZM','ZMB','1');

INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1');

INSERT INTO countries VALUES (241,'Palestinian Territory','PS','PSE','1');

INSERT INTO countries VALUES (242,'Montenegro','ME','MNE','1');

INSERT INTO countries VALUES (243,'Guernsey','GG','GGY','1');

INSERT INTO countries VALUES (244,'Isle of Man','IM','IMN','1');

INSERT INTO countries VALUES (245,'Jersey','JE','JEY','1');

 

# USA

INSERT INTO zones VALUES (1,223,'AL','Alabama');

INSERT INTO zones VALUES (2,223,'AK','Alaska');

INSERT INTO zones VALUES (3,223,'AS','American Samoa');

INSERT INTO zones VALUES (4,223,'AZ','Arizona');

INSERT INTO zones VALUES (5,223,'AR','Arkansas');

INSERT INTO zones VALUES (7,223,'AA','Armed Forces Americas');

INSERT INTO zones VALUES (9,223,'AE','Armed Forces Europe');

INSERT INTO zones VALUES (11,223,'AP','Armed Forces Pacific');

INSERT INTO zones VALUES (12,223,'CA','California');

INSERT INTO zones VALUES (13,223,'CO','Colorado');

INSERT INTO zones VALUES (14,223,'CT','Connecticut');

INSERT INTO zones VALUES (15,223,'DE','Delaware');

INSERT INTO zones VALUES (16,223,'DC','District of Columbia');

INSERT INTO zones VALUES (17,223,'FM','Federated States Of Micronesia');

INSERT INTO zones VALUES (18,223,'FL','Florida');

INSERT INTO zones VALUES (19,223,'GA','Georgia');

INSERT INTO zones VALUES (20,223,'GU','Guam');

INSERT INTO zones VALUES (21,223,'HI','Hawaii');

INSERT INTO zones VALUES (22,223,'ID','Idaho');

INSERT INTO zones VALUES (23,223,'IL','Illinois');

INSERT INTO zones VALUES (24,223,'IN','Indiana');

INSERT INTO zones VALUES (25,223,'IA','Iowa');

INSERT INTO zones VALUES (26,223,'KS','Kansas');

INSERT INTO zones VALUES (27,223,'KY','Kentucky');

INSERT INTO zones VALUES (28,223,'LA','Louisiana');

INSERT INTO zones VALUES (29,223,'ME','Maine');

INSERT INTO zones VALUES (30,223,'MH','Marshall Islands');

INSERT INTO zones VALUES (31,223,'MD','Maryland');

INSERT INTO zones VALUES (32,223,'MA','Massachusetts');

INSERT INTO zones VALUES (33,223,'MI','Michigan');

INSERT INTO zones VALUES (34,223,'MN','Minnesota');

INSERT INTO zones VALUES (35,223,'MS','Mississippi');

INSERT INTO zones VALUES (36,223,'MO','Missouri');

INSERT INTO zones VALUES (37,223,'MT','Montana');

INSERT INTO zones VALUES (38,223,'NE','Nebraska');

INSERT INTO zones VALUES (39,223,'NV','Nevada');

INSERT INTO zones VALUES (40,223,'NH','New Hampshire');

INSERT INTO zones VALUES (41,223,'NJ','New Jersey');

INSERT INTO zones VALUES (42,223,'NM','New Mexico');

INSERT INTO zones VALUES (43,223,'NY','New York');

INSERT INTO zones VALUES (44,223,'NC','North Carolina');

INSERT INTO zones VALUES (45,223,'ND','North Dakota');

INSERT INTO zones VALUES (46,223,'MP','Northern Mariana Islands');

INSERT INTO zones VALUES (47,223,'OH','Ohio');

INSERT INTO zones VALUES (48,223,'OK','Oklahoma');

INSERT INTO zones VALUES (49,223,'OR','Oregon');

INSERT INTO zones VALUES (50,163,'PW','Palau');

INSERT INTO zones VALUES (51,223,'PA','Pennsylvania');

INSERT INTO zones VALUES (52,223,'PR','Puerto Rico');

INSERT INTO zones VALUES (53,223,'RI','Rhode Island');

INSERT INTO zones VALUES (54,223,'SC','South Carolina');

INSERT INTO zones VALUES (55,223,'SD','South Dakota');

INSERT INTO zones VALUES (56,223,'TN','Tennessee');

INSERT INTO zones VALUES (57,223,'TX','Texas');

INSERT INTO zones VALUES (58,223,'UT','Utah');

INSERT INTO zones VALUES (59,223,'VT','Vermont');

INSERT INTO zones VALUES (60,223,'VI','Virgin Islands');

INSERT INTO zones VALUES (61,223,'VA','Virginia');

INSERT INTO zones VALUES (62,223,'WA','Washington');

INSERT INTO zones VALUES (63,223,'WV','West Virginia');

INSERT INTO zones VALUES (64,223,'WI','Wisconsin');

INSERT INTO zones VALUES (65,223,'WY','Wyoming');

 

# Canada

INSERT INTO zones VALUES (66,38,'AB','Alberta');

INSERT INTO zones VALUES (67,38,'BC','British Columbia');

INSERT INTO zones VALUES (68,38,'MB','Manitoba');

INSERT INTO zones VALUES (69,38,'NL','Newfoundland');

INSERT INTO zones VALUES (70,38,'NB','New Brunswick');

INSERT INTO zones VALUES (71,38,'NS','Nova Scotia');

INSERT INTO zones VALUES (72,38,'NT','Northwest Territories');

INSERT INTO zones VALUES (73,38,'NU','Nunavut');

INSERT INTO zones VALUES (74,38,'ON','Ontario');

INSERT INTO zones VALUES (75,38,'PE','Prince Edward Island');

INSERT INTO zones VALUES (76,38,'QC','Quebec');

INSERT INTO zones VALUES (77,38,'SK','Saskatchewan');

INSERT INTO zones VALUES (78,38,'YT','Yukon Territory');

 

# Germany

INSERT INTO zones VALUES (79,81,'NDS','Niedersachsen');

INSERT INTO zones VALUES (80,81,'BAW','Baden-Württemberg');

INSERT INTO zones VALUES (81,81,'BAY','Bayern');

INSERT INTO zones VALUES (82,81,'BER','Berlin');

INSERT INTO zones VALUES (83,81,'BRG','Brandenburg');

INSERT INTO zones VALUES (84,81,'BRE','Bremen');

INSERT INTO zones VALUES (85,81,'HAM','Hamburg');

INSERT INTO zones VALUES (86,81,'HES','Hessen');

INSERT INTO zones VALUES (87,81,'MEC','Mecklenburg-Vorpommern');

INSERT INTO zones VALUES (88,81,'NRW','Nordrhein-Westfalen');

INSERT INTO zones VALUES (89,81,'RHE','Rheinland-Pfalz');

INSERT INTO zones VALUES (90,81,'SAR','Saarland');

INSERT INTO zones VALUES (91,81,'SAS','Sachsen');

INSERT INTO zones VALUES (92,81,'SAC','Sachsen-Anhalt');

INSERT INTO zones VALUES (93,81,'SCN','Schleswig-Holstein');

INSERT INTO zones VALUES (94,81,'THE','Thüringen');

 

# Austria

INSERT INTO zones VALUES (95,14,'WI','Wien');

INSERT INTO zones VALUES (96,14,'NO','Niederösterreich');

INSERT INTO zones VALUES (97,14,'OO','Oberösterreich');

INSERT INTO zones VALUES (98,14,'SB','Salzburg');

INSERT INTO zones VALUES (99,14,'KN','Kärnten');

INSERT INTO zones VALUES (100,14,'ST','Steiermark');

INSERT INTO zones VALUES (101,14,'TI','Tirol');

INSERT INTO zones VALUES (102,14,'BL','Burgenland');

INSERT INTO zones VALUES (103,14,'VB','Voralberg');

 

# Swizterland

INSERT INTO zones VALUES (104,204,'AG','Aargau');

INSERT INTO zones VALUES (105,204,'AI','Appenzell Innerrhoden');

INSERT INTO zones VALUES (106,204,'AR','Appenzell Ausserrhoden');

INSERT INTO zones VALUES (107,204,'BE','Bern');

INSERT INTO zones VALUES (108,204,'BL','Basel-Landschaft');

INSERT INTO zones VALUES (109,204,'BS','Basel-Stadt');

INSERT INTO zones VALUES (110,204,'FR','Freiburg');

INSERT INTO zones VALUES (111,204,'GE','Genf');

INSERT INTO zones VALUES (112,204,'GL','Glarus');

INSERT INTO zones VALUES (113,204,'JU','Graubnden');

INSERT INTO zones VALUES (114,204,'JU','Jura');

INSERT INTO zones VALUES (115,204,'LU','Luzern');

INSERT INTO zones VALUES (116,204,'NE','Neuenburg');

INSERT INTO zones VALUES (117,204,'NW','Nidwalden');

INSERT INTO zones VALUES (118,204,'OW','Obwalden');

INSERT INTO zones VALUES (119,204,'SG','St. Gallen');

INSERT INTO zones VALUES (120,204,'SH','Schaffhausen');

INSERT INTO zones VALUES (121,204,'SO','Solothurn');

INSERT INTO zones VALUES (122,204,'SZ','Schwyz');

INSERT INTO zones VALUES (123,204,'TG','Thurgau');

INSERT INTO zones VALUES (124,204,'TI','Tessin');

INSERT INTO zones VALUES (125,204,'UR','Uri');

INSERT INTO zones VALUES (126,204,'VD','Waadt');

INSERT INTO zones VALUES (127,204,'VS','Wallis');

INSERT INTO zones VALUES (128,204,'ZG','Zug');

INSERT INTO zones VALUES (129,204,'ZH','Zürich');

 

# China

INSERT INTO zones VALUES (130,44,'安徽','安徽');

INSERT INTO zones VALUES (131,44,'北京','北京');

INSERT INTO zones VALUES (132,44,'重庆','重庆');

INSERT INTO zones VALUES (133,44,'福建','福建');

INSERT INTO zones VALUES (134,44,'甘肃','甘肃');

INSERT INTO zones VALUES (135,44,'广东','广东');

INSERT INTO zones VALUES (136,44,'广西','广西');

INSERT INTO zones VALUES (137,44,'贵州','贵州');

INSERT INTO zones VALUES (138,44,'海南','海南');

INSERT INTO zones VALUES (139,44,'河北','河北');

INSERT INTO zones VALUES (140,44,'黑龙江','黑龙江');

INSERT INTO zones VALUES (141,44,'河南','河南');

INSERT INTO zones VALUES (142,44,'香港','香港');

INSERT INTO zones VALUES (143,44,'湖北','湖北');

INSERT INTO zones VALUES (144,44,'湖南','湖南');

INSERT INTO zones VALUES (145,44,'江苏','江苏');

INSERT INTO zones VALUES (146,44,'江西','江西');

INSERT INTO zones VALUES (147,44,'吉林','吉林');

INSERT INTO zones VALUES (148,44,'辽宁','辽宁');

INSERT INTO zones VALUES (149,44,'澳门','澳门');

INSERT INTO zones VALUES (150,44,'内蒙古','内蒙古');

INSERT INTO zones VALUES (151,44,'宁夏','宁夏');

INSERT INTO zones VALUES (152,44,'青海','青海');

INSERT INTO zones VALUES (153,44,'山西','山西');

INSERT INTO zones VALUES (154,44,'陕西','陕西');

INSERT INTO zones VALUES (155,44,'山东','山东');

INSERT INTO zones VALUES (156,44,'上海','上海');

INSERT INTO zones VALUES (157,44,'四川','四川');

INSERT INTO zones VALUES (158,44,'台湾','台湾');

INSERT INTO zones VALUES (159,44,'天津','天津');

INSERT INTO zones VALUES (160,44,'新疆','新疆');

INSERT INTO zones VALUES (161,44,'西藏','西藏');

INSERT INTO zones VALUES (162,44,'云南','云南');

INSERT INTO zones VALUES (163,44,'浙江','浙江');

 

# Spain

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'A Coruña','A Coruña');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Álava','Álava');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Albacete','Albacete');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alicante','Alicante');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Almería','Almería');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Asturias','Asturias');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ávila','Ávila');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Badajoz','Badajoz');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Baleares','Baleares');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Barcelona','Barcelona');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Burgos','Burgos');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cáceres','Cáceres');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cádiz','Cádiz');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cantabria','Cantabria');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Castellón','Castellón');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ceuta','Ceuta');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ciudad Real','Ciudad Real');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Córdoba','Córdoba');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cuenca','Cuenca');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Girona','Girona');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Granada','Granada');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guadalajara','Guadalajara');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guipúzcoa','Guipúzcoa');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huelva','Huelva');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huesca','Huesca');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Jaén','Jaén');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'La Rioja','La Rioja');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Las Palmas','Las Palmas');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'León','León');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lérida','Lérida');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lugo','Lugo');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Madrid','Madrid');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Málaga','Málaga');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Melilla','Melilla');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Murcia','Murcia');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Navarra','Navarra');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ourense','Ourense');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Palencia','Palencia');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Pontevedra','Pontevedra');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Salamanca','Salamanca');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Segovia','Segovia');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Sevilla','Sevilla');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Soria','Soria');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Tarragona','Tarragona');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Teruel','Teruel');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Toledo','Toledo');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valencia','Valencia');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valladolid','Valladolid');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Vizcaya','Vizcaya');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zamora','Zamora');

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zaragoza','Zaragoza');

 

#australian zones

INSERT INTO zones VALUES (NULL, 13, 'ACT', 'Australian Capital Territory');

INSERT INTO zones VALUES (NULL, 13, 'NSW', 'New South Wales');

INSERT INTO zones VALUES (NULL, 13, 'NT', 'Northern Territory');

INSERT INTO zones VALUES (NULL, 13, 'QLD', 'Queensland');

INSERT INTO zones VALUES (NULL, 13, 'SA', 'South Australia');

INSERT INTO zones VALUES (NULL, 13, 'TAS', 'Tasmania');

INSERT INTO zones VALUES (NULL, 13, 'VIC', 'Victoria');

INSERT INTO zones VALUES (NULL, 13, 'WA', 'Western Australia');

 

#italian zones

INSERT INTO zones VALUES (NULL, 105,'AG','Agrigento');

INSERT INTO zones VALUES (NULL, 105,'AL','Alessandria');

INSERT INTO zones VALUES (NULL, 105,'AN','Ancona');

INSERT INTO zones VALUES (NULL, 105,'AO','Aosta');

INSERT INTO zones VALUES (NULL, 105,'AR','Arezzo');

INSERT INTO zones VALUES (NULL, 105,'AP','Ascoli Piceno');

INSERT INTO zones VALUES (NULL, 105,'AT','Asti');

INSERT INTO zones VALUES (NULL, 105,'AV','Avellino');

INSERT INTO zones VALUES (NULL, 105,'BA','Bari');

INSERT INTO zones VALUES (NULL, 105,'BT','Barletta Andria Trani');

INSERT INTO zones VALUES (NULL, 105,'BL','Belluno');

INSERT INTO zones VALUES (NULL, 105,'BN','Benevento');

INSERT INTO zones VALUES (NULL, 105,'BG','Bergamo');

INSERT INTO zones VALUES (NULL, 105,'BI','Biella');

INSERT INTO zones VALUES (NULL, 105,'BO','Bologna');

INSERT INTO zones VALUES (NULL, 105,'BZ','Bolzano');

INSERT INTO zones VALUES (NULL, 105,'BS','Brescia');

INSERT INTO zones VALUES (NULL, 105,'BR','Brindisi');

INSERT INTO zones VALUES (NULL, 105,'CA','Cagliari');

INSERT INTO zones VALUES (NULL, 105,'CL','Caltanissetta');

INSERT INTO zones VALUES (NULL, 105,'CB','Campobasso');

INSERT INTO zones VALUES (NULL, 105,'CI','Carbonia-Iglesias');

INSERT INTO zones VALUES (NULL, 105,'CE','Caserta');

INSERT INTO zones VALUES (NULL, 105,'CT','Catania');

INSERT INTO zones VALUES (NULL, 105,'CZ','Catanzaro');

INSERT INTO zones VALUES (NULL, 105,'CH','Chieti');

INSERT INTO zones VALUES (NULL, 105,'CO','Como');

INSERT INTO zones VALUES (NULL, 105,'CS','Cosenza');

INSERT INTO zones VALUES (NULL, 105,'CR','Cremona');

INSERT INTO zones VALUES (NULL, 105,'KR','Crotone');

INSERT INTO zones VALUES (NULL, 105,'CN','Cuneo');

INSERT INTO zones VALUES (NULL, 105,'EN','Enna');

INSERT INTO zones VALUES (NULL, 105,'FM','Fermo');

INSERT INTO zones VALUES (NULL, 105,'FE','Ferrara');

INSERT INTO zones VALUES (NULL, 105,'FI','Firenze');

INSERT INTO zones VALUES (NULL, 105,'FG','Foggia');

INSERT INTO zones VALUES (NULL, 105,'FC','Forlì Cesena');

INSERT INTO zones VALUES (NULL, 105,'FR','Frosinone');

INSERT INTO zones VALUES (NULL, 105,'GE','Genova');

INSERT INTO zones VALUES (NULL, 105,'GO','Gorizia');

INSERT INTO zones VALUES (NULL, 105,'GR','Grosseto');

INSERT INTO zones VALUES (NULL, 105,'IM','Imperia');

INSERT INTO zones VALUES (NULL, 105,'IS','Isernia');

INSERT INTO zones VALUES (NULL, 105,'AQ','Aquila');

INSERT INTO zones VALUES (NULL, 105,'SP','La Spezia');

INSERT INTO zones VALUES (NULL, 105,'LT','Latina');

INSERT INTO zones VALUES (NULL, 105,'LE','Lecce');

INSERT INTO zones VALUES (NULL, 105,'LC','Lecco');

INSERT INTO zones VALUES (NULL, 105,'LI','Livorno');

INSERT INTO zones VALUES (NULL, 105,'LO','Lodi');

INSERT INTO zones VALUES (NULL, 105,'LU','Lucca');

INSERT INTO zones VALUES (NULL, 105,'MC','Macerata');

INSERT INTO zones VALUES (NULL, 105,'MN','Mantova');

INSERT INTO zones VALUES (NULL, 105,'MS','Massa Carrara');

INSERT INTO zones VALUES (NULL, 105,'MT','Matera');

INSERT INTO zones VALUES (NULL, 105,'VS','Medio Campidano');

INSERT INTO zones VALUES (NULL, 105,'ME','Messina');

INSERT INTO zones VALUES (NULL, 105,'MI','Milano');

INSERT INTO zones VALUES (NULL, 105,'MO','Modena');

INSERT INTO zones VALUES (NULL, 105,'MB','Monza e Brianza');

INSERT INTO zones VALUES (NULL, 105,'NA','Napoli');

INSERT INTO zones VALUES (NULL, 105,'NO','Novara');

INSERT INTO zones VALUES (NULL, 105,'NU','Nuoro');

INSERT INTO zones VALUES (NULL, 105,'OG','Ogliastra');

INSERT INTO zones VALUES (NULL, 105,'OT','Olbia-Tempio');

INSERT INTO zones VALUES (NULL, 105,'OR','Oristano');

INSERT INTO zones VALUES (NULL, 105,'PD','Padova');

INSERT INTO zones VALUES (NULL, 105,'PA','Palermo');

INSERT INTO zones VALUES (NULL, 105,'PR','Parma');

INSERT INTO zones VALUES (NULL, 105,'PG','Perugia');

INSERT INTO zones VALUES (NULL, 105,'PV','Pavia');

INSERT INTO zones VALUES (NULL, 105,'PU','Pesaro Urbino');

INSERT INTO zones VALUES (NULL, 105,'PE','Pescara');

INSERT INTO zones VALUES (NULL, 105,'PC','Piacenza');

INSERT INTO zones VALUES (NULL, 105,'PI','Pisa');

INSERT INTO zones VALUES (NULL, 105,'PT','Pistoia');

INSERT INTO zones VALUES (NULL, 105,'PN','Pordenone');

INSERT INTO zones VALUES (NULL, 105,'PZ','Potenza');

INSERT INTO zones VALUES (NULL, 105,'PO','Prato');

INSERT INTO zones VALUES (NULL, 105,'RG','Ragusa');

INSERT INTO zones VALUES (NULL, 105,'RA','Ravenna');

INSERT INTO zones VALUES (NULL, 105,'RC','Reggio Calabria');

INSERT INTO zones VALUES (NULL, 105,'RE','Reggio Emilia');

INSERT INTO zones VALUES (NULL, 105,'RI','Rieti');

INSERT INTO zones VALUES (NULL, 105,'RN','Rimini');

INSERT INTO zones VALUES (NULL, 105,'RM','Roma');

INSERT INTO zones VALUES (NULL, 105,'RO','Rovigo');

INSERT INTO zones VALUES (NULL, 105,'SA','Salerno');

INSERT INTO zones VALUES (NULL, 105,'SS','Sassari');

INSERT INTO zones VALUES (NULL, 105,'SV','Savona');

INSERT INTO zones VALUES (NULL, 105,'SI','Siena');

INSERT INTO zones VALUES (NULL, 105,'SR','Siracusa');

INSERT INTO zones VALUES (NULL, 105,'SO','Sondrio');

INSERT INTO zones VALUES (NULL, 105,'TA','Taranto');

INSERT INTO zones VALUES (NULL, 105,'TE','Teramo');

INSERT INTO zones VALUES (NULL, 105,'TR','Terni');

INSERT INTO zones VALUES (NULL, 105,'TO','Torino');

INSERT INTO zones VALUES (NULL, 105,'TP','Trapani');

INSERT INTO zones VALUES (NULL, 105,'TN','Trento');

INSERT INTO zones VALUES (NULL, 105,'TV','Treviso');

INSERT INTO zones VALUES (NULL, 105,'TS','Trieste');

INSERT INTO zones VALUES (NULL, 105,'UD','Udine');

INSERT INTO zones VALUES (NULL, 105,'VA','Varese');

INSERT INTO zones VALUES (NULL, 105,'VE','Venezia');

INSERT INTO zones VALUES (NULL, 105,'VB','Verbania');

INSERT INTO zones VALUES (NULL, 105,'VC','Vercelli');

INSERT INTO zones VALUES (NULL, 105,'VR','Verona');

INSERT INTO zones VALUES (NULL, 105,'VV','Vibo Valentia');

INSERT INTO zones VALUES (NULL, 105,'VI','Vicenza');

INSERT INTO zones VALUES (NULL, 105,'VT','Viterbo');