Quick Search:

Mode

Context

Displaying 3 lines of context. None | Less | More | Full

Other Diffs

Ignore

Blank Lines Whitespace:

Diff

1536
  
1546
  
1546
  
oscommerce.sql
_> 1 -# $Id: oscommerce.sql 1536 2007-03-30 22:10:22Z hpdl $
   1+# $Id: oscommerce.sql 1546 2007-03-31 02:21:32Z hpdl $
22 #
  33 # osCommerce, Open Source E-Commerce Solutions
  44 # http://www.oscommerce.com
      
 !
 
…
704704 INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'root@localhost', 'The e-mail address of my store owner', '1', '3', now());
  705705 INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail From', 'EMAIL_FROM', '"Store Owner" <root@localhost>', 'The e-mail address used in (sent) e-mails', '1', '4', now());
  706706 INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Country', 'STORE_COUNTRY', '223', 'The country my store is located in <br><br><b>Note: Please remember to update the store zone.</b>', '1', '6', 'osC_Address::getCountryName', 'osc_cfg_set_countries_pulldown_menu', now());
<> 707 -INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Zone', 'STORE_ZONE', '176', 'The zone my store is located in', '1', '7', 'osC_Address::getZoneName', 'osc_cfg_set_zones_pulldown_menu', now());
   707+INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Zone', 'STORE_ZONE', '', 'The zone my store is located in', '1', '7', 'osC_Address::getZoneName', 'osc_cfg_set_zones_pulldown_menu', now());
708708 INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 &lt;email@address1&gt;, Name 2 &lt;email@address2&gt;', '1', '11', now());
  709709 INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', '-1', 'Allow guests to tell a friend about a product', '1', '15', 'osc_cfg_use_get_boolean_value', 'osc_cfg_set_boolean_value(array(1, -1))', now());
  710710 INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Store Address and Phone', 'STORE_NAME_ADDRESS', 'Store Name\nAddress\nCountry\nPhone', 'This is the Store Name, Address and Phone used on printable documents and displayed online', '1', '18', 'osc_cfg_set_textarea_field', now());
      
 !
 
…
814814 INSERT INTO osc_configuration_group VALUES ('18', 'Program Locations', 'Locations to certain programs on the server.', '18', '1');
  815815 
  816816 INSERT INTO osc_countries VALUES (1,'Afghanistan','AF','AFG','');
<>  817+
   818+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'BDS','بد خشان');
   819+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'BDG','بادغیس');
   820+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'BGL','بغلان');
   821+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'BAL','بلخ');
   822+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'BAM','بامیان');
   823+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'DAY','دایکندی');
   824+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'FRA','فراه');
   825+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'FYB','فارياب');
   826+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'GHA','غزنى');
   827+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'GHO','غور');
   828+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'HEL','هلمند');
   829+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'HER','هرات');
   830+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'JOW','جوزجان');
   831+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'KAB','کابل');
   832+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'KAN','قندھار');
   833+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'KAP','کاپيسا');
   834+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'KHO','خوست');
   835+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'KNR','کُنَر');
   836+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'KDZ','كندوز');
   837+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'LAG','لغمان');
   838+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'LOW','لوګر');
   839+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'NAN','ننگرهار');
   840+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'NIM','نیمروز');
   841+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'NUR','نورستان');
   842+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'ORU','ؤروزگان');
   843+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'PIA','پکتیا');
   844+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'PKA','پکتيکا');
   845+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'PAN','پنج شیر');
   846+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'PAR','پروان');
   847+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'SAM','سمنگان');
   848+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'SAR','سر پل');
   849+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'TAK','تخار');
   850+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'WAR','وردک');
   851+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (1,'ZAB','زابل');
   852+
817853 INSERT INTO osc_countries VALUES (2,'Albania','AL','ALB','');
<>  854+
   855+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'BR','Beratit');
   856+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'BU','Bulqizës');
   857+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'DI','Dibrës');
   858+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'DL','Delvinës');
   859+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'DR','Durrësit');
   860+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'DV','Devollit');
   861+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'EL','Elbasanit');
   862+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'ER','Kolonjës');
   863+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'FR','Fierit');
   864+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'GJ','Gjirokastrës');
   865+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'GR','Gramshit');
   866+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'HA','Hasit');
   867+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'KA','Kavajës');
   868+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'KB','Kurbinit');
   869+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'KC','Kuçovës');
   870+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'KO','Korçës');
   871+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'KR','Krujës');
   872+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'KU','Kukësit');
   873+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'LB','Librazhdit');
   874+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'LE','Lezhës');
   875+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'LU','Lushnjës');
   876+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'MK','Mallakastrës');
   877+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'MM','Malësisë së Madhe');
   878+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'MR','Mirditës');
   879+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'MT','Matit');
   880+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'PG','Pogradecit');
   881+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'PQ','Peqinit');
   882+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'PR','Përmetit');
   883+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'PU','Pukës');
   884+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'SH','Shkodrës');
   885+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'SK','Skraparit');
   886+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'SR','Sarandës');
   887+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'TE','Tepelenës');
   888+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'TP','Tropojës');
   889+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'TR','Tiranës');
   890+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (2,'VL','Vlorës');
   891+
818892 INSERT INTO osc_countries VALUES (3,'Algeria','DZ','DZA','');
<>  893+
   894+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'01','ولاية أدرار');
   895+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'02','ولاية الشلف');
   896+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'03','ولاية الأغواط');
   897+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'04','ولاية أم البواقي');
   898+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'05','ولاية باتنة');
   899+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'06','ولاية بجاية');
   900+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'07','ولاية بسكرة');
   901+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'08','ولاية بشار');
   902+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'09','البليدة‎');
   903+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'10','ولاية البويرة');
   904+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'11','ولاية تمنراست');
   905+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'12','ولاية تبسة');
   906+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'13','تلمسان');
   907+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'14','ولاية تيارت');
   908+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'15','تيزي وزو');
   909+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'16','ولاية الجزائر');
   910+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'17','ولاية عين الدفلى');
   911+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'18','ولاية جيجل');
   912+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'19','ولاية سطيف');
   913+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'20','ولاية سعيدة');
   914+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'21','السكيكدة');
   915+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'22','ولاية سيدي بلعباس');
   916+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'23','ولاية عنابة');
   917+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'24','ولاية قالمة');
   918+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'25','قسنطينة');
   919+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'26','ولاية المدية');
   920+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'27','ولاية مستغانم');
   921+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'28','ولاية المسيلة');
   922+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'29','ولاية معسكر');
   923+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'30','ورقلة');
   924+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'31','وهران');
   925+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'32','ولاية البيض');
   926+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'33','ولاية اليزي');
   927+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'34','ولاية برج بوعريريج');
   928+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'35','ولاية بومرداس');
   929+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'36','ولاية الطارف');
   930+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'37','تندوف');
   931+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'38','ولاية تسمسيلت');
   932+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'39','ولاية الوادي');
   933+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'40','ولاية خنشلة');
   934+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'41','ولاية سوق أهراس');
   935+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'42','ولاية تيبازة');
   936+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'43','ولاية ميلة');
   937+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'44','ولاية عين الدفلى');
   938+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'45','ولاية النعامة');
   939+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'46','ولاية عين تموشنت');
   940+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'47','ولاية غرداية');
   941+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (3,'48','ولاية غليزان');
   942+
819943 INSERT INTO osc_countries VALUES (4,'American Samoa','AS','ASM','');
<>  944+
   945+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (4,'EA','Eastern');
   946+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (4,'MA','Manu\'a');
   947+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (4,'RI','Rose Island');
   948+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (4,'SI','Swains Island');
   949+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (4,'WE','Western');
   950+
820951 INSERT INTO osc_countries VALUES (5,'Andorra','AD','AND','');
<>  952+
   953+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (5,'AN','Andorra la Vella');
   954+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (5,'CA','Canillo');
   955+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (5,'EN','Encamp');
   956+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (5,'LE','Escaldes-Engordany');
   957+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (5,'LM','La Massana');
   958+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (5,'OR','Ordino');
   959+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (5,'SJ','Sant Juliá de Lória');
   960+
821961 INSERT INTO osc_countries VALUES (6,'Angola','AO','AGO','');
<>  962+
   963+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'BGO','Bengo');
   964+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'BGU','Benguela');
   965+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'BIE','Bié');
   966+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'CAB','Cabinda');
   967+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'CCU','Cuando Cubango');
   968+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'CNO','Cuanza Norte');
   969+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'CUS','Cuanza Sul');
   970+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'CNN','Cunene');
   971+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'HUA','Huambo');
   972+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'HUI','Huíla');
   973+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'LUA','Luanda');
   974+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'LNO','Lunda Norte');
   975+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'LSU','Lunda Sul');
   976+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'MAL','Malanje');
   977+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'MOX','Moxico');
   978+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'NAM','Namibe');
   979+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'UIG','Uíge');
   980+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (6,'ZAI','Zaire');
   981+
822982 INSERT INTO osc_countries VALUES (7,'Anguilla','AI','AIA','');
  823983 INSERT INTO osc_countries VALUES (8,'Antarctica','AQ','ATA','');
<>  984+
824985 INSERT INTO osc_countries VALUES (9,'Antigua and Barbuda','AG','ATG','');
<>  986+
   987+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (9,'BAR','Barbuda');
   988+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (9,'SGE','Saint George');
   989+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (9,'SJO','Saint John');
   990+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (9,'SMA','Saint Mary');
   991+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (9,'SPA','Saint Paul');
   992+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (9,'SPE','Saint Peter');
   993+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (9,'SPH','Saint Philip');
   994+
825995 INSERT INTO osc_countries VALUES (10,'Argentina','AR','ARG',":name\n:street_address\n:postcode :city\n:country");
<>  996+
   997+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'A','Salta');
   998+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'B','Buenos Aires Province');
   999+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'C','Capital Federal');
   1000+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'D','San Luis');
   1001+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'E','Entre Ríos');
   1002+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'F','La Rioja');
   1003+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'G','Santiago del Estero');
   1004+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'H','Chaco');
   1005+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'J','San Juan');
   1006+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'K','Catamarca');
   1007+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'L','La Pampa');
   1008+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'M','Mendoza');
   1009+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'N','Misiones');
   1010+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'P','Formosa');
   1011+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'Q','Neuquén');
   1012+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'R','Río Negro');
   1013+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'S','Santa Fe');
   1014+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'T','Tucumán');
   1015+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'U','Chubut');
   1016+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'V','Tierra del Fuego');
   1017+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'W','Corrientes');
   1018+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'X','Córdoba');
   1019+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'Y','Jujuy');
   1020+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (10,'Z','Santa Cruz');
   1021+
8261022 INSERT INTO osc_countries VALUES (11,'Armenia','AM','ARM','');
<>  1023+
   1024+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'AG','Արագածոտն');
   1025+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'AR','Արարատ');
   1026+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'AV','Արմավիր');
   1027+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'ER','Երևան');
   1028+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'GR','Գեղարքունիք');
   1029+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'KT','Կոտայք');
   1030+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'LO','Լոռի');
   1031+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'SH','Շիրակ');
   1032+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'SU','Սյունիք');
   1033+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'TV','Տավուշ');
   1034+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (11,'VD','Վայոց Ձոր');
   1035+
8271036 INSERT INTO osc_countries VALUES (12,'Aruba','AW','ABW','');
<>  1037+
8281038 INSERT INTO osc_countries VALUES (13,'Australia','AU','AUS',":name\n:street_address\n:suburb :state_code :postcode\n:country");
<>  1039+
   1040+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'ACT','Australian Capital Territory');
   1041+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'NSW','New South Wales');
   1042+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'NT','Northern Territory');
   1043+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'QLD','Queensland');
   1044+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'SA','South Australia');
   1045+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'TAS','Tasmania');
   1046+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'VIC','Victoria');
   1047+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'WA','Western Australia');
   1048+
8291049 INSERT INTO osc_countries VALUES (14,'Austria','AT','AUT',":name\n:street_address\nA-:postcode :city\n:country");
<>  1050+
   1051+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'1','Burgenland');
   1052+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'2','Kärnten');
   1053+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'3','Niederösterreich');
   1054+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'4','Oberösterreich');
   1055+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'5','Salzburg');
   1056+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'6','Steiermark');
   1057+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'7','Tirol');
   1058+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'8','Voralberg');
   1059+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'9','Wien');
   1060+
8301061 INSERT INTO osc_countries VALUES (15,'Azerbaijan','AZ','AZE','');
<>  1062+
   1063+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'AB','Əli Bayramlı');
   1064+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'ABS','Abşeron');
   1065+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'AGC','Ağcabədi');
   1066+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'AGM','Ağdam');
   1067+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'AGS','Ağdaş');
   1068+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'AGA','Ağstafa');
   1069+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'AGU','Ağsu');
   1070+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'AST','Astara');
   1071+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'BA','Bakı');
   1072+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'BAB','Babək');
   1073+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'BAL','Balakən');
   1074+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'BAR','Bərdə');
   1075+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'BEY','Beyləqan');
   1076+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'BIL','Biləsuvar');
   1077+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'CAB','Cəbrayıl');
   1078+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'CAL','Cəlilabab');
   1079+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'CUL','Julfa');
   1080+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'DAS','Daşkəsən');
   1081+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'DAV','Dəvəçi');
   1082+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'FUZ','Füzuli');
   1083+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'GA','Gəncə');
   1084+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'GAD','Gədəbəy');
   1085+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'GOR','Goranboy');
   1086+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'GOY','Göyçay');
   1087+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'HAC','Hacıqabul');
   1088+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'IMI','İmişli');
   1089+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'ISM','İsmayıllı');
   1090+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'KAL','Kəlbəcər');
   1091+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'KUR','Kürdəmir');
   1092+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'LA','Lənkəran');
   1093+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'LAC','Laçın');
   1094+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'LAN','Lənkəran');
   1095+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'LER','Lerik');
   1096+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'MAS','Masallı');
   1097+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'MI','Mingəçevir');
   1098+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'NA','Naftalan');
   1099+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'NEF','Neftçala');
   1100+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'OGU','Oğuz');
   1101+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'ORD','Ordubad');
   1102+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'QAB','Qəbələ');
   1103+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'QAX','Qax');
   1104+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'QAZ','Qazax');
   1105+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'QOB','Qobustan');
   1106+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'QBA','Quba');
   1107+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'QBI','Qubadlı');
   1108+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'QUS','Qusar');
   1109+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SA','Şəki');
   1110+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SAT','Saatlı');
   1111+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SAB','Sabirabad');
   1112+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SAD','Sədərək');
   1113+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SAH','Şahbuz');
   1114+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SAK','Şəki');
   1115+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SAL','Salyan');
   1116+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SM','Sumqayıt');
   1117+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SMI','Şamaxı');
   1118+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SKR','Şəmkir');
   1119+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SMX','Samux');
   1120+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SAR','Şərur');
   1121+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SIY','Siyəzən');
   1122+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SS','Şuşa (City)');
   1123+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'SUS','Şuşa');
   1124+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'TAR','Tərtər');
   1125+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'TOV','Tovuz');
   1126+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'UCA','Ucar');
   1127+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'XA','Xankəndi');
   1128+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'XAC','Xaçmaz');
   1129+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'XAN','Xanlar');
   1130+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'XIZ','Xızı');
   1131+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'XCI','Xocalı');
   1132+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'XVD','Xocavənd');
   1133+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'YAR','Yardımlı');
   1134+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'YE','Yevlax (City)');
   1135+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'YEV','Yevlax');
   1136+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'ZAN','Zəngilan');
   1137+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'ZAQ','Zaqatala');
   1138+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'ZAR','Zərdab');
   1139+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (15,'NX','Nakhichevan');
   1140+
8311141 INSERT INTO osc_countries VALUES (16,'Bahamas','BS','BHS','');
<>  1142+
   1143+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'AC','Acklins and Crooked Islands');
   1144+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'BI','Bimini');
   1145+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'CI','Cat Island');
   1146+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'EX','Exuma');
   1147+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'FR','Freeport');
   1148+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'FC','Fresh Creek');
   1149+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'GH','Governor\'s Harbour');
   1150+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'GT','Green Turtle Cay');
   1151+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'HI','Harbour Island');
   1152+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'HR','High Rock');
   1153+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'IN','Inagua');
   1154+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'KB','Kemps Bay');
   1155+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'LI','Long Island');
   1156+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'MH','Marsh Harbour');
   1157+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'MA','Mayaguana');
   1158+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'NP','New Providence');
   1159+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'NT','Nicholls Town and Berry Islands');
   1160+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'RI','Ragged Island');
   1161+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'RS','Rock Sound');
   1162+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'SS','San Salvador and Rum Cay');
   1163+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (16,'SP','Sandy Point');
   1164+
8321165 INSERT INTO osc_countries VALUES (17,'Bahrain','BH','BHR','');
<>  1166+
   1167+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'01','الحد');
   1168+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'02','المحرق');
   1169+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'03','المنامة');
   1170+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'04','جد حفص');
   1171+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'05','المنطقة الشمالية');
   1172+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'06','سترة');
   1173+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'07','المنطقة الوسطى');
   1174+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'08','مدينة عيسى');
   1175+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'09','الرفاع والمنطقة الجنوبية');
   1176+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'10','المنطقة الغربية');
   1177+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'11','جزر حوار');
   1178+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (17,'12','مدينة حمد');
   1179+
8331180 INSERT INTO osc_countries VALUES (18,'Bangladesh','BD','BGD','');
<>  1181+
   1182+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'01','Bandarban');
   1183+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'02','Barguna');
   1184+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'03','Bogra');
   1185+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'04','Brahmanbaria');
   1186+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'05','Bagerhat');
   1187+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'06','Barisal');
   1188+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'07','Bhola');
   1189+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'08','Comilla');
   1190+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'09','Chandpur');
   1191+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'10','Chittagong');
   1192+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'11','Cox\'s Bazar');
   1193+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'12','Chuadanga');
   1194+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'13','Dhaka');
   1195+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'14','Dinajpur');
   1196+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'15','Faridpur');
   1197+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'16','Feni');
   1198+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'17','Gopalganj');
   1199+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'18','Gazipur');
   1200+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'19','Gaibandha');
   1201+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'20','Habiganj');
   1202+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'21','Jamalpur');
   1203+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'22','Jessore');
   1204+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'23','Jhenaidah');
   1205+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'24','Jaipurhat');
   1206+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'25','Jhalakati');
   1207+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'26','Kishoreganj');
   1208+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'27','Khulna');
   1209+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'28','Kurigram');
   1210+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'29','Khagrachari');
   1211+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'30','Kushtia');
   1212+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'31','Lakshmipur');
   1213+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'32','Lalmonirhat');
   1214+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'33','Manikganj');
   1215+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'34','Mymensingh');
   1216+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'35','Munshiganj');
   1217+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'36','Madaripur');
   1218+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'37','Magura');
   1219+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'38','Moulvibazar');
   1220+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'39','Meherpur');
   1221+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'40','Narayanganj');
   1222+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'41','Netrakona');
   1223+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'42','Narsingdi');
   1224+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'43','Narail');
   1225+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'44','Natore');
   1226+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'45','Nawabganj');
   1227+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'46','Nilphamari');
   1228+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'47','Noakhali');
   1229+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'48','Naogaon');
   1230+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'49','Pabna');
   1231+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'50','Pirojpur');
   1232+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'51','Patuakhali');
   1233+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'52','Panchagarh');
   1234+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'53','Rajbari');
   1235+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'54','Rajshahi');
   1236+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'55','Rangpur');
   1237+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'56','Rangamati');
   1238+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'57','Sherpur');
   1239+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'58','Satkhira');
   1240+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'59','Sirajganj');
   1241+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'60','Sylhet');
   1242+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'61','Sunamganj');
   1243+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'62','Shariatpur');
   1244+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'63','Tangail');
   1245+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (18,'64','Thakurgaon');
   1246+
8341247 INSERT INTO osc_countries VALUES (19,'Barbados','BB','BRB','');
<>  1248+
   1249+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'A','Saint Andrew');
   1250+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'C','Christ Church');
   1251+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'E','Saint Peter');
   1252+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'G','Saint George');
   1253+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'J','Saint John');
   1254+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'L','Saint Lucy');
   1255+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'M','Saint Michael');
   1256+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'O','Saint Joseph');
   1257+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'P','Saint Philip');
   1258+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'S','Saint James');
   1259+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (19,'T','Saint Thomas');
   1260+
8351261 INSERT INTO osc_countries VALUES (20,'Belarus','BY','BLR','');
<>  1262+
   1263+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (20,'BR','Брэ́сцкая во́бласць');
   1264+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (20,'HO','Го́мельская во́бласць');
   1265+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (20,'HR','Гро́дзенская во́бласць');
   1266+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (20,'MA','Магілёўская во́бласць');
   1267+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (20,'MI','Мі́нская во́бласць');
   1268+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (20,'VI','Ві́цебская во́бласць');
   1269+
8361270 INSERT INTO osc_countries VALUES (21,'Belgium','BE','BEL',":name\n:street_address\nB-:postcode :city\n:country");
<>  1271+
   1272+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'BRU','Brussel');
   1273+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'VAN','Antwerpen');
   1274+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'VBR','Vlaams-Brabant');
   1275+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'VLI','Limburg');
   1276+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'VOV','Oost-Vlaanderen');
   1277+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'VWV','West-Vlaanderen');
   1278+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'WBR','Brabant Wallon');
   1279+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'WHT','Hainaut');
   1280+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'WLG','Liège/Lüttich');
   1281+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'WLX','Luxembourg');
   1282+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (21,'WNA','Namur');
   1283+
8371284 INSERT INTO osc_countries VALUES (22,'Belize','BZ','BLZ','');
<>  1285+
   1286+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (22,'BZ','Belize District');
   1287+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (22,'CY','Cayo District');
   1288+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (22,'CZL','Corozal District');
   1289+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (22,'OW','Orange Walk District');
   1290+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (22,'SC','Stann Creek District');
   1291+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (22,'TOL','Toledo District');
   1292+
8381293 INSERT INTO osc_countries VALUES (23,'Benin','BJ','BEN','');
<>  1294+
   1295+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'AL','Alibori');
   1296+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'AK','Atakora');
   1297+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'AQ','Atlantique');
   1298+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'BO','Borgou');
   1299+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'CO','Collines');
   1300+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'DO','Donga');
   1301+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'KO','Kouffo');
   1302+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'LI','Littoral');
   1303+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'MO','Mono');
   1304+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'OU','Ouémé');
   1305+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'PL','Plateau');
   1306+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (23,'ZO','Zou');
   1307+
8391308 INSERT INTO osc_countries VALUES (24,'Bermuda','BM','BMU','');
<>  1309+
   1310+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'DEV','Devonshire');
   1311+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'HA','Hamilton City');
   1312+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'HAM','Hamilton');
   1313+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'PAG','Paget');
   1314+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'PEM','Pembroke');
   1315+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'SAN','Sandys');
   1316+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'SG','Saint George City');
   1317+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'SGE','Saint George\'s');
   1318+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'SMI','Smiths');
   1319+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'SOU','Southampton');
   1320+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (24,'WAR','Warwick');
   1321+
8401322 INSERT INTO osc_countries VALUES (25,'Bhutan','BT','BTN','');
<>  1323+
   1324+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'11','Paro');
   1325+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'12','Chukha');
   1326+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'13','Haa');
   1327+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'14','Samtse');
   1328+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'15','Thimphu');
   1329+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'21','Tsirang');
   1330+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'22','Dagana');
   1331+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'23','Punakha');
   1332+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'24','Wangdue Phodrang');
   1333+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'31','Sarpang');
   1334+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'32','Trongsa');
   1335+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'33','Bumthang');
   1336+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'34','Zhemgang');
   1337+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'41','Trashigang');
   1338+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'42','Mongar');
   1339+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'43','Pemagatshel');
   1340+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'44','Luentse');
   1341+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'45','Samdrup Jongkhar');
   1342+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'GA','Gasa');
   1343+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (25,'TY','Trashiyangse');
   1344+
8411345 INSERT INTO osc_countries VALUES (26,'Bolivia','BO','BOL','');
<>  1346+
   1347+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'B','El Beni');
   1348+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'C','Cochabamba');
   1349+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'H','Chuquisaca');
   1350+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'L','La Paz');
   1351+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'N','Pando');
   1352+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'O','Oruro');
   1353+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'P','Potosí');
   1354+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'S','Santa Cruz');
   1355+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (26,'T','Tarija');
   1356+
8421357 INSERT INTO osc_countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','');
  8431358 INSERT INTO osc_countries VALUES (28,'Botswana','BW','BWA','');
<>  1359+
   1360+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'CE','Central');
   1361+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'GH','Ghanzi');
   1362+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'KG','Kgalagadi');
   1363+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'KL','Kgatleng');
   1364+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'KW','Kweneng');
   1365+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'NE','North-East');
   1366+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'NW','North-West');
   1367+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'SE','South-East');
   1368+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (28,'SO','Southern');
   1369+
8441370 INSERT INTO osc_countries VALUES (29,'Bouvet Island','BV','BVT','');
<>  1371+
8451372 INSERT INTO osc_countries VALUES (30,'Brazil','BR','BRA',":name\n:street_address\n:state\n:postcode\n:country");
<>  1373+
   1374+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'AC','Acre');
   1375+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'AL','Alagoas');
   1376+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'AM','Amazônia');
   1377+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'AP','Amapá');
   1378+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'BA','Bahia');
   1379+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'CE','Ceará');
   1380+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'DF','Distrito Federal');
   1381+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'ES','Espírito Santo');
   1382+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'GO','Goiás');
   1383+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'MA','Maranhão');
   1384+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'MG','Minas Gerais');
   1385+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'MS','Mato Grosso do Sul');
   1386+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'MT','Mato Grosso');
   1387+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'PA','Pará');
   1388+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'PB','Paraíba');
   1389+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'PE','Pernambuco');
   1390+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'PI','Piauí');
   1391+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'PR','Paraná');
   1392+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'RJ','Rio de Janeiro');
   1393+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'RN','Rio Grande do Norte');
   1394+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'RO','Rondônia');
   1395+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'RR','Roraima');
   1396+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'RS','Rio Grande do Sul');
   1397+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'SC','Santa Catarina');
   1398+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'SE','Sergipe');
   1399+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'SP','São Paulo');
   1400+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (30,'TO','Tocantins');
   1401+
8461402 INSERT INTO osc_countries VALUES (31,'British Indian Ocean Territory','IO','IOT','');
<>  1403+
   1404+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'PB','Peros Banhos');
   1405+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'SI','Salomon Islands');
   1406+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'NI','Nelsons Island');
   1407+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'TB','Three Brothers');
   1408+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'EA','Eagle Islands');
   1409+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'DI','Danger Island');
   1410+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'EG','Egmont Islands');
   1411+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (31,'DG','Diego Garcia');
   1412+
8471413 INSERT INTO osc_countries VALUES (32,'Brunei Darussalam','BN','BRN','');
<>  1414+
   1415+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (32,'BE','Belait');
   1416+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (32,'BM','Brunei-Muara');
   1417+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (32,'TE','Temburong');
   1418+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (32,'TU','Tutong');
   1419+
8481420 INSERT INTO osc_countries VALUES (33,'Bulgaria','BG','BGR','');
<>  1421+
   1422+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'01','Blagoevgrad');
   1423+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'02','Burgas');
   1424+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'03','Varna');
   1425+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'04','Veliko Tarnovo');
   1426+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'05','Vidin');
   1427+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'06','Vratsa');
   1428+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'07','Gabrovo');
   1429+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'08','Dobrich');
   1430+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'09','Kardzhali');
   1431+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'10','Kyustendil');
   1432+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'11','Lovech');
   1433+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'12','Montana');
   1434+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'13','Pazardzhik');
   1435+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'14','Pernik');
   1436+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'15','Pleven');
   1437+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'16','Plovdiv');
   1438+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'17','Razgrad');
   1439+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'18','Ruse');
   1440+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'19','Silistra');
   1441+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'20','Sliven');
   1442+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'21','Smolyan');
   1443+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'23','Sofia');
   1444+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'22','Sofia Province');
   1445+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'24','Stara Zagora');
   1446+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'25','Targovishte');
   1447+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'26','Haskovo');
   1448+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'27','Shumen');
   1449+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (33,'28','Yambol');
   1450+
8491451 INSERT INTO osc_countries VALUES (34,'Burkina Faso','BF','BFA','');
<>  1452+
   1453+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'BAL','Balé');
   1454+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'BAM','Bam');
   1455+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'BAN','Banwa');
   1456+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'BAZ','Bazèga');
   1457+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'BGR','Bougouriba');
   1458+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'BLG','Boulgou');
   1459+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'BLK','Boulkiemdé');
   1460+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'COM','Komoé');
   1461+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'GAN','Ganzourgou');
   1462+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'GNA','Gnagna');
   1463+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'GOU','Gourma');
   1464+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'HOU','Houet');
   1465+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'IOB','Ioba');
   1466+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KAD','Kadiogo');
   1467+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KEN','Kénédougou');
   1468+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KMD','Komondjari');
   1469+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KMP','Kompienga');
   1470+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KOP','Koulpélogo');
   1471+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KOS','Kossi');
   1472+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KOT','Kouritenga');
   1473+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'KOW','Kourwéogo');
   1474+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'LER','Léraba');
   1475+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'LOR','Loroum');
   1476+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'MOU','Mouhoun');
   1477+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'NAM','Namentenga');
   1478+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'NAO','Naouri');
   1479+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'NAY','Nayala');
   1480+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'NOU','Noumbiel');
   1481+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'OUB','Oubritenga');
   1482+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'OUD','Oudalan');
   1483+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'PAS','Passoré');
   1484+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'PON','Poni');
   1485+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'SEN','Séno');
   1486+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'SIS','Sissili');
   1487+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'SMT','Sanmatenga');
   1488+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'SNG','Sanguié');
   1489+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'SOM','Soum');
   1490+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'SOR','Sourou');
   1491+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'TAP','Tapoa');
   1492+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'TUI','Tui');
   1493+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'YAG','Yagha');
   1494+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'YAT','Yatenga');
   1495+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'ZIR','Ziro');
   1496+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'ZON','Zondoma');
   1497+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (34,'ZOU','Zoundwéogo');
   1498+
8501499 INSERT INTO osc_countries VALUES (35,'Burundi','BI','BDI','');
<>  1500+
   1501+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'BB','Bubanza');
   1502+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'BJ','Bujumbura Mairie');
   1503+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'BR','Bururi');
   1504+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'CA','Cankuzo');
   1505+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'CI','Cibitoke');
   1506+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'GI','Gitega');
   1507+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'KR','Karuzi');
   1508+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'KY','Kayanza');
   1509+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'KI','Kirundo');
   1510+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'MA','Makamba');
   1511+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'MU','Muramvya');
   1512+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'MY','Muyinga');
   1513+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'MW','Mwaro');
   1514+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'NG','Ngozi');
   1515+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'RT','Rutana');
   1516+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (35,'RY','Ruyigi');
   1517+
8511518 INSERT INTO osc_countries VALUES (36,'Cambodia','KH','KHM','');
<>  1519+
8521520 INSERT INTO osc_countries VALUES (37,'Cameroon','CM','CMR','');
<>  1521+
   1522+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'AD','Adamaoua');
   1523+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'CE','Centre');
   1524+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'EN','Extrême-Nord');
   1525+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'ES','Est');
   1526+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'LT','Littoral');
   1527+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'NO','Nord');
   1528+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'NW','Nord-Ouest');
   1529+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'OU','Ouest');
   1530+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'SU','Sud');
   1531+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (37,'SW','Sud-Ouest');
   1532+
8531533 INSERT INTO osc_countries VALUES (38,'Canada','CA','CAN',":name\n:street_address\n:city :state_code :postcode\n:country");
<>  1534+
   1535+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'AB','Alberta');
   1536+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'BC','British Columbia');
   1537+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'MB','Manitoba');
   1538+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NB','New Brunswick');
   1539+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NL','Newfoundland and Labrador');
   1540+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NS','Nova Scotia');
   1541+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NT','Northwest Territories');
   1542+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NU','Nunavut');
   1543+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'ON','Ontario');
   1544+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'PE','Prince Edward Island');
   1545+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'QC','Quebec');
   1546+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'SK','Saskatchewan');
   1547+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'YT','Yukon Territory');
   1548+
8541549 INSERT INTO osc_countries VALUES (39,'Cape Verde','CV','CPV','');
<>  1550+
   1551+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'BR','Brava');
   1552+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'BV','Boa Vista');
   1553+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'CA','Santa Catarina');
   1554+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'CR','Santa Cruz');
   1555+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'CS','Calheta de São Miguel');
   1556+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'MA','Maio');
   1557+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'MO','Mosteiros');
   1558+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'PA','Paúl');
   1559+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'PN','Porto Novo');
   1560+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'PR','Praia');
   1561+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'RG','Ribeira Grande');
   1562+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'SD','São Domingos');
   1563+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'SF','São Filipe');
   1564+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'SL','Sal');
   1565+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'SN','São Nicolau');
   1566+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'SV','São Vicente');
   1567+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (39,'TA','Tarrafal');
   1568+
8551569 INSERT INTO osc_countries VALUES (40,'Cayman Islands','KY','CYM','');
<>  1570+
   1571+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'CR','Creek');
   1572+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'EA','Eastern');
   1573+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'MI','Midland');
   1574+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'SO','South Town');
   1575+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'SP','Spot Bay');
   1576+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'ST','Stake Bay');
   1577+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'WD','West End');
   1578+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (40,'WN','Western');
   1579+
8561580 INSERT INTO osc_countries VALUES (41,'Central African Republic','CF','CAF','');
<>  1581+
   1582+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'AC ','Ouham');
   1583+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'BB ','Bamingui-Bangoran');
   1584+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'BGF','Bangui');
   1585+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'BK ','Basse-Kotto');
   1586+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'HK ','Haute-Kotto');
   1587+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'HM ','Haut-Mbomou');
   1588+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'HS ','Mambéré-Kadéï');
   1589+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'KB ','Nana-Grébizi');
   1590+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'KG ','Kémo');
   1591+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'LB ','Lobaye');
   1592+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'MB ','Mbomou');
   1593+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'MP ','Ombella-M\'Poko');
   1594+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'NM ','Nana-Mambéré');
   1595+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'OP ','Ouham-Pendé');
   1596+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'SE ','Sangha-Mbaéré');
   1597+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'UK ','Ouaka');
   1598+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (41,'VR ','Vakaga');
   1599+
8571600 INSERT INTO osc_countries VALUES (42,'Chad','TD','TCD','');
<>  1601+
   1602+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'BA ','Batha');
   1603+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'BET','Borkou-Ennedi-Tibesti');
   1604+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'BI ','Biltine');
   1605+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'CB ','Chari-Baguirmi');
   1606+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'GR ','Guéra');
   1607+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'KA ','Kanem');
   1608+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'LC ','Lac');
   1609+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'LR ','Logone-Oriental');
   1610+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'LO ','Logone-Occidental');
   1611+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'MC ','Moyen-Chari');
   1612+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'MK ','Mayo-Kébbi');
   1613+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'OD ','Ouaddaï');
   1614+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'SA ','Salamat');
   1615+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (42,'TA ','Tandjilé');
   1616+
8581617 INSERT INTO osc_countries VALUES (43,'Chile','CL','CHL',":name\n:street_address\n:city\n:country");
<>  1618+
   1619+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AI','Aisén del General Carlos Ibañez');
   1620+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AN','Antofagasta');
   1621+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AR','La Araucanía');
   1622+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AT','Atacama');
   1623+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'BI','Biobío');
   1624+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'CO','Coquimbo');
   1625+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'LI','Libertador Bernardo O\'Higgins');
   1626+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'LL','Los Lagos');
   1627+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'MA','Magallanes y de la Antartica');
   1628+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'ML','Maule');
   1629+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'RM','Metropolitana de Santiago');
   1630+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'TA','Tarapacá');
   1631+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'VS','Valparaíso');
   1632+
8591633 INSERT INTO osc_countries VALUES (44,'China','CN','CHN',":name\n:street_address\n:postcode :city\n:country");
<>  1634+
   1635+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'11','北京');
   1636+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'12','天津');
   1637+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'13','河北');
   1638+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'14','山西');
   1639+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'15','内蒙古自治区');
   1640+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'21','辽宁');
   1641+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'22','吉林');
   1642+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'23','黑龙江省');
   1643+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'31','上海');
   1644+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'32','江苏');
   1645+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'33','浙江');
   1646+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'34','安徽');
   1647+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'35','福建');
   1648+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'36','江西');
   1649+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'37','山东');
   1650+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'41','河南');
   1651+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'42','湖北');
   1652+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'43','湖南');
   1653+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'44','广东');
   1654+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'45','广西壮族自治区');
   1655+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'46','海南');
   1656+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'50','重庆');
   1657+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'51','四川');
   1658+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'52','贵州');
   1659+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'53','云南');
   1660+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'54','西藏自治区');
   1661+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'61','陕西');
   1662+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'62','甘肃');
   1663+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'63','青海');
   1664+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'64','宁夏');
   1665+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'65','新疆');
   1666+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'71','臺灣');
   1667+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'91','香港');
   1668+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (44,'92','澳門');
   1669+
8601670 INSERT INTO osc_countries VALUES (45,'Christmas Island','CX','CXR','');
<>  1671+
8611672 INSERT INTO osc_countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','');
<>  1673+
   1674+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (46,'D','Direction Island');
   1675+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (46,'H','Home Island');
   1676+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (46,'O','Horsburgh Island');
   1677+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (46,'S','South Island');
   1678+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (46,'W','West Island');
   1679+
8621680 INSERT INTO osc_countries VALUES (47,'Colombia','CO','COL','');
<>  1681+
   1682+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'AMA','Amazonas');
   1683+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'ANT','Antioquia');
   1684+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'ARA','Arauca');
   1685+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'ATL','Atlántico');
   1686+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'BOL','Bolívar');
   1687+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'BOY','Boyacá');
   1688+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'CAL','Caldas');
   1689+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'CAQ','Caquetá');
   1690+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'CAS','Casanare');
   1691+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'CAU','Cauca');
   1692+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'CES','Cesar');
   1693+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'CHO','Chocó');
   1694+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'COR','Córdoba');
   1695+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'CUN','Cundinamarca');
   1696+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'DC','Bogotá Distrito Capital');
   1697+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'GUA','Guainía');
   1698+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'GUV','Guaviare');
   1699+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'HUI','Huila');
   1700+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'LAG','La Guajira');
   1701+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'MAG','Magdalena');
   1702+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'MET','Meta');
   1703+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'NAR','Nariño');
   1704+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'NSA','Norte de Santander');
   1705+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'PUT','Putumayo');
   1706+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'QUI','Quindío');
   1707+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'RIS','Risaralda');
   1708+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'SAN','Santander');
   1709+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'SAP','San Andrés y Providencia');
   1710+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'SUC','Sucre');
   1711+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'TOL','Tolima');
   1712+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'VAC','Valle del Cauca');
   1713+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'VAU','Vaupés');
   1714+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (47,'VID','Vichada');
   1715+
8631716 INSERT INTO osc_countries VALUES (48,'Comoros','KM','COM','');
<>  1717+
   1718+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (48,'A','Anjouan');
   1719+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (48,'G','Grande Comore');
   1720+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (48,'M','Mohéli');
   1721+
8641722 INSERT INTO osc_countries VALUES (49,'Congo','CG','COG','');
<>  1723+
   1724+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'BC','Congo-Central');
   1725+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'BN','Bandundu');
   1726+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'EQ','Équateur');
   1727+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'KA','Katanga');
   1728+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'KE','Kasai-Oriental');
   1729+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'KN','Kinshasa');
   1730+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'KW','Kasai-Occidental');
   1731+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'MA','Maniema');
   1732+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'NK','Nord-Kivu');
   1733+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'OR','Orientale');
   1734+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (49,'SK','Sud-Kivu');
   1735+
8651736 INSERT INTO osc_countries VALUES (50,'Cook Islands','CK','COK','');
<>  1737+
   1738+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'PU','Pukapuka');
   1739+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'RK','Rakahanga');
   1740+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'MK','Manihiki');
   1741+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'PE','Penrhyn');
   1742+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'NI','Nassau Island');
   1743+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'SU','Surwarrow');
   1744+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'PA','Palmerston');
   1745+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'AI','Aitutaki');
   1746+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'MA','Manuae');
   1747+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'TA','Takutea');
   1748+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'MT','Mitiaro');
   1749+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'AT','Atiu');
   1750+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'MU','Mauke');
   1751+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'RR','Rarotonga');
   1752+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (50,'MG','Mangaia');
   1753+
8661754 INSERT INTO osc_countries VALUES (51,'Costa Rica','CR','CRI','');
<>  1755+
   1756+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (51,'A','Alajuela');
   1757+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (51,'C','Cartago');
   1758+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (51,'G','Guanacaste');
   1759+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (51,'H','Heredia');
   1760+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (51,'L','Limón');
   1761+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (51,'P','Puntarenas');
   1762+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (51,'SJ','San José');
   1763+
8671764 INSERT INTO osc_countries VALUES (52,'Cote D\'Ivoire','CI','CIV','');
<>  1765+
   1766+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'01','Lagunes');
   1767+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'02','Haut-Sassandra');
   1768+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'03','Savanes');
   1769+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'04','Vallée du Bandama');
   1770+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'05','Moyen-Comoé');
   1771+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'06','Dix-Huit');
   1772+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'07','Lacs');
   1773+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'08','Zanzan');
   1774+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'09','Bas-Sassandra');
   1775+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'10','Denguélé');
   1776+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'11','N\'zi-Comoé');
   1777+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'12','Marahoué');
   1778+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'13','Sud-Comoé');
   1779+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'14','Worodouqou');
   1780+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'15','Sud-Bandama');
   1781+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'16','Agnébi');
   1782+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'17','Bafing');
   1783+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'18','Fromager');
   1784+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (52,'19','Moyen-Cavally');
   1785+
8681786 INSERT INTO osc_countries VALUES (53,'Croatia','HR','HRV','');
<>  1787+
   1788+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'01','Zagrebačka županija');
   1789+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'02','Krapinsko-zagorska županija');
   1790+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'03','Sisačko-moslavačka županija');
   1791+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'04','Karlovačka županija');
   1792+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'05','Varaždinska županija');
   1793+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'06','Koprivničko-križevačka županija');
   1794+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'07','Bjelovarsko-bilogorska županija');
   1795+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'08','Primorsko-goranska županija');
   1796+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'09','Ličko-senjska županija');
   1797+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'10','Virovitičko-podravska županija');
   1798+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'11','Požeško-slavonska županija');
   1799+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'12','Brodsko-posavska županija');
   1800+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'13','Zadarska županija');
   1801+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'14','Osječko-baranjska županija');
   1802+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'15','Šibensko-kninska županija');
   1803+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'16','Vukovarsko-srijemska županija');
   1804+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'17','Splitsko-dalmatinska županija');
   1805+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'18','Istarska županija');
   1806+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'19','Dubrovačko-neretvanska županija');
   1807+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'20','Međimurska županija');
   1808+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (53,'21','Zagreb');
   1809+
8691810 INSERT INTO osc_countries VALUES (54,'Cuba','CU','CUB','');
<>  1811+
   1812+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'01','Pinar del Río');
   1813+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'02','La Habana');
   1814+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'03','Ciudad de La Habana');
   1815+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'04','Matanzas');
   1816+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'05','Villa Clara');
   1817+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'06','Cienfuegos');
   1818+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'07','Sancti Spíritus');
   1819+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'08','Ciego de Ávila');
   1820+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'09','Camagüey');
   1821+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'10','Las Tunas');
   1822+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'11','Holguín');
   1823+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'12','Granma');
   1824+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'13','Santiago de Cuba');
   1825+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'14','Guantánamo');
   1826+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (54,'99','Isla de la Juventud');
   1827+
8701828 INSERT INTO osc_countries VALUES (55,'Cyprus','CY','CYP','');
<>  1829+
   1830+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (55,'01','Κερύvεια');
   1831+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (55,'02','Λευκωσία');
   1832+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (55,'03','Αμμόχωστος');
   1833+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (55,'04','Λάρνακα');
   1834+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (55,'05','Λεμεσός');
   1835+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (55,'06','Πάφος');
   1836+
8711837 INSERT INTO osc_countries VALUES (56,'Czech Republic','CZ','CZE','');
<>  1838+
   1839+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'JC','Jihočeský kraj');
   1840+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'JM','Jihomoravský kraj');
   1841+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'KA','Karlovarský kraj');
   1842+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'VY','Vysočina kraj');
   1843+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'KR','Královéhradecký kraj');
   1844+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'LI','Liberecký kraj');
   1845+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'MO','Moravskoslezský kraj');
   1846+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'OL','Olomoucký kraj');
   1847+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'PA','Pardubický kraj');
   1848+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'PL','Plzeňský kraj');
   1849+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'PR','Hlavní město Praha');
   1850+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'ST','Středočeský kraj');
   1851+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'US','Ústecký kraj');
   1852+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (56,'ZL','Zlínský kraj');
   1853+
8721854 INSERT INTO osc_countries VALUES (57,'Denmark','DK','DNK',":name\n:street_address\nDK-:postcode :city\n:country");
<>  1855+
   1856+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'040','Bornholms Regionskommune');
   1857+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'101','København');
   1858+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'147','Frederiksberg');
   1859+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'070','Århus Amt');
   1860+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'015','Københavns Amt');
   1861+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'020','Frederiksborg Amt');
   1862+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'042','Fyns Amt');
   1863+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'080','Nordjyllands Amt');
   1864+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'055','Ribe Amt');
   1865+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'065','Ringkjøbing Amt');
   1866+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'025','Roskilde Amt');
   1867+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'050','Sønderjyllands Amt');
   1868+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'035','Storstrøms Amt');
   1869+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'060','Vejle Amt');
   1870+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'030','Vestsjællands Amt');
   1871+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (57,'076','Viborg Amt');
   1872+
8731873 INSERT INTO osc_countries VALUES (58,'Djibouti','DJ','DJI','');
<>  1874+
   1875+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (58,'AS','Region d\'Ali Sabieh');
   1876+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (58,'AR','Region d\'Arta');
   1877+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (58,'DI','Region de Dikhil');
   1878+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (58,'DJ','Ville de Djibouti');
   1879+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (58,'OB','Region d\'Obock');
   1880+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (58,'TA','Region de Tadjourah');
   1881+
8741882 INSERT INTO osc_countries VALUES (59,'Dominica','DM','DMA','');
<>  1883+
   1884+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'AND','Saint Andrew Parish');
   1885+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'DAV','Saint David Parish');
   1886+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'GEO','Saint George Parish');
   1887+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'JOH','Saint John Parish');
   1888+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'JOS','Saint Joseph Parish');
   1889+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'LUK','Saint Luke Parish');
   1890+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'MAR','Saint Mark Parish');
   1891+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'PAT','Saint Patrick Parish');
   1892+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'PAU','Saint Paul Parish');
   1893+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (59,'PET','Saint Peter Parish');
   1894+
8751895 INSERT INTO osc_countries VALUES (60,'Dominican Republic','DO','DOM','');
<>  1896+
   1897+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'01','Distrito Nacional');
   1898+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'02','Ázua');
   1899+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'03','Baoruco');
   1900+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'04','Barahona');
   1901+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'05','Dajabón');
   1902+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'06','Duarte');
   1903+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'07','Elías Piña');
   1904+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'08','El Seibo');
   1905+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'09','Espaillat');
   1906+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'10','Independencia');
   1907+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'11','La Altagracia');
   1908+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'12','La Romana');
   1909+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'13','La Vega');
   1910+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'14','María Trinidad Sánchez');
   1911+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'15','Monte Cristi');
   1912+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'16','Pedernales');
   1913+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'17','Peravia');
   1914+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'18','Puerto Plata');
   1915+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'19','Salcedo');
   1916+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'20','Samaná');
   1917+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'21','San Cristóbal');
   1918+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'22','San Juan');
   1919+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'23','San Pedro de Macorís');
   1920+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'24','Sánchez Ramírez');
   1921+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'25','Santiago');
   1922+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'26','Santiago Rodríguez');
   1923+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'27','Valverde');
   1924+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'28','Monseñor Nouel');
   1925+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'29','Monte Plata');
   1926+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (60,'30','Hato Mayor');
   1927+
8761928 INSERT INTO osc_countries VALUES (61,'East Timor','TP','TMP','');
<>  1929+
   1930+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'AL','Aileu');
   1931+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'AN','Ainaro');
   1932+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'BA','Baucau');
   1933+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'BO','Bobonaro');
   1934+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'CO','Cova-Lima');
   1935+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'DI','Dili');
   1936+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'ER','Ermera');
   1937+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'LA','Lautem');
   1938+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'LI','Liquiçá');
   1939+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'MF','Manufahi');
   1940+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'MT','Manatuto');
   1941+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'OE','Oecussi');
   1942+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (61,'VI','Viqueque');
   1943+
8771944 INSERT INTO osc_countries VALUES (62,'Ecuador','EC','ECU','');
<>  1945+
   1946+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'A','Azuay');
   1947+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'B','Bolívar');
   1948+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'C','Carchi');
   1949+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'D','Orellana');
   1950+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'E','Esmeraldas');
   1951+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'F','Cañar');
   1952+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'G','Guayas');
   1953+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'H','Chimborazo');
   1954+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'I','Imbabura');
   1955+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'L','Loja');
   1956+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'M','Manabí');
   1957+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'N','Napo');
   1958+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'O','El Oro');
   1959+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'P','Pichincha');
   1960+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'R','Los Ríos');
   1961+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'S','Morona-Santiago');
   1962+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'T','Tungurahua');
   1963+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'U','Sucumbíos');
   1964+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'W','Galápagos');
   1965+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'X','Cotopaxi');
   1966+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'Y','Pastaza');
   1967+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (62,'Z','Zamora-Chinchipe');
   1968+
8781969 INSERT INTO osc_countries VALUES (63,'Egypt','EG','EGY','');
<>  1970+
   1971+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'ALX','الإسكندرية');
   1972+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'ASN','أسوان');
   1973+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'AST','أسيوط');
   1974+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'BA','البحر الأحمر');
   1975+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'BH','البحيرة');
   1976+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'BNS','بني سويف');
   1977+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'C','القاهرة');
   1978+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'DK','الدقهلية');
   1979+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'DT','دمياط');
   1980+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'FYM','الفيوم');
   1981+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'GH','الغربية');
   1982+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'GZ','الجيزة');
   1983+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'IS','الإسماعيلية');
   1984+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'JS','جنوب سيناء');
   1985+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'KB','القليوبية');
   1986+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'KFS','كفر الشيخ');
   1987+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'KN','قنا');
   1988+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'MN','محافظة المنيا');
   1989+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'MNF','المنوفية');
   1990+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'MT','مطروح');
   1991+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'PTS','محافظة بور سعيد');
   1992+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'SHG','محافظة سوهاج');
   1993+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'SHR','المحافظة الشرقيّة');
   1994+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'SIN','شمال سيناء');
   1995+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'SUZ','السويس');
   1996+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (63,'WAD','الوادى الجديد');
   1997+
8791998 INSERT INTO osc_countries VALUES (64,'El Salvador','SV','SLV','');
<>  1999+
   2000+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'AH','Ahuachapán');
   2001+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'CA','Cabañas');
   2002+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'CH','Chalatenango');
   2003+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'CU','Cuscatlán');
   2004+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'LI','La Libertad');
   2005+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'MO','Morazán');
   2006+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'PA','La Paz');
   2007+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'SA','Santa Ana');
   2008+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'SM','San Miguel');
   2009+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'SO','Sonsonate');
   2010+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'SS','San Salvador');
   2011+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'SV','San Vicente');
   2012+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'UN','La Unión');
   2013+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (64,'US','Usulután');
   2014+
8802015 INSERT INTO osc_countries VALUES (65,'Equatorial Guinea','GQ','GNQ','');
<>  2016+
   2017+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (65,'AN','Annobón');
   2018+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (65,'BN','Bioko Norte');
   2019+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (65,'BS','Bioko Sur');
   2020+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (65,'CS','Centro Sur');
   2021+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (65,'KN','Kié-Ntem');
   2022+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (65,'LI','Litoral');
   2023+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (65,'WN','Wele-Nzas');
   2024+
8812025 INSERT INTO osc_countries VALUES (66,'Eritrea','ER','ERI','');
<>  2026+
   2027+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (66,'AN','Zoba Anseba');
   2028+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (66,'DK','Zoba Debubawi Keyih Bahri');
   2029+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (66,'DU','Zoba Debub');
   2030+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (66,'GB','Zoba Gash-Barka');
   2031+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (66,'MA','Zoba Ma\'akel');
   2032+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (66,'SK','Zoba Semienawi Keyih Bahri');
   2033+
8822034 INSERT INTO osc_countries VALUES (67,'Estonia','EE','EST','');
<>  2035+
   2036+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'37','Harju maakond');
   2037+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'39','Hiiu maakond');
   2038+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'44','Ida-Viru maakond');
   2039+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'49','Jõgeva maakond');
   2040+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'51','Järva maakond');
   2041+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'57','Lääne maakond');
   2042+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'59','Lääne-Viru maakond');
   2043+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'65','Põlva maakond');
   2044+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'67','Pärnu maakond');
   2045+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'70','Rapla maakond');
   2046+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'74','Saare maakond');
   2047+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'78','Tartu maakond');
   2048+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'82','Valga maakond');
   2049+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'84','Viljandi maakond');
   2050+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (67,'86','Võru maakond');
   2051+
8832052 INSERT INTO osc_countries VALUES (68,'Ethiopia','ET','ETH','');
<>  2053+
   2054+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'AA','አዲስ አበባ');
   2055+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'AF','አፋር');
   2056+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'AH','አማራ');
   2057+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'BG','ቤንሻንጉል-ጉምዝ');
   2058+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'DD','ድሬዳዋ');
   2059+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'GB','ጋምቤላ ሕዝቦች');
   2060+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'HR','ሀረሪ ሕዝብ');
   2061+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'OR','ኦሮሚያ');
   2062+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'SM','ሶማሌ');
   2063+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'SN','ደቡብ ብሔሮች ብሔረሰቦችና ሕዝቦች');
   2064+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (68,'TG','ትግራይ');
   2065+
8842066 INSERT INTO osc_countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','');
  8852067 INSERT INTO osc_countries VALUES (70,'Faroe Islands','FO','FRO','');
<>  2068+
8862069 INSERT INTO osc_countries VALUES (71,'Fiji','FJ','FJI','');
<>  2070+
   2071+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (71,'C','Central');
   2072+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (71,'E','Northern');
   2073+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (71,'N','Eastern');
   2074+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (71,'R','Rotuma');
   2075+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (71,'W','Western');
   2076+
8872077 INSERT INTO osc_countries VALUES (72,'Finland','FI','FIN',":name\n:street_address\nFIN-:postcode :city\n:country");
<>  2078+
   2079+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (72,'AL','Ahvenanmaan maakunta');
   2080+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (72,'ES','Etelä-Suomen lääni');
   2081+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (72,'IS','Itä-Suomen lääni');
   2082+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (72,'LL','Lapin lääni');
   2083+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (72,'LS','Länsi-Suomen lääni');
   2084+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (72,'OL','Oulun lääni');
   2085+
8882086 INSERT INTO osc_countries VALUES (73,'France','FR','FRA',":name\n:street_address\n:postcode :city\n:country");
<>  2087+
   2088+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'01','Ain');
   2089+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'02','Aisne');
   2090+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'03','Allier');
   2091+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'04','Alpes-de-Haute-Provence');
   2092+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'05','Hautes-Alpes');
   2093+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'06','Alpes-Maritimes');
   2094+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'07','Ardèche');
   2095+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'08','Ardennes');
   2096+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'09','Ariège');
   2097+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'10','Aube');
   2098+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'11','Aude');
   2099+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'12','Aveyron');
   2100+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'13','Bouches-du-Rhône');
   2101+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'14','Calvados');
   2102+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'15','Cantal');
   2103+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'16','Charente');
   2104+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'17','Charente-Maritime');
   2105+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'18','Cher');
   2106+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'19','Corrèze');
   2107+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'21','Côte-d\'Or');
   2108+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'22','Côtes-d\'Armor');
   2109+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'23','Creuse');
   2110+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'24','Dordogne');
   2111+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'25','Doubs');
   2112+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'26','Drôme');
   2113+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'27','Eure');
   2114+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'28','Eure-et-Loir');
   2115+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'29','Finistère');
   2116+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'2A','Corse-du-Sud');
   2117+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'2B','Haute-Corse');
   2118+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'30','Gard');
   2119+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'31','Haute-Garonne');
   2120+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'32','Gers');
   2121+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'33','Gironde');
   2122+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'34','Hérault');
   2123+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'35','Ille-et-Vilaine');
   2124+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'36','Indre');
   2125+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'37','Indre-et-Loire');
   2126+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'38','Isère');
   2127+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'39','Jura');
   2128+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'40','Landes');
   2129+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'41','Loir-et-Cher');
   2130+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'42','Loire');
   2131+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'43','Haute-Loire');
   2132+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'44','Loire-Atlantique');
   2133+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'45','Loiret');
   2134+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'46','Lot');
   2135+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'47','Lot-et-Garonne');
   2136+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'48','Lozère');
   2137+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'49','Maine-et-Loire');
   2138+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'50','Manche');
   2139+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'51','Marne');
   2140+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'52','Haute-Marne');
   2141+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'53','Mayenne');
   2142+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'54','Meurthe-et-Moselle');
   2143+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'55','Meuse');
   2144+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'56','Morbihan');
   2145+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'57','Moselle');
   2146+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'58','Nièvre');
   2147+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'59','Nord');
   2148+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'60','Oise');
   2149+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'61','Orne');
   2150+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'62','Pas-de-Calais');
   2151+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'63','Puy-de-Dôme');
   2152+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'64','Pyrénées-Atlantiques');
   2153+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'65','Hautes-Pyrénées');
   2154+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'66','Pyrénées-Orientales');
   2155+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'67','Bas-Rhin');
   2156+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'68','Haut-Rhin');
   2157+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'69','Rhône');
   2158+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'70','Haute-Saône');
   2159+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'71','Saône-et-Loire');
   2160+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'72','Sarthe');
   2161+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'73','Savoie');
   2162+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'74','Haute-Savoie');
   2163+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'75','Paris');
   2164+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'76','Seine-Maritime');
   2165+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'77','Seine-et-Marne');
   2166+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'78','Yvelines');
   2167+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'79','Deux-Sèvres');
   2168+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'80','Somme');
   2169+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'81','Tarn');
   2170+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'82','Tarn-et-Garonne');
   2171+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'83','Var');
   2172+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'84','Vaucluse');
   2173+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'85','Vendée');
   2174+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'86','Vienne');
   2175+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'87','Haute-Vienne');
   2176+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'88','Vosges');
   2177+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'89','Yonne');
   2178+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'90','Territoire de Belfort');
   2179+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'91','Essonne');
   2180+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'92','Hauts-de-Seine');
   2181+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'93','Seine-Saint-Denis');
   2182+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'94','Val-de-Marne');
   2183+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'95','Val-d\'Oise');
   2184+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'NC','Territoire des Nouvelle-Calédonie et Dependances');
   2185+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'PF','Polynésie Française');
   2186+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'PM','Saint-Pierre et Miquelon');
   2187+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'TF','Terres australes et antarctiques françaises');
   2188+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'YT','Mayotte');
   2189+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (73,'WF','Territoire des îles Wallis et Futuna');
   2190+
8892191 INSERT INTO osc_countries VALUES (74,'France, Metropolitan','FX','FXX',":name\n:street_address\n:postcode :city\n:country");
  8902192 INSERT INTO osc_countries VALUES (75,'French Guiana','GF','GUF',":name\n:street_address\n:postcode :city\n:country");
  8912193 INSERT INTO osc_countries VALUES (76,'French Polynesia','PF','PYF',":name\n:street_address\n:postcode :city\n:country");
<>  2194+
   2195+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (76,'M','Archipel des Marquises');
   2196+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (76,'T','Archipel des Tuamotu');
   2197+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (76,'I','Archipel des Tubuai');
   2198+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (76,'V','Iles du Vent');
   2199+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (76,'S','Iles Sous-le-Vent ');
   2200+
8922201 INSERT INTO osc_countries VALUES (77,'French Southern Territories','TF','ATF',":name\n:street_address\n:postcode :city\n:country");
<>  2202+
   2203+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (77,'C','Iles Crozet');
   2204+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (77,'K','Iles Kerguelen');
   2205+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (77,'A','Ile Amsterdam');
   2206+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (77,'P','Ile Saint-Paul');
   2207+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (77,'D','Adelie Land');
   2208+
8932209 INSERT INTO osc_countries VALUES (78,'Gabon','GA','GAB','');
<>  2210+
   2211+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'ES','Estuaire');
   2212+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'HO','Haut-Ogooue');
   2213+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'MO','Moyen-Ogooue');
   2214+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'NG','Ngounie');
   2215+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'NY','Nyanga');
   2216+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'OI','Ogooue-Ivindo');
   2217+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'OL','Ogooue-Lolo');
   2218+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'OM','Ogooue-Maritime');
   2219+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (78,'WN','Woleu-Ntem');
   2220+
8942221 INSERT INTO osc_countries VALUES (79,'Gambia','GM','GMB','');
<>  2222+
   2223+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'AH','Ashanti');
   2224+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'BA','Brong-Ahafo');
   2225+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'CP','Central');
   2226+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'EP','Eastern');
   2227+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'AA','Greater Accra');
   2228+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'NP','Northern');
   2229+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'UE','Upper East');
   2230+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'UW','Upper West');
   2231+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'TV','Volta');
   2232+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (79,'WP','Western');
   2233+
8952234 INSERT INTO osc_countries VALUES (80,'Georgia','GE','GEO','');
<>  2235+
   2236+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'AB','აფხაზეთი');
   2237+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'AJ','აჭარა');
   2238+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'GU','გურია');
   2239+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'IM','იმერეთი');
   2240+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'KA','კახეთი');
   2241+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'KK','ქვემო ქართლი');
   2242+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'MM','მცხეთა-მთიანეთი');
   2243+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'RL','რაჭა-ლეჩხუმი და ქვემო სვანეთი');
   2244+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'SJ','სამცხე-ჯავახეთი');
   2245+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'SK','შიდა ქართლი');
   2246+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'SZ','სამეგრელო-ზემო სვანეთი');
   2247+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (80,'TB','თბილისი');
   2248+
8962249 INSERT INTO osc_countries VALUES (81,'Germany','DE','DEU',":name\n:street_address\nD-:postcode :city\n:country");
<>  2250+
   2251+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BE','Berlin');
   2252+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BR','Brandenburg');
   2253+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BW','Baden-Württemberg');
   2254+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BY','Bayern');
   2255+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'HB','Bremen');
   2256+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'HE','Hessen');
   2257+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'HH','Hamburg');
   2258+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'MV','Mecklenburg-Vorpommern');
   2259+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'NI','Niedersachsen');
   2260+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'NW','Nordrhein-Westfalen');
   2261+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'RP','Rheinland-Pfalz');
   2262+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'SH','Schleswig-Holstein');
   2263+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'SL','Saarland');
   2264+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'SN','Sachsen');
   2265+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'ST','Sachsen-Anhalt');
   2266+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'TH','Thüringen');
   2267+
8972268 INSERT INTO osc_countries VALUES (82,'Ghana','GH','GHA','');
<>  2269+
   2270+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'AA','Greater Accra');
   2271+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'AH','Ashanti');
   2272+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'BA','Brong-Ahafo');
   2273+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'CP','Central');
   2274+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'EP','Eastern');
   2275+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'NP','Northern');
   2276+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'TV','Volta');
   2277+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'UE','Upper East');
   2278+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'UW','Upper West');
   2279+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (82,'WP','Western');
   2280+
8982281 INSERT INTO osc_countries VALUES (83,'Gibraltar','GI','GIB','');
<>  2282+
8992283 INSERT INTO osc_countries VALUES (84,'Greece','GR','GRC','');
<>  2284+
   2285+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'01','Αιτωλοακαρνανία');
   2286+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'03','Βοιωτία');
   2287+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'04','Εύβοια');
   2288+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'05','Ευρυτανία');
   2289+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'06','Φθιώτιδα');
   2290+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'07','Φωκίδα');
   2291+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'11','Αργολίδα');
   2292+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'12','Αρκαδία');
   2293+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'13','Ἀχαΐα');
   2294+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'14','Ηλεία');
   2295+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'15','Κορινθία');
   2296+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'16','Λακωνία');
   2297+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'17','Μεσσηνία');
   2298+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'21','Ζάκυνθος');
   2299+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'22','Κέρκυρα');
   2300+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'23','Κεφαλλονιά');
   2301+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'24','Λευκάδα');
   2302+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'31','Άρτα');
   2303+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'32','Θεσπρωτία');
   2304+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'33','Ιωάννινα');
   2305+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'34','Πρεβεζα');
   2306+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'41','Καρδίτσα');
   2307+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'42','Λάρισα');
   2308+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'43','Μαγνησία');
   2309+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'44','Τρίκαλα');
   2310+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'51','Γρεβενά');
   2311+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'52','Δράμα');
   2312+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'53','Ημαθία');
   2313+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'54','Θεσσαλονίκη');
   2314+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'55','Καβάλα');
   2315+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'56','Καστοριά');
   2316+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'57','Κιλκίς');
   2317+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'58','Κοζάνη');
   2318+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'59','Πέλλα');
   2319+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'61','Πιερία');
   2320+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'62','Σερρών');
   2321+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'63','Φλώρινα');
   2322+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'64','Χαλκιδική');
   2323+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'69','Όρος Άθως');
   2324+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'71','Έβρος');
   2325+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'72','Ξάνθη');
   2326+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'73','Ροδόπη');
   2327+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'81','Δωδεκάνησα');
   2328+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'82','Κυκλάδες');
   2329+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'83','Λέσβου');
   2330+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'84','Σάμος');
   2331+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'85','Χίος');
   2332+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'91','Ηράκλειο');
   2333+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'92','Λασίθι');
   2334+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'93','Ρεθύμνο');
   2335+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'94','Χανίων');
   2336+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (84,'A1','Αττική');
   2337+
9002338 INSERT INTO osc_countries VALUES (85,'Greenland','GL','GRL',":name\n:street_address\nDK-:postcode :city\n:country");
<>  2339+
   2340+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (85,'A','Avannaa');
   2341+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (85,'T','Tunu ');
   2342+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (85,'K','Kitaa');
   2343+
9012344 INSERT INTO osc_countries VALUES (86,'Grenada','GD','GRD','');
<>  2345+
   2346+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (86,'A','Saint Andrew');
   2347+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (86,'D','Saint David');
   2348+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (86,'G','Saint George');
   2349+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (86,'J','Saint John');
   2350+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (86,'M','Saint Mark');
   2351+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (86,'P','Saint Patrick');
   2352+
9022353 INSERT INTO osc_countries VALUES (87,'Guadeloupe','GP','GLP','');
  9032354 INSERT INTO osc_countries VALUES (88,'Guam','GU','GUM','');
<>  2355+
9042356 INSERT INTO osc_countries VALUES (89,'Guatemala','GT','GTM','');
<>  2357+
   2358+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'AV','Alta Verapaz');
   2359+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'BV','Baja Verapaz');
   2360+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'CM','Chimaltenango');
   2361+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'CQ','Chiquimula');
   2362+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'ES','Escuintla');
   2363+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'GU','Guatemala');
   2364+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'HU','Huehuetenango');
   2365+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'IZ','Izabal');
   2366+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'JA','Jalapa');
   2367+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'JU','Jutiapa');
   2368+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'PE','El Petén');
   2369+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'PR','El Progreso');
   2370+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'QC','El Quiché');
   2371+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'QZ','Quetzaltenango');
   2372+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'RE','Retalhuleu');
   2373+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'SA','Sacatepéquez');
   2374+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'SM','San Marcos');
   2375+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'SO','Sololá');
   2376+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'SR','Santa Rosa');
   2377+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'SU','Suchitepéquez');
   2378+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'TO','Totonicapán');
   2379+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (89,'ZA','Zacapa');
   2380+
9052381 INSERT INTO osc_countries VALUES (90,'Guinea','GN','GIN','');
<> 906 -INSERT INTO osc_countries VALUES (91,'Guinea-bissau','GW','GNB','');
   2382+
   2383+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'BE','Beyla');
   2384+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'BF','Boffa');
   2385+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'BK','Boké');
   2386+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'CO','Coyah');
   2387+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'DB','Dabola');
   2388+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'DI','Dinguiraye');
   2389+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'DL','Dalaba');
   2390+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'DU','Dubréka');
   2391+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'FA','Faranah');
   2392+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'FO','Forécariah');
   2393+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'FR','Fria');
   2394+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'GA','Gaoual');
   2395+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'GU','Guékédou');
   2396+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'KA','Kankan');
   2397+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'KB','Koubia');
   2398+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'KD','Kindia');
   2399+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'KE','Kérouané');
   2400+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'KN','Koundara');
   2401+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'KO','Kouroussa');
   2402+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'KS','Kissidougou');
   2403+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'LA','Labé');
   2404+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'LE','Lélouma');
   2405+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'LO','Lola');
   2406+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'MC','Macenta');
   2407+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'MD','Mandiana');
   2408+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'ML','Mali');
   2409+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'MM','Mamou');
   2410+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'NZ','Nzérékoré');
   2411+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'PI','Pita');
   2412+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'SI','Siguiri');
   2413+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'TE','Télimélé');
   2414+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'TO','Tougué');
   2415+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (90,'YO','Yomou');
   2416+
   2417+INSERT INTO osc_countries VALUES (91,'Guinea-Bissau','GW','GNB','');
   2418+
   2419+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'BF','Bafata');
   2420+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'BB','Biombo');
   2421+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'BS','Bissau');
   2422+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'BL','Bolama');
   2423+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'CA','Cacheu');
   2424+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'GA','Gabu');
   2425+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'OI','Oio');
   2426+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'QU','Quinara');
   2427+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (91,'TO','Tombali');
   2428+
9072429 INSERT INTO osc_countries VALUES (92,'Guyana','GY','GUY','');
<>  2430+
   2431+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'BA','Barima-Waini');
   2432+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'CU','Cuyuni-Mazaruni');
   2433+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'DE','Demerara-Mahaica');
   2434+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'EB','East Berbice-Corentyne');
   2435+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'ES','Essequibo Islands-West Demerara');
   2436+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'MA','Mahaica-Berbice');
   2437+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'PM','Pomeroon-Supenaam');
   2438+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'PT','Potaro-Siparuni');
   2439+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'UD','Upper Demerara-Berbice');
   2440+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (92,'UT','Upper Takutu-Upper Essequibo');
   2441+
9082442 INSERT INTO osc_countries VALUES (93,'Haiti','HT','HTI','');
<> 909 -INSERT INTO osc_countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','');
   2443+
   2444+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'AR','Artibonite');
   2445+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'CE','Centre');
   2446+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'GA','Grand\'Anse');
   2447+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'NI','Nippes');
   2448+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'ND','Nord');
   2449+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'NE','Nord-Est');
   2450+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'NO','Nord-Ouest');
   2451+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'OU','Ouest');
   2452+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'SD','Sud');
   2453+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (93,'SE','Sud-Est');
   2454+
   2455+INSERT INTO osc_countries VALUES (94,'Heard and McDonald Islands','HM','HMD','');
   2456+
   2457+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (94,'F','Flat Island');
   2458+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (94,'M','McDonald Island');
   2459+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (94,'S','Shag Island');
   2460+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (94,'H','Heard Island');
   2461+
9102462 INSERT INTO osc_countries VALUES (95,'Honduras','HN','HND','');
<>  2463+
   2464+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'AT','Atlántida');
   2465+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'CH','Choluteca');
   2466+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'CL','Colón');
   2467+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'CM','Comayagua');
   2468+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'CP','Copán');
   2469+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'CR','Cortés');
   2470+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'EP','El Paraíso');
   2471+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'FM','Francisco Morazán');
   2472+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'GD','Gracias a Dios');
   2473+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'IB','Islas de la Bahía');
   2474+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'IN','Intibucá');
   2475+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'LE','Lempira');
   2476+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'LP','La Paz');
   2477+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'OC','Ocotepeque');
   2478+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'OL','Olancho');
   2479+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'SB','Santa Bárbara');
   2480+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'VA','Valle');
   2481+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (95,'YO','Yoro');
   2482+
9112483 INSERT INTO osc_countries VALUES (96,'Hong Kong','HK','HKG',":name\n:street_address\n:city\n:country");
<>  2484+
   2485+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'HCW','中西區');
   2486+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'HEA','東區');
   2487+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'HSO','南區');
   2488+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'HWC','灣仔區');
   2489+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'KKC','九龍城區');
   2490+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'KKT','觀塘區');
   2491+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'KSS','深水埗區');
   2492+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'KWT','黃大仙區');
   2493+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'KYT','油尖旺區');
   2494+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NIS','離島區');
   2495+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NKT','葵青區');
   2496+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NNO','北區');
   2497+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NSK','西貢區');
   2498+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NST','沙田區');
   2499+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NTP','大埔區');
   2500+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NTW','荃灣區');
   2501+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NTM','屯門區');
   2502+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (96,'NYL','元朗區');
   2503+
9122504 INSERT INTO osc_countries VALUES (97,'Hungary','HU','HUN','');
<>  2505+
   2506+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'BA','Baranja megye');
   2507+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'BC','Békéscsaba');
   2508+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'BE','Békés megye');
   2509+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'BK','Bács-Kiskun megye');
   2510+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'BU','Budapest');
   2511+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'BZ','Borsod-Abaúj-Zemplén megye');
   2512+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'CS','Csongrád megye');
   2513+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'DE','Debrecen');
   2514+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'DU','Dunaújváros');
   2515+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'EG','Eger');
   2516+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'FE','Fejér megye');
   2517+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'GS','Győr-Moson-Sopron megye');
   2518+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'GY','Győr');
   2519+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'HB','Hajdú-Bihar megye');
   2520+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'HE','Heves megye');
   2521+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'HV','Hódmezővásárhely');
   2522+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'JN','Jász-Nagykun-Szolnok megye');
   2523+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'KE','Komárom-Esztergom megye');
   2524+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'KM','Kecskemét');
   2525+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'KV','Kaposvár');
   2526+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'MI','Miskolc');
   2527+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'NK','Nagykanizsa');
   2528+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'NO','Nógrád megye');
   2529+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'NY','Nyíregyháza');
   2530+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'PE','Pest megye');
   2531+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'PS','Pécs');
   2532+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SD','Szeged');
   2533+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SF','Székesfehérvár');
   2534+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SH','Szombathely');
   2535+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SK','Szolnok');
   2536+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SN','Sopron');
   2537+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SO','Somogy megye');
   2538+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SS','Szekszárd');
   2539+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'ST','Salgótarján');
   2540+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'SZ','Szabolcs-Szatmár-Bereg megye');
   2541+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'TB','Tatabánya');
   2542+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'TO','Tolna megye');
   2543+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'VA','Vas megye');
   2544+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'VE','Veszprém megye');
   2545+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'VM','Veszprém');
   2546+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'ZA','Zala megye');
   2547+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (97,'ZE','Zalaegerszeg');
   2548+
9132549 INSERT INTO osc_countries VALUES (98,'Iceland','IS','ISL',":name\n:street_address\nIS:postcode :city\n:country");
<>  2550+
   2551+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'1','Höfuðborgarsvæðið');
   2552+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'2','Suðurnes');
   2553+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'3','Vesturland');
   2554+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'4','Vestfirðir');
   2555+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'5','Norðurland vestra');
   2556+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'6','Norðurland eystra');
   2557+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'7','Austfirðir');
   2558+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (98,'8','Suðurland');
   2559+
9142560 INSERT INTO osc_countries VALUES (99,'India','IN','IND',":name\n:street_address\n:city-:postcode\n:country");
<>  2561+
   2562+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-AN','अंडमान और निकोबार द्वीप');
   2563+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-AP','ఆంధ్ర ప్రదేశ్');
   2564+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-AR','अरुणाचल प्रदेश');
   2565+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-AS','অসম');
   2566+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-BR','बिहार');
   2567+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-CH','चंडीगढ़');
   2568+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-CT','छत्तीसगढ़');
   2569+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-DD','દમણ અને દિવ');
   2570+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-DL','दिल्ली');
   2571+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-DN','દાદરા અને નગર હવેલી');
   2572+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-GA','गोंय');
   2573+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-GJ','ગુજરાત');
   2574+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-HP','हिमाचल प्रदेश');
   2575+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-HR','हरियाणा');
   2576+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-JH','झारखंड');
   2577+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-JK','जम्मू और कश्मीर');
   2578+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-KA','ಕನಾ೯ಟಕ');
   2579+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-KL','കേരളം');
   2580+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-LD','ലക്ഷദ്വീപ്');
   2581+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-ML','मेघालय');
   2582+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-MH','महाराष्ट्र');
   2583+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-MN','मणिपुर');
   2584+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-MP','मध्य प्रदेश');
   2585+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-MZ','मिज़ोरम');
   2586+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-NL','नागालैंड');
   2587+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-OR','उड़ीसा');
   2588+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-PB','ਪੰਜਾਬ');
   2589+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-PY','புதுச்சேரி');
   2590+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-RJ','राजस्थान');
   2591+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-SK','सिक्किम');
   2592+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-TN','தமிழ் நாடு');
   2593+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-TR','ত্রিপুরা');
   2594+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-UL','उत्तरांचल');
   2595+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-UP','उत्तर प्रदेश');
   2596+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (99,'IN-WB','পশ্চিমবঙ্গ');
   2597+
9152598 INSERT INTO osc_countries VALUES (100,'Indonesia','ID','IDN',":name\n:street_address\n:city :postcode\n:country");
<> 916 -INSERT INTO osc_countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','');
   2599+
   2600+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'AC','Aceh');
   2601+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'BA','Bali');
   2602+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'BB','Bangka-Belitung');
   2603+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'BE','Bengkulu');
   2604+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'BT','Banten');
   2605+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'GO','Gorontalo');
   2606+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'IJ','Papua');
   2607+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'JA','Jambi');
   2608+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'JI','Jawa Timur');
   2609+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'JK','Jakarta Raya');
   2610+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'JR','Jawa Barat');
   2611+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'JT','Jawa Tengah');
   2612+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'KB','Kalimantan Barat');
   2613+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'KI','Kalimantan Timur');
   2614+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'KS','Kalimantan Selatan');
   2615+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'KT','Kalimantan Tengah');
   2616+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'LA','Lampung');
   2617+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'MA','Maluku');
   2618+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'MU','Maluku Utara');
   2619+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'NB','Nusa Tenggara Barat');
   2620+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'NT','Nusa Tenggara Timur');
   2621+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'RI','Riau');
   2622+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'SB','Sumatera Barat');
   2623+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'SG','Sulawesi Tenggara');
   2624+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'SL','Sumatera Selatan');
   2625+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'SN','Sulawesi Selatan');
   2626+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'ST','Sulawesi Tengah');
   2627+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'SW','Sulawesi Utara');
   2628+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'SU','Sumatera Utara');
   2629+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (100,'YO','Yogyakarta');
   2630+
   2631+INSERT INTO osc_countries VALUES (101,'Iran','IR','IRN','');
   2632+
   2633+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'01','محافظة آذربایجان شرقي');
   2634+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'02','محافظة آذربایجان غربي');
   2635+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'03','محافظة اردبیل');
   2636+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'04','محافظة اصفهان');
   2637+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'05','محافظة ایلام');
   2638+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'06','محافظة بوشهر');
   2639+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'07','محافظة طهران');
   2640+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'08','محافظة چهارمحل و بختیاري');
   2641+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'09','محافظة خراسان رضوي');
   2642+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'10','محافظة خوزستان');
   2643+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'11','محافظة زنجان');
   2644+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'12','محافظة سمنان');
   2645+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'13','محافظة سيستان وبلوتشستان');
   2646+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'14','محافظة فارس');
   2647+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'15','محافظة کرمان');
   2648+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'16','محافظة کردستان');
   2649+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'17','محافظة کرمانشاه');
   2650+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'18','محافظة کهکیلویه و بویر أحمد');
   2651+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'19','محافظة گیلان');
   2652+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'20','محافظة لرستان');
   2653+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'21','محافظة مازندران');
   2654+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'22','محافظة مرکزي');
   2655+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'23','محافظة هرمزگان');
   2656+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'24','محافظة همدان');
   2657+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'25','محافظة یزد');
   2658+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'26','محافظة قم');
   2659+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'27','محافظة گلستان');
   2660+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (101,'28','محافظة قزوين');
   2661+
9172662 INSERT INTO osc_countries VALUES (102,'Iraq','IQ','IRQ','');
<>  2663+
   2664+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'AN','محافظة الأنبار');
   2665+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'AR','أربيل');
   2666+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'BA','محافظة البصرة');
   2667+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'BB','بابل');
   2668+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'BG','محافظة بغداد');
   2669+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'DA','دهوك');
   2670+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'DI','ديالى');
   2671+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'DQ','ذي قار');
   2672+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'KA','كربلاء');
   2673+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'MA','ميسان');
   2674+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'MU','المثنى');
   2675+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'NA','النجف');
   2676+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'NI','نینوى');
   2677+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'QA','القادسية');
   2678+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'SD','صلاح الدين');
   2679+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'SW','محافظة السليمانية');
   2680+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'TS','التأمیم');
   2681+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (102,'WA','واسط');
   2682+
9182683 INSERT INTO osc_countries VALUES (103,'Ireland','IE','IRL',":name\n:street_address\nIE-:city\n:country");
<>  2684+
   2685+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'C','Corcaigh');
   2686+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'CE','Contae an Chláir');
   2687+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'CN','An Cabhán');
   2688+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'CW','Ceatharlach');
   2689+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'D','Baile Átha Cliath');
   2690+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'DL','Dún na nGall');
   2691+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'G','Gaillimh');
   2692+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'KE','Cill Dara');
   2693+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'KK','Cill Chainnigh');
   2694+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'KY','Contae Chiarraí');
   2695+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'LD','An Longfort');
   2696+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'LH','Contae Lú');
   2697+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'LK','Luimneach');
   2698+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'LM','Contae Liatroma');
   2699+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'LS','Contae Laoise');
   2700+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'MH','Contae na Mí');
   2701+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'MN','Muineachán');
   2702+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'MO','Contae Mhaigh Eo');
   2703+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'OY','Contae Uíbh Fhailí');
   2704+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'RN','Ros Comáin');
   2705+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'SO','Sligeach');
   2706+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'TA','Tiobraid Árann');
   2707+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'WD','Port Lairge');
   2708+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'WH','Contae na hIarmhí');
   2709+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'WW','Cill Mhantáin');
   2710+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (103,'WX','Loch Garman');
   2711+
9192712 INSERT INTO osc_countries VALUES (104,'Israel','IL','ISR',":name\n:street_address\n:postcode :city\n:country");
<>  2713+
   2714+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (104,'D ','מחוז הדרום');
   2715+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (104,'HA','מחוז חיפה');
   2716+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (104,'JM','ירושלים');
   2717+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (104,'M ','מחוז המרכז');
   2718+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (104,'TA','תל אביב-יפו');
   2719+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (104,'Z ','מחוז הצפון');
   2720+
9202721 INSERT INTO osc_countries VALUES (105,'Italy','IT','ITA',":name\n:street_address\n:postcode-:city :state_code\n:country");
<>  2722+
   2723+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AG','Agrigento');
   2724+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AL','Alessandria');
   2725+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AN','Ancona');
   2726+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AO','Valle d\'Aosta');
   2727+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AP','Ascoli Piceno');
   2728+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AQ','L\'Aquila');
   2729+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AR','Arezzo');
   2730+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AT','Asti');
   2731+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'AV','Avellino');
   2732+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BA','Bari');
   2733+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BG','Bergamo');
   2734+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BI','Biella');
   2735+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BL','Belluno');
   2736+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BN','Benevento');
   2737+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BO','Bologna');
   2738+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BR','Brindisi');
   2739+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BS','Brescia');
   2740+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BT','Barletta-Andria-Trani');
   2741+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'BZ','Alto Adige');
   2742+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CA','Cagliari');
   2743+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CB','Campobasso');
   2744+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CE','Caserta');
   2745+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CH','Chieti');
   2746+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CI','Carbonia-Iglesias');
   2747+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CL','Caltanissetta');
   2748+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CN','Cuneo');
   2749+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CO','Como');
   2750+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CR','Cremona');
   2751+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CS','Cosenza');
   2752+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CT','Catania');
   2753+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'CZ','Catanzaro');
   2754+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'EN','Enna');
   2755+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'FE','Ferrara');
   2756+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'FG','Foggia');
   2757+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'FI','Firenze');
   2758+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'FM','Fermo');
   2759+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'FO','Forlì-Cesena');
   2760+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'FR','Frosinone');
   2761+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'GE','Genova');
   2762+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'GO','Gorizia');
   2763+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'GR','Grosseto');
   2764+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'IM','Imperia');
   2765+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'IS','Isernia');
   2766+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'KR','Crotone');
   2767+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'LC','Lecco');
   2768+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'LE','Lecce');
   2769+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'LI','Livorno');
   2770+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'LO','Lodi');
   2771+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'LT','Latina');
   2772+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'LU','Lucca');
   2773+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MC','Macerata');
   2774+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MD','Medio Campidano');
   2775+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'ME','Messina');
   2776+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MI','Milano');
   2777+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MN','Mantova');
   2778+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MO','Modena');
   2779+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MS','Massa-Carrara');
   2780+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MT','Matera');
   2781+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'MZ','Monza e Brianza');
   2782+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'NA','Napoli');
   2783+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'NO','Novara');
   2784+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'NU','Nuoro');
   2785+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'OG','Ogliastra');
   2786+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'OR','Oristano');
   2787+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'OT','Olbia-Tempio');
   2788+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PA','Palermo');
   2789+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PC','Piacenza');
   2790+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PD','Padova');
   2791+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PE','Pescara');
   2792+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PG','Perugia');
   2793+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PI','Pisa');
   2794+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PN','Pordenone');
   2795+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PO','Prato');
   2796+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PR','Parma');
   2797+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PS','Pesaro e Urbino');
   2798+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PT','Pistoia');
   2799+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PV','Pavia');
   2800+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'PZ','Potenza');
   2801+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RA','Ravenna');
   2802+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RC','Reggio Calabria');
   2803+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RE','Reggio Emilia');
   2804+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RG','Ragusa');
   2805+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RI','Rieti');
   2806+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RM','Roma');
   2807+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RN','Rimini');
   2808+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'RO','Rovigo');
   2809+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'SA','Salerno');
   2810+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'SI','Siena');
   2811+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'SO','Sondrio');
   2812+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'SP','La Spezia');
   2813+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'SR','Siracusa');
   2814+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'SS','Sassari');
   2815+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'SV','Savona');
   2816+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TA','Taranto');
   2817+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TE','Teramo');
   2818+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TN','Trento');
   2819+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TO','Torino');
   2820+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TP','Trapani');
   2821+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TR','Terni');
   2822+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TS','Trieste');
   2823+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'TV','Treviso');
   2824+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'UD','Udine');
   2825+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VA','Varese');
   2826+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VB','Verbano-Cusio-Ossola');
   2827+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VC','Vercelli');
   2828+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VE','Venezia');
   2829+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VI','Vicenza');
   2830+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VR','Verona');
   2831+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VT','Viterbo');
   2832+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (105,'VV','Vibo Valentia');
   2833+
9212834 INSERT INTO osc_countries VALUES (106,'Jamaica','JM','JAM','');
<>  2835+
   2836+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'01','Kingston');
   2837+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'02','Half Way Tree');
   2838+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'03','Morant Bay');
   2839+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'04','Port Antonio');
   2840+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'05','Port Maria');
   2841+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'06','Saint Ann\'s Bay');
   2842+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'07','Falmouth');
   2843+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'08','Montego Bay');
   2844+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'09','Lucea');
   2845+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'10','Savanna-la-Mar');
   2846+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'11','Black River');
   2847+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'12','Mandeville');
   2848+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'13','May Pen');
   2849+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (106,'14','Spanish Town');
   2850+
9222851 INSERT INTO osc_countries VALUES (107,'Japan','JP','JPN',":name\n:street_address, :suburb\n:city :postcode\n:country");
<>  2852+
   2853+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'01','北海道');
   2854+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'02','青森');
   2855+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'03','岩手');
   2856+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'04','宮城');
   2857+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'05','秋田');
   2858+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'06','山形');
   2859+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'07','福島');
   2860+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'08','茨城');
   2861+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'09','栃木');
   2862+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'10','群馬');
   2863+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'11','埼玉');
   2864+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'12','千葉');
   2865+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'13','東京');
   2866+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'14','神奈川');
   2867+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'15','新潟');
   2868+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'16','富山');
   2869+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'17','石川');
   2870+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'18','福井');
   2871+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'19','山梨');
   2872+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'20','長野');
   2873+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'21','岐阜');
   2874+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'22','静岡');
   2875+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'23','愛知');
   2876+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'24','三重');
   2877+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'25','滋賀');
   2878+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'26','京都');
   2879+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'27','大阪');
   2880+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'28','兵庫');
   2881+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'29','奈良');
   2882+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'30','和歌山');
   2883+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'31','鳥取');
   2884+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'32','島根');
   2885+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'33','岡山');
   2886+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'34','広島');
   2887+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'35','山口');
   2888+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'36','徳島');
   2889+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'37','香川');
   2890+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'38','愛媛');
   2891+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'39','高知');
   2892+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'40','福岡');
   2893+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'41','佐賀');
   2894+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'42','長崎');
   2895+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'43','熊本');
   2896+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'44','大分');
   2897+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'45','宮崎');
   2898+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'46','鹿児島');
   2899+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (107,'47','沖縄');
   2900+
9232901 INSERT INTO osc_countries VALUES (108,'Jordan','JO','JOR','');
<>  2902+
   2903+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'AJ','محافظة عجلون');
   2904+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'AM','محافظة العاصمة');
   2905+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'AQ','محافظة العقبة');
   2906+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'AT','محافظة الطفيلة');
   2907+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'AZ','محافظة الزرقاء');
   2908+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'BA','محافظة البلقاء');
   2909+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'JA','محافظة جرش');
   2910+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'JR','محافظة إربد');
   2911+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'KA','محافظة الكرك');
   2912+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'MA','محافظة المفرق');
   2913+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'MD','محافظة مادبا');
   2914+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (108,'MN','محافظة معان');
   2915+
9242916 INSERT INTO osc_countries VALUES (109,'Kazakhstan','KZ','KAZ','');
<>  2917+
   2918+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'AL','Алматы');
   2919+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'AC','Almaty City');
   2920+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'AM','Ақмола');
   2921+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'AQ','Ақтөбе');
   2922+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'AS','Астана');
   2923+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'AT','Атырау');
   2924+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'BA','Батыс Қазақстан');
   2925+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'BY','Байқоңыр');
   2926+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'MA','Маңғыстау');
   2927+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'ON','Оңтүстік Қазақстан');
   2928+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'PA','Павлодар');
   2929+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'QA','Қарағанды');
   2930+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'QO','Қостанай');
   2931+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'QY','Қызылорда');
   2932+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'SH','Шығыс Қазақстан');
   2933+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'SO','Солтүстік Қазақстан');
   2934+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (109,'ZH','Жамбыл');
   2935+
9252936 INSERT INTO osc_countries VALUES (110,'Kenya','KE','KEN','');
<>  2937+
   2938+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'110','Nairobi');
   2939+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'200','Central');
   2940+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'300','Mombasa');
   2941+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'400','Eastern');
   2942+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'500','North Eastern');
   2943+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'600','Nyanza');
   2944+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'700','Rift Valley');
   2945+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (110,'900','Western');
   2946+
9262947 INSERT INTO osc_countries VALUES (111,'Kiribati','KI','KIR','');
<> 927 -INSERT INTO osc_countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','');
  928 -INSERT INTO osc_countries VALUES (113,'Korea, Republic of','KR','KOR','');
   2948+
   2949+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (111,'G','Gilbert Islands');
   2950+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (111,'L','Line Islands');
   2951+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (111,'P','Phoenix Islands');
   2952+
   2953+INSERT INTO osc_countries VALUES (112,'Korea, North','KP','PRK','');
   2954+
   2955+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'CHA','자강도');
   2956+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'HAB','함경 북도');
   2957+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'HAN','함경 남도');
   2958+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'HWB','황해 북도');
   2959+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'HWN','황해 남도');
   2960+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'KAN','강원도');
   2961+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'KAE','개성시');
   2962+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'NAJ','라선 직할시');
   2963+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'NAM','남포 특급시');
   2964+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'PYB','평안 북도');
   2965+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'PYN','평안 남도');
   2966+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'PYO','평양 직할시');
   2967+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (112,'YAN','량강도');
   2968+
   2969+INSERT INTO osc_countries VALUES (113,'Korea, South','KR','KOR','');
   2970+
   2971+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'11','서울특별시');
   2972+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'26','부산 광역시');
   2973+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'27','대구 광역시');
   2974+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'28','인천광역시');
   2975+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'29','광주 광역시');
   2976+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'30','대전 광역시');
   2977+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'31','울산 광역시');
   2978+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'41','경기도');
   2979+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'42','강원도');
   2980+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'43','충청 북도');
   2981+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'44','충청 남도');
   2982+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'45','전라 북도');
   2983+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'46','전라 남도');
   2984+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'47','경상 북도');
   2985+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'48','경상 남도');
   2986+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (113,'49','제주특별자치도');
   2987+
9292988 INSERT INTO osc_countries VALUES (114,'Kuwait','KW','KWT','');
<>  2989+
   2990+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (114,'AH','الاحمدي');
   2991+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (114,'FA','الفروانية');
   2992+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (114,'JA','الجهراء');
   2993+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (114,'KU','ألعاصمه');
   2994+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (114,'HW','حولي');
   2995+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (114,'MU','مبارك الكبير');
   2996+
9302997 INSERT INTO osc_countries VALUES (115,'Kyrgyzstan','KG','KGZ','');
<> 931 -INSERT INTO osc_countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO','');
   2998+
   2999+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'B','Баткен областы');
   3000+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'C','Чүй областы');
   3001+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'GB','Бишкек');
   3002+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'J','Жалал-Абад областы');
   3003+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'N','Нарын областы');
   3004+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'O','Ош областы');
   3005+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'T','Талас областы');
   3006+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (115,'Y','Ысык-Көл областы');
   3007+
   3008+INSERT INTO osc_countries VALUES (116,'Laos','LA','LAO','');
   3009+
   3010+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'AT','ອັດຕະປື');
   3011+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'BK','ບໍ່ແກ້ວ');
   3012+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'BL','ບໍລິຄໍາໄຊ');
   3013+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'CH','ຈໍາປາສັກ');
   3014+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'HO','ຫົວພັນ');
   3015+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'KH','ຄໍາມ່ວນ');
   3016+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'LM','ຫລວງນໍ້າທາ');
   3017+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'LP','ຫລວງພະບາງ');
   3018+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'OU','ອຸດົມໄຊ');
   3019+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'PH','ຜົງສາລີ');
   3020+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'SL','ສາລະວັນ');
   3021+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'SV','ສະຫວັນນະເຂດ');
   3022+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'VI','ວຽງຈັນ');
   3023+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'VT','ວຽງຈັນ');
   3024+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'XA','ໄຊຍະບູລີ');
   3025+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'XE','ເຊກອງ');
   3026+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'XI','ຊຽງຂວາງ');
   3027+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (116,'XN','ໄຊສົມບູນ');
   3028+
9323029 INSERT INTO osc_countries VALUES (117,'Latvia','LV','LVA','');
<>  3030+
   3031+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'AI','Aizkraukles rajons');
   3032+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'AL','Alūksnes rajons');
   3033+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'BL','Balvu rajons');
   3034+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'BU','Bauskas rajons');
   3035+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'CE','Cēsu rajons');
   3036+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'DA','Daugavpils rajons');
   3037+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'DGV','Daugpilis');
   3038+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'DO','Dobeles rajons');
   3039+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'GU','Gulbenes rajons');
   3040+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'JEL','Jelgava');
   3041+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'JK','Jēkabpils rajons');
   3042+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'JL','Jelgavas rajons');
   3043+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'JUR','Jūrmala');
   3044+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'KR','Krāslavas rajons');
   3045+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'KU','Kuldīgas rajons');
   3046+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'LE','Liepājas rajons');
   3047+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'LM','Limbažu rajons');
   3048+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'LPX','Liepoja');
   3049+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'LU','Ludzas rajons');
   3050+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'MA','Madonas rajons');
   3051+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'OG','Ogres rajons');
   3052+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'PR','Preiļu rajons');
   3053+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'RE','Rēzeknes rajons');
   3054+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'REZ','Rēzekne');
   3055+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'RI','Rīgas rajons');
   3056+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'RIX','Rīga');
   3057+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'SA','Saldus rajons');
   3058+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'TA','Talsu rajons');
   3059+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'TU','Tukuma rajons');
   3060+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'VE','Ventspils rajons');
   3061+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'VEN','Ventspils');
   3062+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'VK','Valkas rajons');
   3063+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (117,'VM','Valmieras rajons');
   3064+
9333065 INSERT INTO osc_countries VALUES (118,'Lebanon','LB','LBN','');
<>  3066+
9343067 INSERT INTO osc_countries VALUES (119,'Lesotho','LS','LSO','');
<>  3068+
   3069+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'A','Maseru');
   3070+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'B','Butha-Buthe');
   3071+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'C','Leribe');
   3072+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'D','Berea');
   3073+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'E','Mafeteng');
   3074+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'F','Mohale\'s Hoek');
   3075+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'G','Quthing');
   3076+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'H','Qacha\'s Nek');
   3077+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'J','Mokhotlong');
   3078+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (119,'K','Thaba-Tseka');
   3079+
9353080 INSERT INTO osc_countries VALUES (120,'Liberia','LR','LBR','');
<>  3081+
   3082+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'BG','Bong');
   3083+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'BM','Bomi');
   3084+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'CM','Grand Cape Mount');
   3085+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'GB','Grand Bassa');
   3086+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'GG','Grand Gedeh');
   3087+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'GK','Grand Kru');
   3088+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'GP','Gbarpolu');
   3089+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'LO','Lofa');
   3090+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'MG','Margibi');
   3091+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'MO','Montserrado');
   3092+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'MY','Maryland');
   3093+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'NI','Nimba');
   3094+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'RG','River Gee');
   3095+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'RI','Rivercess');
   3096+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (120,'SI','Sinoe');
   3097+
9363098 INSERT INTO osc_countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','');
<>  3099+
   3100+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'AJ','Ajdābiyā');
   3101+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'BA','Banghāzī');
   3102+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'BU','Al Buţnān');
   3103+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'BW','Banī Walīd');
   3104+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'DR','Darnah');
   3105+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'GD','Ghadāmis');
   3106+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'GR','Gharyān');
   3107+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'GT','Ghāt');
   3108+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'HZ','Al Ḩizām al Akhḑar');
   3109+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'JA','Al Jabal al Akhḑar');
   3110+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'JB','Jaghbūb');
   3111+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'JI','Al Jifārah');
   3112+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'JU','Al Jufrah');
   3113+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'KF','Al Kufrah');
   3114+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'MB','Al Marqab');
   3115+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'MI','Mişrātah');
   3116+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'MJ','Al Marj');
   3117+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'MQ','Murzuq');
   3118+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'MZ','Mizdah');
   3119+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'NL','Nālūt');
   3120+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'NQ','An Nuqaţ al Khams');
   3121+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'QB','Al Qubbah');
   3122+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'QT','Al Qaţrūn');
   3123+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'SB','Sabhā');
   3124+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'SH','Ash Shāţi');
   3125+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'SR','Surt');
   3126+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'SS','Şabrātah Şurmān');
   3127+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'TB','Ţarābulus');
   3128+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'TM','Tarhūnah-Masallātah');
   3129+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'TN','Tājūrā wa an Nawāḩī al Arbāʻ');
   3130+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'WA','Al Wāḩah');
   3131+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'WD','Wādī al Ḩayāt');
   3132+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'YJ','Yafran-Jādū');
   3133+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (121,'ZA','Az Zāwiyah');
   3134+
9373135 INSERT INTO osc_countries VALUES (122,'Liechtenstein','LI','LIE','');
<>  3136+
   3137+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'B','Balzers');
   3138+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'E','Eschen');
   3139+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'G','Gamprin');
   3140+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'M','Mauren');
   3141+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'P','Planken');
   3142+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'R','Ruggell');
   3143+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'A','Schaan');
   3144+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'L','Schellenberg');
   3145+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'N','Triesen');
   3146+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'T','Triesenberg');
   3147+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (122,'V','Vaduz');
   3148+
9383149 INSERT INTO osc_countries VALUES (123,'Lithuania','LT','LTU','');
<>  3150+
   3151+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'AL','Alytaus Apskritis');
   3152+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'KL','Klaipėdos Apskritis');
   3153+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'KU','Kauno Apskritis');
   3154+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'MR','Marijampolės Apskritis');
   3155+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'PN','Panevėžio Apskritis');
   3156+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'SA','Šiaulių Apskritis');
   3157+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'TA','Tauragės Apskritis');
   3158+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'TE','Telšių Apskritis');
   3159+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'UT','Utenos Apskritis');
   3160+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (123,'VL','Vilniaus Apskritis');
   3161+
9393162 INSERT INTO osc_countries VALUES (124,'Luxembourg','LU','LUX',":name\n:street_address\nL-:postcode :city\n:country");
<>  3163+
   3164+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (124,'D','Diekirch');
   3165+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (124,'G','Grevenmacher');
   3166+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (124,'L','Luxemburg');
   3167+
9403168 INSERT INTO osc_countries VALUES (125,'Macau','MO','MAC','');
<> 941 -INSERT INTO osc_countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','');
   3169+
   3170+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (125,'I','海島市');
   3171+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (125,'M','澳門市');
   3172+
   3173+INSERT INTO osc_countries VALUES (126,'Macedonia','MK','MKD','');
   3174+
   3175+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'BR','Berovo');
   3176+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'CH','Чешиново-Облешево');
   3177+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'DL','Делчево');
   3178+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KB','Карбинци');
   3179+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'OC','Кочани');
   3180+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'LO','Лозово');
   3181+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'MK','Македонска каменица');
   3182+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'PH','Пехчево');
   3183+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'PT','Пробиштип');
   3184+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'ST','Штип');
   3185+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'SL','Свети Николе');
   3186+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'NI','Виница');
   3187+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'ZR','Зрновци');
   3188+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KY','Кратово');
   3189+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KZ','Крива Паланка');
   3190+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'UM','Куманово');
   3191+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'LI','Липково');
   3192+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'RN','Ранковце');
   3193+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'NA','Старо Нагоричане');
   3194+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'TL','Битола');
   3195+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'DM','Демир Хисар');
   3196+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'DE','Долнени');
   3197+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KG','Кривогаштани');
   3198+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KS','Крушево');
   3199+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'MG','Могила');
   3200+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'NV','Новаци');
   3201+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'PP','Прилеп');
   3202+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'RE','Ресен');
   3203+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VJ','Боговиње');
   3204+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'BN','Брвеница');
   3205+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'GT','Гостивар');
   3206+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'JG','Јегуновце');
   3207+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'MR','Маврово и Ростуша');
   3208+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'TR','Теарце');
   3209+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'ET','Тетово');
   3210+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VH','Врапчиште');
   3211+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'ZE','Желино');
   3212+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'AD','Аеродром');
   3213+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'AR','Арачиново');
   3214+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'BU','Бутел');
   3215+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'CI','Чаир');
   3216+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'CE','Центар');
   3217+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'CS','Чучер Сандево');
   3218+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'GB','Гази Баба');
   3219+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'GP','Ѓорче Петров');
   3220+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'IL','Илинден');
   3221+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KX','Карпош');
   3222+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VD','Кисела Вода');
   3223+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'PE','Петровец');
   3224+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'AJ','Сарај');
   3225+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'SS','Сопиште');
   3226+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'SU','Студеничани');
   3227+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'SO','Шуто Оризари');
   3228+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'ZK','Зелениково');
   3229+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'BG','Богданци');
   3230+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'BS','Босилово');
   3231+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'GV','Гевгелија');
   3232+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KN','Конче');
   3233+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'NS','Ново Село');
   3234+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'RV','Радовиш');
   3235+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'SD','Стар Дојран');
   3236+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'RU','Струмица');
   3237+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VA','Валандово');
   3238+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VL','Василево');
   3239+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'CZ','Центар Жупа');
   3240+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'DB','Дебар');
   3241+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'DA','Дебарца');
   3242+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'DR','Другово');
   3243+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'KH','Кичево');
   3244+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'MD','Македонски Брод');
   3245+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'OD','Охрид');
   3246+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'OS','Осломеј');
   3247+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'PN','Пласница');
   3248+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'UG','Струга');
   3249+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VV','Вевчани');
   3250+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VC','Вранештица');
   3251+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'ZA','Зајас');
   3252+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'CA','Чашка');
   3253+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'DK','Демир Капија');
   3254+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'GR','Градско');
   3255+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'AV','Кавадарци');
   3256+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'NG','Неготино');
   3257+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'RM','Росоман');
   3258+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (126,'VE','Велес');
   3259+
9423260 INSERT INTO osc_countries VALUES (127,'Madagascar','MG','MDG','');
<>  3261+
   3262+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (127,'A','Toamasina');
   3263+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (127,'D','Antsiranana');
   3264+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (127,'F','Fianarantsoa');
   3265+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (127,'M','Mahajanga');
   3266+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (127,'T','Antananarivo');
   3267+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (127,'U','Toliara');
   3268+