DROP TABLE IF EXISTS tst_zones;
CREATE TABLE tst_zones (
  id int NOT NULL auto_increment,
  country_id int NOT NULL,
  code varchar(32) NOT NULL,
  name varchar(32) NOT NULL,
  PRIMARY KEY (id)
);

#Afghanistan
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'BA','Badakhshan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'BD','Badghis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'BG','Baghlan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'BL','Balkh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'BM','Bamian');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'FA','Farah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'FR','Faryab');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'GH','Ghazni');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'GO','Ghowr');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'HE','Helmand');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'HR','Herat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'JO','Jowzjan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'KA','Kabol');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'KN','Kandahar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'KP','Kapisa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'KO','Konar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'KD','Kondoz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'LA','Laghman');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'LO','Lowgar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'NA','Nangarhar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'NI','Nimruz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'OR','Oruzgan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'PA','Paktia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'PK','Paktika');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'PR','Parvan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'SA','Samangan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'SP','Sar-e Pol');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'TA','Takhar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'VA','Vardak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',1,'ZA','Zabol');

#Albania
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'BE','Berat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'BU','Bulqize');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'DE','Delvine');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'DV','Devoll (Bilisht)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'DI','Diber (Peshkopi)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'DU','Durres');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'EL','Elbasan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'FI','Fier');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'GJ','Gjirokaster');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'GR','Gramsh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'HA','Has (Krume)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'KA','Kavaje');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'KO','Kolonje (Erseke)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'KR','Korce');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'KU','Kruje');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'KC','Kucove');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'KK','Kukes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'LA','Lac');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'LE','Lezhe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'LI','Librazhd');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'LU','Lushnje');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'MM','Malesi e Madhe (Koplik)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'MA','Mallakaster (Ballsh)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'MT','Mat (Burrel)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'MI','Mirdite (Rreshen)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'PE','Peqin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'PR','Permet');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'PO','Pogradec');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'PU','Puke');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'SA','Sarande');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'SH','Shkoder');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'SK','Skrapar (Corovode)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'TE','Tepelene');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'TI','Tirane (Tirana)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'TR','Tropoje (Bajram Curri)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',2,'VL','Vlore');

#Algeria
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'AD','Adrar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'AI','Ain Defla');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'AT','Ain Temouchent');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'AL','Alger');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'AN','Annaba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BA','Batna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BE','Bechar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BJ','Bejaia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BI','Biskra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BL','Blida');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BB','Bordj Bou Arreridj');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BO','Bouira');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'BU','Boumerdes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'CH','Chlef');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'CO','Constantine');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'DJ','Djelfa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'EB','El Bayadh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'EO','El Oued');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'ET','El Tarf');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'GH','Ghardaia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'GU','Guelma');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'IL','Illizi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'JI','Jijel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'KH','Khenchela');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'LA','Laghouat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'MS','M\'Sila');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'MA','Mascara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'ME','Medea');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'MI','Mila');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'MO','Mostaganem');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'NA','Naama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'OR','Oran');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'OU','Ouargla');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'OB','Oum el Bouaghi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'RE','Relizane');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'SA','Saida');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'SE','Setif');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'SB','Sidi Bel Abbes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'SK','Skikda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TA','Tamanghasset');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TE','Tebessa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TI','Tiaret');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TN','Tindouf');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TP','Tipaza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TS','Tissemsilt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TO','Tizi Ouzou');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',3,'TL','Tlemcen');

#American Samoa
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',4,'EA','Eastern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',4,'MA','Manu\'a');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',4,'RI','Rose Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',4,'SI','Swains Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',4,'WE','Western');

#Andorra
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',5,'AN','Andorra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',5,'CA','Canillo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',5,'EN','Encamp');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',5,'LM','La Massana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',5,'LE','Les Escaldes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',5,'OR','Ordino');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',5,'SJ','Sant Julia de Lori');

#Angola
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'BE','Bengo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'BN','Benguela');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'BI','Bie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'CA','Cabinda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'CC','Cuando Cubango');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'CN','Cuanza Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'CS','Cuanza Sul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'CU','Cunene');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'HU','Huambo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'HI','Huila');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'LU','Luanda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'LN','Lunda Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'LS','Lunda Sul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'MA','Malanje');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'MO','Moxico');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'NA','Namibe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'UI','Uige');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',6,'ZA','Zaire');

#Antigua and Barbuda
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'BA','Barbuda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'RE','Redonda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'SG','Saint George');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'SJ','Saint John');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'SM','Saint Mary');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'SP','Saint Paul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'SE','Saint Peter');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',9,'SH','Saint Philip');

#Argentina
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'AN','Antartida e Islas del Atlantico Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'BA','Buenos Aires');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'CA','Catamarca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'CH','Chaco');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'CU','Chubut');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'CO','Cordoba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'CR','Corrientes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'DF','Distrito Federal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'ER','Entre Rios');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'FO','Formosa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'JU','Jujuy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'LP','La Pampa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'LR','La Rioja');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'ME','Mendoza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'MI','Misiones');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'NE','Neuquen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'RN','Rio Negro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'SA','Salta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'SJ','San Juan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'SL','San Luis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'SC','Santa Cruz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'SF','Santa Fe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'SD','Santiago del Estero');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'TF','Tierra del Fuego');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',10,'TU','Tucuman');

#Armenia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'AR','Aragatsotn');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'AA','Ararat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'AM','Armavir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'GE','Geghark\'unik\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'KO','Kotayk\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'LO','Lorri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'SH','Shirak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'SY','Syunik\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'TA','Tavush');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'VA','Vayots\' Dzor');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',11,'YE','Yerevan');

#Australia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'ACT','Australian Capitol Territory');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'NSW','New South Wales');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'NT','Northern Territory');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'QLD','Queensland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'SA','South Australia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'TAS','Tasmania');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'VIC','Victoria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',13,'WA','Western Australia');

#Austria
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'BU','Burgenland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'CA','Carinthia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'NI','Niederoesterreich');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'OB','Oberoesterreich');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'SA','Salzburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'ST','Steiermark');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'TI','Tirol');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'VO','Vorarlberg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',14,'WI','Wien');

#Azerbaijan
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AB','Abseron Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AG','Agcabadi Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AD','Agdam Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AA','Agdas Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AS','Agstafa Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AU','Agsu Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AL','Ali Bayramli Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'AT','Astara Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'BS','Baki Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'BR','Balakan Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'BA','Barda Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'BE','Beylaqan Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'BI','Bilasuvar Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'CA','Cabrayil Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'CL','Calilabad Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'DA','Daskasan Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'DV','Davaci Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'FU','Fuzuli Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'GA','Gadabay Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'GN','Ganca Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'GO','Goranboy Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'GY','Goycay Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'HA','Haciqabul Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'IM','Imisli Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'IS','Ismayilli Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'KA','Kalbacar Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'KU','Kurdamir Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'LA','Lacin Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'LN','Lankaran Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'LK','Lankaran Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'LE','Lerik Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'MA','Masalli Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'MI','Mingacevir Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'NA','Naftalan Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'NX','Naxcivan Muxtar Respublikasi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'NE','Neftcala Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'OG','Oguz Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'QA','Qabala Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'QX','Qax Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'QZ','Qazax Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'QO','Qobustan Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'QU','Quba Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'QB','Qubadli Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'QS','Qusar Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SA','Saatli Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SB','Sabirabad Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SK','Saki Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SI','Saki Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SL','Salyan Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SM','Samaxi Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SR','Samkir Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SX','Samux Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SY','Siyazan Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SU','Sumqayit Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'SS','Susa Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'ST','Susa Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'TA','Tartar Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'TO','Tovuz Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'UC','Ucar Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'XA','Xacmaz Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'XN','Xankandi Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'XL','Xanlar Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'XI','Xizi Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'XO','Xocali Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'XC','Xocavand Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'YA','Yardimli Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'YE','Yevlax Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'YV','Yevlax Sahari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'ZA','Zangilan Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'ZQ','Zaqatala Rayonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',15,'ZR','Zardab Rayonu');

#Bahamas
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'AC','Acklins and Crooked Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'BI','Bimini');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'CI','Cat Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'EX','Exuma');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'FR','Freeport');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'FC','Fresh Creek');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'GH','Governor\'s Harbour');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'GT','Green Turtle Cay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'HI','Harbour Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'HR','High Rock');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'IN','Inagua');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'KB','Kemps Bay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'LI','Long Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'MH','Marsh Harbour');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'MA','Mayaguana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'NP','New Providence');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'NT','Nicholls Town and Berry Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'RI','Ragged Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'RS','Rock Sound');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'SS','San Salvador and Rum Cay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',16,'SP','Sandy Point');

#Bahrain
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'AH','Al Hadd');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'AM','Al Manamah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'AG','Al Mintaqah al Gharbiyah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'AW','Al Mintaqah al Wusta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'AS','Al Mintaqah ash Shamaliyah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'AU','Al Muharraq');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'AR','Ar Rifa\' wa al Mintaqah al Janubiyah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'JH','Jidd Hafs');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'JU','Juzur Hawar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'MI','Madinat \'Isa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'MH','Madinat Hamad');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',17,'SI','Sitrah');

#Bangladesh
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',18,'BA','Barisal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',18,'CH','Chittagong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',18,'DH','Dhaka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',18,'KH','Khulna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',18,'RA','Rajshahi');

#Barbados
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'CC','Christ Church');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SA','Saint Andrew');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SG','Saint George');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SJ','Saint James');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SO','Saint John');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SS','Saint Joseph');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SL','Saint Lucy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SM','Saint Michael');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SP','Saint Peter');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'SH','Saint Philip');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',19,'ST','Saint Thomas');

#Belarus
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',20,'BR','Brestskaya (Brest)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',20,'HO','Homyel\'skaya (Homyel\')');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',20,'HM','Horad Minsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',20,'HR','Hrodzyenskaya (Hrodna)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',20,'MA','Mahilyowskaya (Mahilyow)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',20,'MI','Minskaya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',20,'VI','Vitsyebskaya (Vitsyebsk)');

#Belgium
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'AN','Antwerpen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'BW','Brabant Wallon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'HA','Hainaut');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'LG','Liege');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'LM','Limburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'LX','Luxembourg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'NM','Namur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'OV','Oost-Vlaanderen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'VB','Vlaams Brabant');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',21,'WV','West-Vlaanderen');

#Belize
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',22,'BE','Belize');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',22,'CA','Cayo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',22,'CO','Corozal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',22,'OW','Orange Walk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',22,'SC','Stann Creek');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',22,'TO','Toledo');

#Benin
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'AI','Alibori');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'AT','Atakora');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'AL','Atlantique');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'BO','Borgou');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'CO','Collines');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'CF','Couffo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'DO','Donga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'LI','Littoral');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'MO','Mono');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'OU','Oueme');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'PL','Plateau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',23,'ZO','Zou');

#Bermuda
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'DE','Devonshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'HA','Hamilton');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'PA','Paget');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'PE','Pembroke');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'SG','Saint Georges');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'SA','Sandys');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'SM','Smiths');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'SO','Southampton');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',24,'WA','Warwick');

#Bhutan
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'BU','Bumthang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'CH','Chhukha');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'CI','Chirang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'DA','Daga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'GE','Geylegphug');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'HA','Ha');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'LH','Lhuntshi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'MO','Mongar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'PA','Paro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'PE','Pemagatsel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'PU','Punakha');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'SA','Samchi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'SJ','Samdrup Jongkhar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'SH','Shemgang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'TA','Tashigang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'TH','Thimphu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'TO','Tongsa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',25,'WP','Wangdi Phodrang');

#Bolivia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'BE','Beni');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'CH','Chuquisaca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'CO','Cochabamba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'LP','La Paz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'OR','Oruro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'PA','Pando');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'PO','Potosi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'SC','Santa Cruz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',26,'TA','Tarija');

#Botswana
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'CD','Central District');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'CH','Chobe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'GH','Ghanzi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'KG','Kgalagadi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'KL','Kgatleng');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'KW','Kweneng');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'NG','Ngamiland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'NE','North East District');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'SE','South East District');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',28,'SD','Southern District');

#Brazil
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'AC','Acre');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'AL','Alagoas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'AM','Amapa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'AZ','Amazonas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'BA','Bahia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'CE','Ceara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'DF','Distrito Federal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'ES','Espirito Santo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'GO','Goias');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'MA','Maranhao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'MG','Mato Grosso');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'MS','Mato Grosso do Sul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'MR','Minas Gerais');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'PA','Para');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'PR','Paraiba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'PN','Parana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'PE','Pernambuco');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'PI','Piaui');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'RJ','Rio de Janeiro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'RN','Rio Grande do Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'RS','Rio Grande do Sul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'RO','Rondonia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'RR','Roraima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'SC','Santa Catarina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'SP','Sao Paulo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'SE','Sergipe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',30,'TO','Tocantins');

#Brunei Darussalam
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',32,'BE','Belait');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',32,'BM','Brunei and Muara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',32,'TE','Temburong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',32,'TU','Tutong');

#Bulgaria
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'BU','Burgas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'GS','Grad Sofiya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'KH','Khaskovo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'LO','Lovech');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'MO','Montana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'PL','Plovdiv');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'RU','Ruse');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'SO','Sofiya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',33,'VA','Varna');

#Burkina Faso
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'BA','Bale');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'BM','Bam');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'BN','Banwa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'BZ','Bazega');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'BO','Bougouriba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'BU','Boulgou');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'BL','Boulkiemde');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'CO','Comoe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'GA','Ganzourgou');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'GN','Gnagna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'GO','Gourma');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'HO','Houet');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'IO','Ioba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KA','Kadiogo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KE','Kenedougou');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KO','Komandjari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KM','Kompienga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KS','Kossi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KU','Koupelogo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KR','Kouritenga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'KW','Kourweogo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'LE','Leraba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'LO','Loroum');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'MO','Mouhoun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'NA','Nahouri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'NM','Namentenga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'NU','Naumbiel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'NY','Nayala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'OU','Oubritenga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'OD','Oudalan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'PA','Passore');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'PO','Poni');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'SA','Samentenga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'SN','Sanguie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'SE','Seno');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'SI','Sissili');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'SO','Soum');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'SU','Sourou');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'TA','Tapoa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'TU','Tuy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'YA','Yagha');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'YT','Yatenga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'ZI','Ziro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'ZO','Zondomo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',34,'ZU','Zoundweogo');

#Burundi
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'BU','Bubanza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'BJ','Bujumbura');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'BR','Bururi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'CA','Cankuzo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'CI','Cibitoke');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'GI','Gitega');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'KA','Karuzi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'KY','Kayanza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'KI','Kirundo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'MA','Makamba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'MU','Muramvya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'MY','Muyinga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'MW','Mwaro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'NG','Ngozi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'RU','Rutana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',35,'RY','Ruyigi');

#Canada
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'AB','Alberta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'BC','British Columbia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'MB','Manitoba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'NB','New Brunswick');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'NL','Newfoundland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'NT','Northwest Territories and Nunavut');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'NS','Nova Scotia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'ON','Ontario');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'PE','Prince Edward Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'QC','Quebec');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'SK','Saskatchewan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',38,'YT','Yukon');

#Chile
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'AI','Aisen del General Carlos Ibanez del Campo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'AN','Antofagasta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'AR','Araucania');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'AT','Atacama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'BB','Bio-Bio');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'CO','Coquimbo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'LI','Libertador General Bernardo O\'Higgins');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'LL','Los Lagos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'MA','Magallanes y de la Antartica Chilena');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'MU','Maule');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'RM','Region Metropolitana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'TA','Tarapaca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',43,'VA','Valparaiso');

#China
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'AN','Anhui');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'BE','Beijing');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'CH','Chongqing');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'FU','Fujian');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'GA','Gansu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'GU','Guangdong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'GX','Guangxi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'GZ','Guizhou');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'HA','Hainan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'HB','Hebei');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'HL','Heilongjiang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'HE','Henan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'HK','Hong Kong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'HU','Hubei');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'HN','Hunan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'IM','Inner Mongolia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'JI','Jiangsu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'JX','Jiangxi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'JL','Jilin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'LI','Liaoning');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'MA','Macau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'NI','Ningxia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'SH','Shaanxi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'SA','Shandong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'SG','Shanghai');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'SX','Shanxi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'SI','Sichuan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'TI','Tianjin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'XI','Xinjiang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'YU','Yunnan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',44,'ZH','Zhejiang');

#Colombia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'AM','Amazonas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'AN','Antioquia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'AR','Arauca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'AT','Atlantico');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'BO','Bolivar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'BY','Boyaca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'CA','Caldas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'CQ','Caqueta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'CS','Casanare');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'CU','Cauca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'CE','Cesar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'CH','Choco');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'CO','Cordoba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'DC','Distrito Capital de Santa Fe de Bogota');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'GU','Guainia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'GA','Guaviare');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'HU','Huila');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'LG','La Guajira');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'MA','Magdalena');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'ME','Meta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'NA','Narino');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'NS','Norte de Santander');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'PU','Putumayo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'QU','Quindio');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'RI','Risaralda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'SA','San Andres y Providencia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'SN','Santander');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'SU','Sucre');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'TO','Tolima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'VC','Valle del Cauca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'VA','Vaupes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',47,'VI','Vichada');

#Costa Rica
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',51,'AL','Alajuela');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',51,'CA','Cartago');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',51,'GU','Guanacaste');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',51,'HE','Heredia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',51,'LI','Limon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',51,'PU','Puntarenas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',51,'SJ','San Jose');

#Croatia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'BB','Bjelovar-Bilogora');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'CZ','City of Zagreb');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'DN','Dubrovnik-Neretva');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'IS','Istra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'KA','Karlovac');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'KK','Koprivnica-Krizevci');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'KZ','Krapina-Zagorje');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'LS','Lika-Senj');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'ME','Medimurje');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'OB','Osijek-Baranja');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'PS','Pozega-Slavonia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'PG','Primorje-Gorski Kotar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'SI','Sibenik');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'SM','Sisak-Moslavina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'SB','Slavonski Brod-Posavina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'SD','Split-Dalmatia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'VA','Varazdin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'VP','Virovitica-Podravina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'VS','Vukovar-Srijem');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'ZK','Zadar-Knin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',53,'ZA','Zagreb');

#Cuba
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'CA','Camaguey');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'CD','Ciego de Avila');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'CI','Cienfuegos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'CH','Ciudad de La Habana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'GR','Granma');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'GU','Guantanamo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'HO','Holguin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'IJ','Isla de la Juventud');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'LH','La Habana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'LT','Las Tunas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'MA','Matanzas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'PR','Pinar del Rio');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'SS','Sancti Spiritus');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'SC','Santiago de Cuba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',54,'VC','Villa Clara');

#Czech Republic
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'U','Ustecky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'C','Jihocesky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'B','Jihomoravsky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'K','Karlovarsky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'H','Kralovehradecky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'L','Liberecky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'T','Moravskoslezsky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'M','Olomoucky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'E','Pardubicky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'P','Plzensky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'A','Praha');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'S','Stredocesky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'J','Vysocina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',56,'Z','Zlinsky');

#Denmark
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'AR','Arhus');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'BO','Bornholm');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'FR','Frederiksborg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'FY','Fyn');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'KO','Kobenhavn');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'NO','Nordjylland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'RI','Ribe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'RK','Ringkobing');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'RO','Roskilde');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'SO','Sonderjylland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'ST','Storstrom');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'VE','Vejle');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'VJ','Vestjælland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',57,'VI','Viborg');

#El Salvador
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'AH','Ahuachapan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'CA','Cabanas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'CH','Chalatenango');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'CU','Cuscatlan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'LL','La Libertad');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'LP','La Paz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'LU','La Union');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'MO','Morazan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'SM','San Miguel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'SS','San Salvador');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'SV','San Vicente');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'SA','Santa Ana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'SO','Sonsonate');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',64,'US','Usulutan');

#Estonia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'HA','Harjumaa (Tallinn)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'HI','Hiiumaa (Kardla)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'IV','Ida-Virumaa (Johvi)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'JA','Jarvamaa (Paide)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'JO','Jogevamaa (Jogeva)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'LV','Laane-Virumaa (Rakvere)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'LA','Laanemaa (Haapsalu)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'PA','Parnumaa (Parnu)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'PO','Polvamaa (Polva)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'RA','Raplamaa (Rapla)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'SA','Saaremaa (Kuessaare)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'TA','Tartumaa (Tartu)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'VA','Valgamaa (Valga)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'VI','Viljandimaa (Viljandi)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',67,'VO','Vorumaa (Voru)');

#Finland
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',72,'AL','Aland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',72,'ES','Etela-Suomen Laani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',72,'IS','Ita-Suomen Laani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',72,'LS','Lansi-Suomen Laani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',72,'LA','Lappi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',72,'OU','Oulun Laani');

#France
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'AL','Alsace');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'AQ','Aquitaine');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'AU','Auvergne');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'BR','Brittany');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'BU','Burgundy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'CE','Center Loire Valley');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'CH','Champagne');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'CO','Corse');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'FR','France Comte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'LA','Languedoc Roussillon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'LI','Limousin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'LO','Lorraine');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'MI','Midi Pyrenees');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'NO','Nord Pas de Calais');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'NR','Normandy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'PA','Paris / Ill de France');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'PI','Picardie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'PO','Poitou Charente');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'PR','Provence');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'RH','Rhone Alps');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'RI','Riviera');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',73,'WE','Western Loire Valley');

#Germany
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'BW','Baden-Wurttemberg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'BA','Bayern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'BE','Berlin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'BN','Brandenburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'BR','Bremen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'HA','Hamburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'HE','Hessen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'MV','Mecklenburg-Vorpommern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'NI','Niedersachsen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'NO','Nordrhein Westfalen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'RP','Rheinland-Pfalz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'SL','Saarland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'SS','Sachsen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'SA','Sachsen-Anhalt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'SH','Schleswig Holstein');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',81,'TH','Thuringen');

#Greece
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'AI','Aitolia kai Akarnania');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'AK','Akhaia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'AG','Argolis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'AD','Arkadhia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'AR','Arta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'AT','Attiki');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'AY','Ayion Oros (Mt. Athos)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'DH','Dhodhekanisos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'DR','Drama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'ET','Evritania');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'ES','Evros');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'EV','Evvoia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'FL','Florina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'FO','Fokis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'FT','Fthiotis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'GR','Grevena');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'IL','Ilia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'IM','Imathia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'IO','Ioannina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'IR','Irakleion');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KA','Kardhitsa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KS','Kastoria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KV','Kavala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KE','Kefallinia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KR','Kerkyra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KH','Khalkidhiki');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KN','Khania');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KI','Khios');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KK','Kikladhes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KL','Kilkis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KO','Korinthia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'KZ','Kozani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'LA','Lakonia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'LR','Larisa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'LS','Lasithi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'LE','Lesvos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'LV','Levkas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'MA','Magnisia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'ME','Messinia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'PE','Pella');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'PI','Pieria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'PR','Preveza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'RE','Rethimni');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'RO','Rodhopi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'SA','Samos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'SE','Serrai');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'TH','Thesprotia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'TS','Thessaloniki');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'TR','Trikala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'VO','Voiotia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'XA','Xanthi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',84,'ZA','Zakinthos');

#Guatemala
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'AV','Alta Verapaz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'BV','Baja Verapaz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'CH','Chimaltenango');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'CI','Chiquimula');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'EP','El Progreso');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'ES','Escuintla');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'GU','Guatemala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'HU','Huehuetenango');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'IZ','Izabal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'JA','Jalapa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'JU','Jutiapa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'PE','Peten');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'QU','Quetzaltenango');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'QI','Quiche');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'RE','Retalhuleu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'SA','Sacatepequez');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'SM','San Marcos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'SR','Santa Rosa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'SO','Solola');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'SU','Suchitepequez');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'TO','Totonicapan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',89,'ZA','Zacapa');

#Hungary
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'BK','Bacs-Kiskun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'BA','Baranya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'BE','Bekes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'BS','Bekescsaba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'BZ','Borsod-Abauj-Zemplen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'BU','Budapest');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'CS','Csongrad');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'DE','Debrecen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'DU','Dunaujvaros');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'EG','Eger');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'FE','Fejer');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'GY','Gyor');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'GM','Gyor-Moson-Sopron');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'HB','Hajdu-Bihar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'HE','Heves');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'HO','Hodmezovasarhely');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'JN','Jasz-Nagykun-Szolnok');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'KA','Kaposvar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'KE','Kecskemet');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'KO','Komarom-Esztergom');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'MI','Miskolc');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'NA','Nagykanizsa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'NO','Nograd');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'NY','Nyiregyhaza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'PE','Pecs');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'PS','Pest');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'SO','Somogy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'SP','Sopron');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'SS','Szabolcs-Szatmar-Bereg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'SZ','Szeged');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'SE','Szekesfehervar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'SL','Szolnok');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'SM','Szombathely');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'TA','Tatabanya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'TO','Tolna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'VA','Vas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'VE','Veszprem');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'ZA','Zala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',97,'ZZ','Zalaegerszeg');

#India
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'AN','Andaman and Nicobar Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'AP','Andhra Pradesh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'AR','Arunachal Pradesh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'AS','Assam');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'BI','Bihar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'CH','Chandigarh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'DA','Dadra and Nagar Haveli');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'DM','Daman and Diu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'DE','Delhi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'GO','Goa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'GU','Gujarat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'HA','Haryana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'HP','Himachal Pradesh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'JA','Jammu and Kashmir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'KA','Karnataka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'KE','Kerala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'LI','Lakshadweep Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'MP','Madhya Pradesh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'MA','Maharashtra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'MN','Manipur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'ME','Meghalaya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'MI','Mizoram');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'NA','Nagaland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'OR','Orissa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'PO','Pondicherry');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'PU','Punjab');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'RA','Rajasthan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'SI','Sikkim');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'TN','Tamil Nadu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'TR','Tripura');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'UP','Uttar Pradesh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',99,'WB','West Bengal');

#Indonesia
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'AC','Aceh');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'BA','Bali');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'BT','Banten');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'BE','Bengkulu');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'BD','BoDeTaBek');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'GO','Gorontalo');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'JK','Jakarta Raya');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'JA','Jambi');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'JB','Jawa Barat');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'JT','Jawa Tengah');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'JI','Jawa Timur');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'KB','Kalimantan Barat');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'KS','Kalimantan Selatan');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'KT','Kalimantan Tengah');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'KI','Kalimantan Timur');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'BB','Kepulauan Bangka Belitung');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'LA','Lampung');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'MA','Maluku');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'MU','Maluku Utara');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'NB','Nusa Tenggara Barat');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'NT','Nusa Tenggara Timur');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'PA','Papua');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'RI','Riau');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'SN','Sulawesi Selatan');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'ST','Sulawesi Tengah');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'SG','Sulawesi Tenggara');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'SA','Sulawesi Utara');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'SB','Sumatera Barat');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'SS','Sumatera Selatan');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'SU','Sumatera Utara');
INSERT INTO tst_zones (id, country_id, code, name) VALUES ('',100,'YO','Yogyakarta');

#Ireland
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'CA','Carlow');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'CV','Cavan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'CL','Clare');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'CO','Cork');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'DO','Donegal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'DU','Dublin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'GA','Galway');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'KE','Kerry');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'KI','Kildare');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'KL','Kilkenny');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'LA','Laois');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'LE','Leitrim');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'LI','Limerick');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'LO','Longford');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'LU','Louth');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'MA','Mayo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'ME','Meath');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'MO','Monaghan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'OF','Offaly');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'RO','Roscommon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'SL','Sligo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'TI','Tipperary');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'WA','Waterford');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'WE','Westmeath');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'WX','Wexford');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',103,'WI','Wicklow');

#Israel
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'BS','Be\'er Sheva');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'BH','Bika\'at Hayarden');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'EA','Eilat and Arava');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'GA','Galil');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'HA','Haifa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'JM','Jehuda Mountains');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'JE','Jerusalem');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'NE','Negev');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'SE','Semaria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'SH','Sharon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',104,'TA','Tel Aviv (Gosh Dan)');

#Italy
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'AB','Abruzzo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'BA','Basilicata');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'CA','Calabria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'CP','Campania');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'ER','Emilia Romagna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'FV','Friuli-Venezia Giulia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'LA','Lazio (Latium & Rome)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'TM','Le Marche (The Marches)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'LI','Liguria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'LO','Lombardia (Lombardy)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'MO','Molise');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'PI','Piemonte (Piedmont)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'AP','Puglia (Apulia)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'SA','Sardegna (Sardinia)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'SI','Sicilia (Sicily)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'TU','Toscana (Tuscany)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'TR','Trentino Alto Adige');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'UM','Umbria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'VA','Val d\'Aosta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',105,'VE','Veneto');

#Japan
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'AI','Aichi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'AK','Akita');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'AO','Aomori');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'CH','Chiba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'EH','Ehime');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'FK','Fukui');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'FU','Fukuoka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'FS','Fukushima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'GI','Gifu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'GU','Gumma');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'HI','Hiroshima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'HO','Hokkaido');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'HY','Hyogo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'IB','Ibaraki');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'IS','Ishikawa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'IW','Iwate');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'KA','Kagawa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'KG','Kagoshima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'KN','Kanagawa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'KO','Kochi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'KU','Kumamoto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'KY','Kyoto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'MI','Mie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'MY','Miyagi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'MZ','Miyazaki');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'NA','Nagano');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'NG','Nagasaki');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'NR','Nara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'NI','Niigata');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'OI','Oita');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'OK','Okayama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'ON','Okinawa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'OS','Osaka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'SA','Saga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'SI','Saitama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'SH','Shiga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'SM','Shimane');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'SZ','Shizuoka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'TO','Tochigi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'TS','Tokushima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'TK','Tokyo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'TT','Tottori');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'TY','Toyama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'WA','Wakayama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'YA','Yamagata');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'YM','Yamaguchi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',107,'YN','Yamanashi');

#Jordan
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AM','\'Amman');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AJ','Ajlun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AA','Al \'Aqabah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AB','Al Balqa\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AK','Al Karak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AL','Al Mafraq');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AT','At Tafilah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'AZ','Az Zarqa\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'IR','Irbid');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'JA','Jarash');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'MA','Ma\'an');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',108,'MD','Madaba');

#Kazakhstan
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'AL','Almaty');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'AC','Almaty City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'AM','Aqmola');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'AQ','Aqtobe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'AS','Astana City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'AT','Atyrau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'BA','Batys Qazaqstan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'BY','Bayqongyr City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'MA','Mangghystau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'ON','Ongtustik Qazaqstan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'PA','Pavlodar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'QA','Qaraghandy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'QO','Qostanay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'QY','Qyzylorda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'SH','Shyghys Qazaqstan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'SO','Soltustik Qazaqstan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',109,'ZH','Zhambyl');

#Kenya
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'CE','Central');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'CO','Coast');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'EA','Eastern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'NA','Nairobi Area');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'NE','North Eastern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'NY','Nyanza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'RV','Rift Valley');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',110,'WE','Western');

#Korea, Republic of
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'CO','Ch\'ungch\'ong-bukto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'CH','Ch\'ungch\'ong-namdo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'CD','Cheju-do');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'CB','Cholla-bukto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'CN','Cholla-namdo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'IG','Inch\'on-gwangyoksi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'KA','Kangwon-do');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'KG','Kwangju-gwangyoksi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'KD','Kyonggi-do');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'KB','Kyongsang-bukto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'KN','Kyongsang-namdo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'PG','Pusan-gwangyoksi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'SO','Soul-t\'ukpyolsi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'TA','Taegu-gwangyoksi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',113,'TG','Taejon-gwangyoksi');

#Kuwait
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',114,'AL','Al \'Asimah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',114,'AA','Al Ahmadi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',114,'AF','Al Farwaniyah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',114,'AJ','Al Jahra\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',114,'HA','Hawalli');

#Luxembourg
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',124,'DI','Diekirch');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',124,'GR','Grevenmacher');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',124,'LU','Luxembourg');

#Malaysia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'JO','Johor');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'KE','Kedah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'KL','Kelantan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'LA','Labuan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'ME','Melaka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'NS','Negeri Sembilan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'PA','Pahang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'PE','Perak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'PR','Perlis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'PP','Pulau Pinang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'SA','Sabah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'SR','Sarawak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'SE','Selangor');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'TE','Terengganu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',129,'WP','Wilayah Persekutuan');

#Mexico
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'BC','Baja California');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'BS','Baja California Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'CA','Campeche');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'CI','Chiapas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'CH','Chihuahua');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'CZ','Coahuila de Zaragoza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'CL','Colima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'DF','Distrito Federal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'DU','Durango');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'GA','Guanajuato');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'GE','Guerrero');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'HI','Hidalgo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'JA','Jalisco');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'ME','Mexico');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'MI','Michoacan de Ocampo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'MO','Morelos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'NA','Nayarit');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'NL','Nuevo Leon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'OA','Oaxaca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'PU','Puebla');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'QA','Queretaro de Arteaga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'QR','Quintana Roo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'SA','San Luis Potosi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'SI','Sinaloa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'SO','Sonora');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'TB','Tabasco');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'TM','Tamaulipas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'TL','Tlaxcala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'VE','Veracruz-Llave');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'YU','Yucatan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',138,'ZA','Zacatecas');

#Netherlands
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'DR','Drente');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'FL','Flevoland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'FR','Friesland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'GE','Gelderland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'GR','Groningen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'LB','Limburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'NB','Noord-Brabant');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'NH','Noord-Holland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'OV','Overijssel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'UT','Utrecht');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'ZE','Zeeland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',150,'ZH','Zuid-Holland');

#New Zealand
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'AU','Auckland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'BP','Bay of Plenty');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'CA','Canterbury');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'GI','Gisborne');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'HB','Hawke\'s Bay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'MA','Marlborough');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'NE','Nelson');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'NO','Northland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'OT','Otago');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'SO','Southland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'TA','Taranaki');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'TS','Tasman');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'WA','Waikato');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'WM','Wanganui-Manawatu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'WE','Wellington');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',153,'WC','West Coast');

#Nicaragua
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'AN','Atlantico Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'AS','Atlantico Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'BO','Boaco');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'CA','Carazo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'CI','Chinandega');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'CO','Chontales');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'ES','Esteli');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'GR','Granada');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'JI','Jinotega');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'LE','Leon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'MD','Madriz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'MN','Managua');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'MS','Masaya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'MT','Matagalpa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'NS','Nuevo Segovia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'RS','Rio San Juan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',154,'RI','Rivas');

#Niger
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'AG','Agadez');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'DI','Diffa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'DO','Dosso');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'MA','Maradi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'NI','Niamey');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'TA','Tahoua');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'TI','Tillaberi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',155,'ZI','Zinder');

#Nigeria
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'AB','Abia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'FC','Abuja Federal Capital Territory');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'AD','Adamawa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'AI','Akwa Ibom');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'AN','Anambra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'BA','Bauchi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'BY','Bayelsa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'BE','Benue');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'BO','Borno');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'CR','Cross River');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'DE','Delta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'EB','Ebonyi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'ED','Edo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'EK','Ekiti');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'EN','Enugu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'GO','Gombe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'IM','Imo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'JI','Jigawa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'KA','Kaduna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'KN','Kano');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'KT','Katsina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'KE','Kebbi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'KO','Kogi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'KW','Kwara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'LA','Lagos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'NA','Nassarawa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'NI','Niger');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'OG','Ogun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'ON','Ondo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'OS','Osun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'OY','Oyo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'PL','Plateau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'RI','Rivers');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'SO','Sokoto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'TA','Taraba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'YO','Yobe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',156,'ZA','Zamfara');

#Norway
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'AK','Akershus');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'AA','Aust-Agder');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'BU','Buskerud');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'FI','Finnmark');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'HE','Hedmark');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'HO','Hordaland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'MR','More og Romsdal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'NT','Nord-Trondelag');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'NL','Nordland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'OF','Ostfold');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'OP','Oppland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'OS','Oslo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'RO','Rogaland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'ST','Sor-Trondelag');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'SF','Sogn og Fjordane');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'SV','Svalbard');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'TE','Telemark');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'TR','Troms');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'VA','Vest-Agder');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',160,'VF','Vestfold');

#Pakistan
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',162,'BA','Balochistan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',162,'TA','Federally Administered Tribal Areas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',162,'IS','Islamabad Capital Territory');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',162,'NF','North-West Frontier');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',162,'PU','Punjab');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',162,'SI','Sindh');

#Philippines
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'AB','Abra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'AG','Agusan del Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'AU','Agusan del Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'AK','Aklan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'AL','Albay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'AN','Angeles');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'AT','Antique');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BA','Bacolod');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BG','Bago');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BU','Baguio');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BI','Bais');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BS','Basilan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BC','Basilan City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BT','Bataan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BN','Batanes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BB','Batangas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BD','Batangas City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BE','Benguet');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BO','Bohol');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BK','Bukidnon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BL','Bulacan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'BV','Butuan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CA','Cabanatuan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CD','Cadiz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CG','Cagayan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CO','Cagayan de Oro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CL','Calbayog');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CC','Caloocan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CN','Camarines Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CS','Camarines Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CM','Camiguin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CB','Canlaon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CP','Capiz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CT','Catanduanes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CV','Cavite');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CH','Cavite City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CE','Cebu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CY','Cebu City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'CF','Cotabato');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DA','Dagupan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DN','Danao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DP','Dapitan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DD','Davao City Davao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DS','Davao del Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DO','Davao Oriental');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DI','Dipolog');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'DU','Dumaguete');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ES','Eastern Samar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'GS','General Santos');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'GI','Gingoog');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IF','Ifugao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IL','Iligan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IN','Ilocos Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IS','Ilocos Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IO','Iloilo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IC','Iloilo City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IR','Iriga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'IB','Isabela');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'KA','Kalinga-Apayao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LC','La Carlota');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LU','La Union');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LA','Laguna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LN','Lanao del Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LS','Lanao del Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LG','Laoag');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LL','Lapu-Lapu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LE','Legaspi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LY','Leyte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LI','Lipa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'LV','Lucena');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MA','Maguindanao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MN','Mandaue');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MI','Manila');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MR','Marawi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MD','Marinduque');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MS','Masbate');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MO','Mindoro Occidental');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MT','Mindoro Oriental');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ML','Misamis Occidental');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ME','Misamis Oriental');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'MU','Mountain');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'NA','Naga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'NO','Negros Occidental');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'NE','Negros Oriental');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'NC','North Cotabato');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'NS','Northern Samar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'NI','Nueva Ecija');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'NV','Nueva Vizcaya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'OL','Olongapo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'OR','Ormoc');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'OQ','Oroquieta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'OZ','Ozamis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'PA','Pagadian');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'PL','Palawan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'PY','Palayan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'PM','Pampanga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'PN','Pangasinan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'PS','Pasay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'PU','Puerto Princesa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'QU','Quezon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'QZ','Quezon City');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'QR','Quirino');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'RI','Rizal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'RO','Romblon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'RX','Roxas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SA','Samar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SC','San Carlos (in Negros Occidental)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SN','San Carlos (in Pangasinan)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SJ','San Jose');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SP','San Pablo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SI','Silay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SQ','Siquijor');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SO','Sorsogon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ST','South Cotabato');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SL','Southern Leyte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SK','Sultan Kudarat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SU','Sulu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SG','Surigao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SD','Surigao del Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'SS','Surigao del Sur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TA','Tacloban');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TG','Tagaytay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TB','Tagbilaran');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TN','Tangub');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TR','Tarlac');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TW','Tawitawi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TO','Toledo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'TM','Trece Martires');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ZA','Zambales');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ZM','Zamboanga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ZN','Zamboanga del Norte');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',168,'ZS','Zamboanga del Sur');

#Poland
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'DO','Dolnoslaskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'KM','Kujawsko-Pomorskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'LO','Lodzkie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'LE','Lubelskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'LU','Lubuskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'ML','Malopolskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'MZ','Mazowieckie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'OP','Opolskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'PK','Podkarpackie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'PL','Podlaskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'PM','Pomorskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'SL','Slaskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'SW','Swietokrzyskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'WM','Warminsko-Mazurskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'WI','Wielkopolskie');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',170,'ZA','Zachodniopomorskie');

#Portugal
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'AC','Acores (Azores)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'AV','Aveiro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'BE','Beja');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'BR','Braga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'BA','Braganca');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'CB','Castelo Branco');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'CO','Coimbra');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'EV','Evora');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'FA','Faro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'GU','Guarda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'LE','Leiria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'LI','Lisboa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'ME','Madeira');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'PO','Portalegre');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'PR','Porto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'SA','Santarem');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'SE','Setubal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'VC','Viana do Castelo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'VR','Vila Real');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',171,'VI','Viseu');

#Romania
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'AL','Alba');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'AR','Arad');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'AG','Arges');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BA','Bacau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BI','Bihor');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BN','Bistrita-Nasaud');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BO','Botosani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BL','Braila');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BR','Brasov');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BU','Bucuresti');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'BZ','Buzau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'CA','Calarasi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'CS','Caras-Severin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'CL','Cluj');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'CO','Constanta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'CV','Covasna');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'DI','Dimbovita');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'DO','Dolj');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'GA','Galati');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'GI','Giurgiu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'GO','Gorj');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'HA','Harghita');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'HU','Hunedoara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'IA','Ialomita');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'IS','Iasi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'IL','Ilfov');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'MA','Maramures');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'ME','Mehedinti');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'MU','Mures');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'NE','Neamt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'OL','Olt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'PR','Prahova');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'SA','Salaj');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'SM','Satu-Mare');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'SI','Sibiu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'SU','Suceava');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'TE','Teleorman');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'TI','Timis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'TU','Tulcea');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'VA','Vaslui');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'VI','Vilcea');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',175,'VR','Vrancea');

#Russian Federation
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'AB','Abakan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'AG','Aginskoye');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'AN','Anadyr');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'AR','Arkahangelsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'AS','Astrakhan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'BA','Barnaul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'BE','Belgorod');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'BI','Birobidzhan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'BL','Blagoveshchensk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'BR','Bryansk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'CH','Cheboksary');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'CL','Chelyabinsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'CR','Cherkessk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'CI','Chita');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'DU','Dudinka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'EL','Elista');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'GO','Gomo-Altaysk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'GA','Gorno-Altaysk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'GR','Groznyy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'IR','Irkutsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'IV','Ivanovo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'IZ','Izhevsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KA','Kalinigrad');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KL','Kaluga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KS','Kasnodar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KZ','Kazan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KE','Kemerovo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KH','Khabarovsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KM','Khanty-Mansiysk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KO','Kostroma');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KR','Krasnodar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KN','Krasnoyarsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KU','Kudymkar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KG','Kurgan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KK','Kursk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'KY','Kyzyl');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'LI','Lipetsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'MA','Magadan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'MK','Makhachkala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'MY','Maykop');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'MO','Moscow');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'MU','Murmansk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'NA','Nalchik');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'NR','Naryan Mar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'NZ','Nazran');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'NI','Nizhniy Novgorod');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'NO','Novgorod');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'NV','Novosibirsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'OM','Omsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'OR','Orel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'OE','Orenburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'PA','Palana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'PE','Penza');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'PR','Perm');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'PK','Petropavlovsk-Kamchatskiy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'PT','Petrozavodsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'PS','Pskov');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'RO','Rostov-na-Donu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'RY','Ryazan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'SL','Salekhard');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'SA','Samara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'SR','Saransk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'SV','Saratov');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'SM','Smolensk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'SP','St. Petersburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'ST','Stavropol');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'SY','Syktyvkar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'TA','Tambov');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'TO','Tomsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'TU','Tula');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'TR','Tura');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'TV','Tver');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'TY','Tyumen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'UF','Ufa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'UL','Ul\'yanovsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'UU','Ulan-Ude');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'US','Ust\'-Ordynskiy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'VL','Vladikavkaz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'VA','Vladimir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'VV','Vladivostok');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'VG','Volgograd');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'VD','Vologda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'VO','Voronezh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'VY','Vyatka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'YA','Yakutsk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'YR','Yaroslavl');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'YE','Yekaterinburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',176,'YO','Yoshkar-Ola');

#Slovakia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'BA','Banskobystricky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'BR','Bratislavsky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'KO','Kosicky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'NI','Nitriansky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'PR','Presovsky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'TR','Trenciansky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'TN','Trnavsky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',189,'ZI','Zilinsky');

#South Africa
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'EC','Eastern Cape');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'FS','Free State');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'GA','Gauteng');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'KN','KwaZulu-Natal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'MP','Mpumalanga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'NW','North-West');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'NC','Northern Cape');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'NP','Northern Province');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',193,'WC','Western Cape');

#Spain
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'AN','Andalusia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'AR','Aragon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'AS','Asturias');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'BI','Balearic Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'BC','Basque Country');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'CI','Canary Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'CA','Cantabria');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'CL','Castilla y Leon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'CM','Castilla-La Mancha');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'CT','Catalonia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'EX','Extremadura');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'GA','Galicia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'LR','La Rioja');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'MA','Madrid');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'MU','Murcia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'NA','Navarre');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',195,'VA','Valencia');

#Sri Lanka
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'CE','Central');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'NC','North Central');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'NE','North Eastern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'NW','North Western');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'SA','Sabaragamuwa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'SO','Southern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'UV','Uva');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',196,'WE','Western');

#St. Helena
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',197,'AS','Ascension');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',197,'SH','Saint Helena');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',197,'TC','Tristan da Cunha');

#Sweden
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'BL','Blekinge');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'DA','Dalarnas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'GA','Gavleborgs');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'GO','Gotlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'HA','Hallands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'JA','Jamtlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'JO','Jonkopings');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'KA','Kalmar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'KR','Kronobergs');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'NO','Norrbottens');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'OR','Orebro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'OS','Ostergotlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'SK','Skane');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'SO','Sodermanlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'ST','Stockholms');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'UP','Uppsala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'VA','Varmlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'VS','Vasterbottens');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'VT','Vasternorrlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'VM','Vastmanlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',203,'VG','Vastra Gotalands');

#Switzerland
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'AG','Aargau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'AR','Appenzell Ausserrhoden');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'AI','Appenzelli Innerrhoden');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'BS','Basel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'BE','Bern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'FR','Freiburg');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'GE','Geneve');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'GL','Glarus');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'GR','Graubünden');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'JU','Jura');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'LU','Luzern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'NE','Neuchâtel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'NW','Nidwalden');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'OW','Obwalden');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'SG','Sankt Gallen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'SH','Schaffhausen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'SZ','Schwyz');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'SO','Solothurn');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'TG','Thurgau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'TI','Ticino');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'UW','Unterwalden');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'UR','Uri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'VS','Valais');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'VD','Vaud');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',204,'ZG','Zug');

#Thailand
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'AC','Amnat Charoen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'AT','Ang Thong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'BU','Buriram');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CH','Chachoengsao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CN','Chai Nat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CA','Chaiyaphum');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CT','Chanthaburi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CM','Chiang Mai');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CR','Chiang Rai');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CB','Chon Buri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'CU','Chumphon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'KA','Kalasin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'KP','Kamphaeng Phet');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'KN','Kanchanaburi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'KK','Khon Kaen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'KR','Krabi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'KT','Krung Thep Mahanakhon (Bangkok)');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'LA','Lampang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'LM','Lamphun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'LO','Loei');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'LB','Lop Buri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'MH','Mae Hong Son');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'MS','Maha Sarakham');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'MU','Mukdahan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NN','Nakhon Nayok');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NP','Nakhon Pathom');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NM','Nakhon Phanom');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NR','Nakhon Ratchasima');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NS','Nakhon Sawan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NT','Nakhon Si Thammarat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NA','Nan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NW','Narathiwat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NB','Nong Bua Lamphu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NK','Nong Khai');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'NO','Nonthaburi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PT','Pathum Thani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PA','Pattani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PH','Phangnga');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PL','Phatthalung');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PY','Phayao');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PE','Phetchabun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PC','Phetchaburi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PI','Phichit');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PX','Phitsanulok');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PN','Phra Nakhon Si Ayutthaya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PR','Phrae');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PU','Phuket');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PB','Prachin Buri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'PK','Prachuap Khiri Khan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'RA','Ranong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'RT','Ratchaburi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'RY','Rayong');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'RE','Roi Et');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SK','Sa Kaeo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SN','Sakon Nakhon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SP','Samut Prakan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SS','Samut Sakhon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SM','Samut Songkhram');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SB','Sara Buri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SA','Satun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SI','Sing Buri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SC','Sisaket');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SO','Songkhla');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SH','Sukhothai');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SR','Suphan Buri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'ST','Surat Thani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'SU','Surin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'TA','Tak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'TR','Trang');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'TT','Trat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'UR','Ubon Ratchathani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'UT','Udon Thani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'UH','Uthai Thani');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'UA','Uttaradit');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'YA','Yala');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',209,'YS','Yasothon');

#Tunisia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'AK','Al Kaf');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'AM','Al Mahdiyah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'AU','Al Munastir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'AQ','Al Qasrayn');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'AA','Al Qayrawan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'AR','Aryanah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'BJ','Bajah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'BN','Banzart');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'BA','Bin \'Arus');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'JU','Jundubah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'MA','Madanin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'NA','Nabul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'QB','Qabis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'QF','Qafsah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'QI','Qibili');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'SA','Safaqis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'SZ','Sidi Bu Zayd');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'SI','Silyanah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'SU','Susah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'TA','Tatawin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'TW','Tawzar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'TU','Tunis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',214,'ZA','Zaghwan');

#Turkey
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AD','Adana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AI','Adiyaman');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AF','Afyon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AG','Agri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AK','Aksaray');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AM','Amasya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AN','Ankara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AT','Antalya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AR','Ardahan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AV','Artvin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'AY','Aydin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BA','Balikesir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BR','Bartin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BT','Batman');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BY','Bayburt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BI','Bilecik');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BN','Bingol');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BL','Bitlis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BO','Bolu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BU','Burdur');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'BS','Bursa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'CA','Canakkale');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'CN','Cankiri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'CO','Corum');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'DE','Denizli');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'DI','Diyarbakir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'ED','Edirne');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'EL','Elazig');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'ER','Erzincan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'EZ','Erzurum');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'ES','Eskisehir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'GA','Gazi Antep');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'GI','Giresun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'GU','Gumushane');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'HA','Hakkari');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'HT','Hatay');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'IC','Icel');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'IG','Igdir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'IS','Isparta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'IT','Istanbul');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'IZ','Izmir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KM','Kahraman Maras');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KB','Karabuk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KN','Karaman');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KA','Kars');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KT','Kastamonu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KY','Kayseri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KL','Kilis');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KR','Kirikkale');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KK','Kirklareli');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KS','Kirsehir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KC','Kocaeli');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KO','Konya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'KU','Kutahya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'ML','Malatya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'MN','Manisa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'MR','Mardin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'MG','Mugla');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'MS','Mus');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'NE','Nevsehir');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'NI','Nigde');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'OR','Ordu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'OS','Osmaniye');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'RI','Rize');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'SA','Sakarya');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'SM','Samsun');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'SU','Sanli Urfa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'SI','Siirt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'SN','Sinop');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'SR','Sirnak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'SV','Sivas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'TE','Tekirdag');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'TO','Tokat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'TR','Trabzon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'TU','Tunceli');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'US','Usak');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'VA','Van');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'YA','Yalova');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'YO','Yozgat');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',215,'ZO','Zonguldak');

#Ukraine
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'KR','Avtonomna Respublika Krym');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'CH','Cherkas\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'CE','Chernihivs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'CR','Chernivets\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'DN','Dnipropetrovs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'DO','Donets\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'IV','Ivano-Frankivs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'KA','Kharkivs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'KE','Khersons\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'KL','Khmel\'nyts\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'KI','Kirovohrads\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'KY','Kyyiv');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'KV','Kyyivs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'LV','L\'vivs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'LU','Luhans\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'MY','Mykolayivs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'OD','Odes\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'PO','Poltavs\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'RI','Rivnens\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'SE','Sevastopol\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'SU','Sums\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'TE','Ternopil\'s\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'VI','Vinnyts\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'VO','Volyns\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'ZK','Zakarpats\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'ZP','Zaporiz\'ka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',220,'ZH','Zhytomyrs\'ka');

#United Kingdom
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ABN', 'Aberdeen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ABNS', 'Aberdeenshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ANG', 'Anglesey');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'AGS', 'Angus');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ARY', 'Argyll and Bute');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'BEDS', 'Bedfordshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'BERKS', 'Berkshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'BLA', 'Blaenau Gwent');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'BRI', 'Bridgend');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'BSTL', 'Bristol');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'BUCKS', 'Buckinghamshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CAE', 'Caerphilly');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CAMBS', 'Cambridgeshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CDF', 'Cardiff');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CARM', 'Carmarthenshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CDGN', 'Ceredigion');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CHES', 'Cheshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CLACK', 'Clackmannanshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CON', 'Conwy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'CORN', 'Cornwall');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DNBG', 'Denbighshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DERBY', 'Derbyshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DVN', 'Devon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DOR', 'Dorset');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DGL', 'Dumfries and Galloway');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DUND', 'Dundee');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DHM', 'Durham');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ARYE', 'East Ayrshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'DUNBE', 'East Dunbartonshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'LOTE', 'East Lothian');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'RENE', 'East Renfrewshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ERYS', 'East Riding of Yorkshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SXE', 'East Sussex');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'EDIN', 'Edinburgh');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ESX', 'Essex');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'FALK', 'Falkirk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'FFE', 'Fife');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'FLINT', 'Flintshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'GLAS', 'Glasgow');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'GLOS', 'Gloucestershire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'LDN', 'Greater London');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'MCH', 'Greater Manchester');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'GDD', 'Gwynedd');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'HANTS', 'Hampshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'HWR', 'Herefordshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'HERTS', 'Hertfordshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'HLD', 'Highlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'IVER', 'Inverclyde');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'IOW', 'Isle of Wight');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'KNT', 'Kent');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'LANCS', 'Lancashire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'LEICS', 'Leicestershire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'LINCS', 'Lincolnshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'MSY', 'Merseyside');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'MERT', 'Merthyr Tydfil');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'MLOT', 'Midlothian');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'MMOUTH', 'Monmouthshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'MORAY', 'Moray');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'NPRTAL', 'Neath Port Talbot');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'NEWPT', 'Newport');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'NOR', 'Norfolk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ARYN', 'North Ayrshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'LANN', 'North Lanarkshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'YSN', 'North Yorkshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'NHM', 'Northamptonshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'NLD', 'Northumberland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'NOT', 'Nottinghamshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ORK', 'Orkney Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'OFE', 'Oxfordshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'PEM', 'Pembrokeshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'PERTH', 'Perth and Kinross');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'PWS', 'Powys');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'REN', 'Renfrewshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'RHON', 'Rhondda Cynon Taff');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'RUT', 'Rutland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'BOR', 'Scottish Borders');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SHET', 'Shetland Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SPE', 'Shropshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SOM', 'Somerset');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'ARYS', 'South Ayrshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'LANS', 'South Lanarkshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'YSS', 'South Yorkshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SFD', 'Staffordshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'STIR', 'Stirling');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SFK', 'Suffolk');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SRY', 'Surrey');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SWAN', 'Swansea');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'TORF', 'Torfaen');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'TWR', 'Tyne and Wear');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'VGLAM', 'Vale of Glamorgan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WARKS', 'Warwickshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WDUN', 'West Dunbartonshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WLOT', 'West Lothian');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WMD', 'West Midlands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'SXW', 'West Sussex');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'YSW', 'West Yorkshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WIL', 'Western Isles');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WLT', 'Wiltshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WORCS', 'Worcestershire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',222, 'WRX', 'Wrexham');

#United States
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AL','Alabama');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AK','Alaska');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AS','American Samoa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AZ','Arizona');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AR','Arkansas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AF','Armed Forces Africa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AA','Armed Forces Americas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AC','Armed Forces Canada');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AE','Armed Forces Europe');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AM','Armed Forces Middle East');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'AP','Armed Forces Pacific');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'CA','California');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'CO','Colorado');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'CT','Connecticut');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'DE','Delaware');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'DC','District of Columbia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'FM','Federated States Of Micronesia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'FL','Florida');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'GA','Georgia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'GU','Guam');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'HI','Hawaii');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'ID','Idaho');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'IL','Illinois');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'IN','Indiana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'IA','Iowa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'KS','Kansas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'KY','Kentucky');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'LA','Louisiana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'ME','Maine');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MH','Marshall Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MD','Maryland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MA','Massachusetts');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MI','Michigan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MN','Minnesota');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MS','Mississippi');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MO','Missouri');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MT','Montana');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'NE','Nebraska');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'NV','Nevada');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'NH','New Hampshire');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'NJ','New Jersey');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'NM','New Mexico');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'NY','New York');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'NC','North Carolina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'ND','North Dakota');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'MP','Northern Mariana Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'OH','Ohio');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'OK','Oklahoma');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'OR','Oregon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'PW','Palau');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'PA','Pennsylvania');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'PR','Puerto Rico');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'RI','Rhode Island');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'SC','South Carolina');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'SD','South Dakota');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'TN','Tennessee');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'TX','Texas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'UT','Utah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'VT','Vermont');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'VI','Virgin Islands');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'VA','Virginia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'WA','Washington');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'WV','West Virginia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'WI','Wisconsin');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',223,'WY','Wyoming');

#Uruguay
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'AR','Artigas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'CA','Canelones');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'CL','Cerro Largo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'CO','Colonia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'DU','Durazno');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'FL','Flores');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'FO','Florida');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'LA','Lavalleja');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'MA','Maldonado');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'MO','Montevideo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'PA','Paysandu');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'RN','Rio Negro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'RI','Rivera');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'RO','Rocha');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'SA','Salto');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'SJ','San Jose');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'SO','Soriano');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'TA','Tacuarembo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',225,'TT','Treinta y Tres');

#Venezuela
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'AM','Amazonas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'AN','Anzoategui');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'AP','Apure');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'AR','Aragua');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'BA','Barinas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'BO','Bolivar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'CA','Carabobo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'CO','Cojedes');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'DA','Delta Amacuro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'DF','Dependencias Federales');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'DI','Distrito Federal');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'FA','Falcon');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'GU','Guarico');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'LA','Lara');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'ME','Merida');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'MI','Miranda');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'MO','Monagas');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'NE','Nueva Esparta');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'PO','Portuguesa');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'SU','Sucre');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'TA','Tachira');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'TR','Trujillo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'YA','Yaracuy');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',229,'ZU','Zulia');

#Yemen
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AD','\'Adan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AT','\'Ataq');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AB','Abyan');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AL','Al Bayda\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AH','Al Hudaydah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AJ','Al Jawf');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AM','Al Mahrah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'AW','Al Mahwit');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'DH','Dhamar');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'HA','Hadhramawt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'HJ','Hajjah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'IB','Ibb');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'LA','Lahij');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'MA','Ma\'rib');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'SA','Sa\'dah');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'SN','San\'a\'');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',235,'TA','Ta\'izz');

#Yugoslavia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',236,'KO','Kosovo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',236,'MO','Montenegro');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',236,'SE','Serbia');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',236,'VO','Vojvodina');

#Zambia
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'CE','Central');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'CO','Copperbelt');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'EA','Eastern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'LU','Luapula');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'LS','Lusaka');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'NW','North-Western');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'NO','Northern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'SO','Southern');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',238,'WE','Western');

#Zimbabwe
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'BU','Bulawayo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'HA','Harare');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'MA','Manicaland');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'MC','Mashonaland Central');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'ME','Mashonaland East');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'MW','Mashonaland West');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'MV','Masvingo');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'MN','Matabeleland North');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'MS','Matabeleland South');
INSERT INTO tst_zones (id, country_id, code, name ) VALUES ('',239,'MI','Midlands');