REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('FO', 'Faroe Islands', 'Føroyar', 'faroe-islands', '298', 'DKK');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5610816, 'FO', 'Vágar', 1, 'vagar'),
(5612137, 'FO', 'Suðuroy', 1, 'suduroy'),
(5612225, 'FO', 'Streymoy', 1, 'streymoy'),
(5614219, 'FO', 'Sandoy', 1, 'sandoy'),
(5616145, 'FO', 'Norðoyar', 1, 'nordoyar'),
(5622387, 'FO', 'Eysturoy', 1, 'eysturoy');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(5609913, 5612225, 'FO', 'Ytri Skáli', 1, 'ytri-skali', 62.15853, -6.78301),
(5610267, 5612137, 'FO', 'Víkarbyrgi', 1, 'vikarbyrgi', 61.44268, -6.7238),
(5610270, 5610816, 'FO', 'Vikar', 1, 'vikar', 62.13333, -7.36667),
(5610293, 5612225, 'FO', 'Við Sjógv', 1, 'vid-sjogv', 62.11821, -6.89744),
(5610296, 5612137, 'FO', 'Við Neyst', 1, 'vidh-neyst', 61.59868, -6.94971),
(5610297, 5610816, 'FO', 'Við Kirkjar', 1, 'vid-kirkjar', 62.04555, -7.19551),
(5610300, 5616145, 'FO', 'Við Garð', 1, 'vidh-gardh', 62.36651, -6.54327),
(5610301, 5622387, 'FO', 'Við Garð', 1, 'vid-gard', 62.20938, -6.72079),
(5610343, 5612225, 'FO', 'Vestmanna', 1, 'vestmanna', 62.15354, -7.17291),
(5610565, 5612225, 'FO', 'Velbastaður', 1, 'velbastadur', 61.98084, -6.85259),
(5610685, 5610816, 'FO', 'Vatnsoyrar', 1, 'vatnsoyrar', 62.06667, -7.23333),
(5610762, 5612225, 'FO', 'Válur', 1, 'valur', 62.15033, -7.14392),
(5610805, 5616145, 'FO', 'Vágur', 1, 'vagur', 62.22398, -6.58633),
(5610806, 5612137, 'FO', 'Vágur', 1, 'vagur', 61.47324, -6.81185),
(5610811, 5616145, 'FO', 'Vágsheygur', 1, 'vagsheygur', 62.22127, -6.56935),
(5610846, 5612225, 'FO', 'Uti á Fløtum', 1, 'uti-a-flotum', 62.03333, -6.95),
(5610877, 5616145, 'FO', 'Uppsalir', 1, 'uppsalir', 62.22201, -6.58421),
(5611060, 5612137, 'FO', 'Tvøroyri', 1, 'tvoroyri', 61.55557, -6.81109),
(5611199, 5622387, 'FO', 'Trøllanes', 1, 'trollanes', 62.36087, -6.78266),
(5611209, 5612137, 'FO', 'Trongisvágur', 1, 'trongisvagur', 61.56262, -6.84793),
(5611321, 5614219, 'FO', 'Traðir', 1, 'tradhir', 61.8437, -6.79075),
(5611396, 5612225, 'FO', 'Tórshavn', 1, 'torshavn', 62.00973, -6.77164),
(5611450, 5612225, 'FO', 'Torkilsheyggjur', 1, 'torkilsheyggjur', 62.08454, -6.73419),
(5611566, 5612225, 'FO', 'Toftir', 1, 'toftir', 62.15, -6.93333),
(5611568, 5612137, 'FO', 'Toftir', 1, 'toftir', 61.59747, -6.94468),
(5611587, 5622387, 'FO', 'Toftanes', 1, 'toftanes', 62.21172, -6.70969),
(5611596, 5612225, 'FO', 'Todnes', 1, 'todnes', 62.11828, -6.88512),
(5611614, 5612225, 'FO', 'Tjørnuvík', 1, 'tjornuvik', 62.28896, -7.14555),
(5611796, 5612137, 'FO', 'Teigar', 1, 'teigar', 61.52187, -6.88469),
(5611962, 5622387, 'FO', 'Syðrugøta', 1, 'sydhrugota', 62.18371, -6.75145),
(5611964, 5622387, 'FO', 'Syðradalur', 1, 'sydhradalur', 62.245, -6.66057),
(5611965, 5612225, 'FO', 'Syðradalur', 1, 'sydradalur', 62.01882, -6.9086),
(5611990, 5616145, 'FO', 'Svínoy', 1, 'svinoy', 62.27865, -6.33389),
(5612011, 5622387, 'FO', 'Svínáir', 1, 'svinair', 62.23164, -7.02842),
(5612123, 5612225, 'FO', 'Sund', 1, 'sund', 62.04728, -6.83661),
(5612128, 5612137, 'FO', 'Sumba', 1, 'sumba', 61.40317, -6.71196),
(5612147, 5612225, 'FO', 'Stykkið', 1, 'stykkid', 62.11765, -7.06006),
(5612216, 5616145, 'FO', 'Strond', 1, 'strond', 62.26667, -6.58333),
(5612230, 5612225, 'FO', 'Streymnes', 1, 'streymnes', 62.19153, -7.0315),
(5612233, 5612225, 'FO', 'Strendur', 1, 'strendur', 62.10729, -6.75721),
(5612890, 5610816, 'FO', 'Sørvágur', 1, 'sorvagur', 62.07203, -7.30749),
(5613129, 5614219, 'FO', 'Søltuvík', 1, 'soltuvik', 61.84693, -6.88732),
(5613140, 5622387, 'FO', 'Søldarfjørður', 1, 'soldarfjordur', 62.16319, -6.75429),
(5613400, 5612225, 'FO', 'Slættanes', 1, 'slaettanes', 62.15372, -7.24506),
(5613477, 5614219, 'FO', 'Skúvoy', 1, 'skuvoy', 61.77103, -6.80501),
(5613489, 5614219, 'FO', 'Skúli', 1, 'skuli', 61.83739, -6.80723),
(5613660, 5614219, 'FO', 'Skopun', 1, 'skopun', 61.90285, -6.88234),
(5613695, 5612225, 'FO', 'Skælingur', 1, 'skaelingur', 62.09637, -7.00609),
(5613735, 5622387, 'FO', 'Skipanes', 1, 'skipanes', 62.17207, -6.76502),
(5613827, 5614219, 'FO', 'Skarvanes', 1, 'skarvanes', 61.79423, -6.74543),
(5613874, 5616145, 'FO', 'Skarð', 1, 'skardh', 62.32343, -6.64254),
(5613915, 5622387, 'FO', 'Skáli', 1, 'skali', 62.15536, -6.7794),
(5613921, 5614219, 'FO', 'Skálavík', 1, 'skalavik', 61.83141, -6.6623),
(5613925, 5612137, 'FO', 'Skálar', 1, 'skalar', 61.60302, -6.95709),
(5613929, 5622387, 'FO', 'Skálafjørður', 1, 'skalafjordhur', 62.19501, -6.84771),
(5613956, 5612137, 'FO', 'Sjóvartoftir', 1, 'sjovartoftir', 61.47461, -6.74964),
(5614036, 5612225, 'FO', 'Signabøur', 1, 'signabour', 62.09619, -6.92727),
(5614063, 5612225, 'FO', 'Sevlendi', 1, 'sevlendi', 62.11277, -6.75532),
(5614098, 5622387, 'FO', 'Selatrað', 1, 'selatrad', 62.15637, -6.87163),
(5614203, 5612137, 'FO', 'Sandvík', 1, 'sandvik', 61.63285, -6.92458),
(5614212, 5614219, 'FO', 'Sandur', 1, 'sandur', 61.8425, -6.80778),
(5614265, 5610816, 'FO', 'Sandavágur', 1, 'sandavagur', 62.05372, -7.14982),
(5614295, 5612225, 'FO', 'Saltnes', 1, 'saltnes', 62.10296, -6.73952),
(5614304, 5622387, 'FO', 'Saltangará', 1, 'saltangara', 62.11647, -6.71797),
(5614323, 5612225, 'FO', 'Saksun', 1, 'saksun', 62.24821, -7.17241),
(5614359, 5610816, 'FO', 'Ryggur', 1, 'ryggur', 62.05072, -7.20378),
(5614402, 5622387, 'FO', 'Runavík', 1, 'runavik', 62.10892, -6.72123),
(5614699, 5612225, 'FO', 'Rituvík', 1, 'rituvik', 62.10447, -6.68701),
(5615077, 5612137, 'FO', 'Punthavn', 1, 'punthavn', 61.55, -6.81667),
(5615132, 5612137, 'FO', 'Porkeri', 1, 'porkeri', 61.48135, -6.74497),
(5615253, 5612225, 'FO', 'Oyri', 1, 'oyri', 62.19032, -6.9776),
(5615255, 5610816, 'FO', 'Oyrargjógv', 1, 'oyrargjogv', 62.11667, -7.16667),
(5615258, 5612225, 'FO', 'Oyrareingir', 1, 'oyrareingir', 62.09921, -6.94553),
(5615259, 5622387, 'FO', 'Oyrarbakki', 1, 'oyrarbakki', 62.20995, -7.00001),
(5615261, 5622387, 'FO', 'Oyndarfjørður', 1, 'oyndarfjordhur', 62.27792, -6.84643),
(5615720, 5612137, 'FO', 'Øravík', 1, 'oravik', 61.53479, -6.8077),
(5615821, 5612137, 'FO', 'Oman fyri Kirkju', 1, 'oman-fyri-kirkju', 61.52596, -6.87989),
(5616138, 5616145, 'FO', 'Norðtoftir', 1, 'nordhtoftir', 62.27546, -6.50808),
(5616140, 5622387, 'FO', 'Norðskáli', 1, 'nordhskali', 62.22187, -7.00513),
(5616142, 5622387, 'FO', 'Norðragøta', 1, 'nordragota', 62.20071, -6.74191),
(5616143, 5612225, 'FO', 'Norðradalur', 1, 'nordradalur', 62.03889, -6.92554),
(5616144, 5616145, 'FO', 'Norðoyri', 1, 'nordoyri', 62.21667, -6.53333),
(5616148, 5616145, 'FO', 'Norðdepil', 1, 'nordhdepil', 62.29467, -6.52506),
(5616437, 5612225, 'FO', 'Nólsoy', 1, 'nolsoy', 62.00937, -6.67019),
(5616491, 5612225, 'FO', 'Nesvík', 1, 'nesvik', 62.21667, -7.01667),
(5616495, 5612225, 'FO', 'Nesið', 1, 'nesid', 62.15006, -7.15493),
(5616498, 5622387, 'FO', 'Nes', 1, 'nes', 62.08202, -6.72724),
(5616499, 5612137, 'FO', 'Nes', 1, 'nes', 61.59271, -6.92701),
(5616628, 5616145, 'FO', 'Myrkjanoyri', 1, 'myrkjanoyri', 62.22905, -6.57725),
(5616648, 5610816, 'FO', 'Mykines', 1, 'mykines', 62.10489, -7.63417),
(5616709, 5616145, 'FO', 'Múli', 1, 'muli', 62.35059, -6.57688),
(5616756, 5622387, 'FO', 'Morskranes', 1, 'morskranes', 62.13244, -6.84138),
(5616900, 5622387, 'FO', 'Mikladalur', 1, 'mikladalur', 62.33345, -6.75958),
(5616914, 5610816, 'FO', 'Miðvágur', 1, 'midvagur', 62.05111, -7.19389),
(5616916, 5612225, 'FO', 'Miðgerði', 1, 'midgerdi', 62.11912, -6.88422),
(5617406, 5612137, 'FO', 'Lopra', 1, 'lopra', 61.44361, -6.77135),
(5617513, 5622387, 'FO', 'Ljósá', 1, 'ljosa', 62.26724, -7.06241),
(5617758, 5612137, 'FO', 'Líðin', 1, 'lidin', 61.55, -6.83333),
(5617771, 5612225, 'FO', 'Leynar', 1, 'leynar', 62.1165, -7.04054),
(5617840, 5612137, 'FO', 'Leiti', 1, 'leiti', 61.44997, -6.75167),
(5617844, 5622387, 'FO', 'Leirvík', 1, 'leirvik', 62.20992, -6.69284),
(5617970, 5612225, 'FO', 'Langasandur', 1, 'langasandur', 62.23354, -7.04654),
(5617971, 5622387, 'FO', 'Langasandur', 1, 'langasandur', 62.16229, -6.78724),
(5618005, 5622387, 'FO', 'Lambi', 1, 'lambi', 62.13969, -6.69968),
(5618011, 5622387, 'FO', 'Lambareiði', 1, 'lambareidi', 62.13333, -6.71667),
(5618085, 5612225, 'FO', 'Kvívík', 1, 'kvivik', 62.11731, -7.07471),
(5618119, 5616145, 'FO', 'Kunoy', 1, 'kunoy', 62.30388, -6.64754),
(5618175, 5612137, 'FO', 'Krosslið', 1, 'krosslid', 61.47375, -6.8038),
(5618304, 5612137, 'FO', 'Kráir', 1, 'krair', 61.46742, -6.8138),
(5618487, 5612225, 'FO', 'Koltur', 1, 'koltur', 61.98647, -6.96242),
(5618511, 5612225, 'FO', 'Kollafjørður', 1, 'kollafjordhur', 62.11167, -6.91067),
(5618537, 5612225, 'FO', 'Kolbanargjógv', 1, 'kolbanargjogv', 62.1, -6.78333),
(5618795, 5616145, 'FO', 'Klaksvík', 1, 'klaksvik', 62.22655, -6.58901),
(5618823, 5612225, 'FO', 'Kjalnes', 1, 'kjalnes', 62.11667, -6.86667),
(5618846, 5612225, 'FO', 'Kirkjubøur', 1, 'kirkjubour', 61.95306, -6.79078),
(5618855, 5616145, 'FO', 'Kirkja', 1, 'kirkja', 62.31851, -6.31646),
(5619192, 5612225, 'FO', 'Kaldbak', 1, 'kaldbak', 62.06057, -6.82808),
(5619361, 5610816, 'FO', 'Jansagerði', 1, 'jansagerdi', 62.04385, -7.18592),
(5619389, 5612225, 'FO', 'Innan Glyvur', 1, 'innan-glyvur', 62.13333, -6.75),
(5619427, 5612225, 'FO', 'Í Húsi', 1, 'i-husi', 62.04859, -7.16309),
(5619428, 5612137, 'FO', 'Í Hørg', 1, 'i-horg', 61.40719, -6.72304),
(5619433, 5612137, 'FO', 'Í Fámara', 1, 'i-famara', 61.46667, -6.86667),
(5619444, 5612137, 'FO', 'Í Botni', 1, 'i-botni', 61.48333, -6.78333),
(5619504, 5612225, 'FO', 'Hvítanes', 1, 'hvitanes', 62.04547, -6.76297),
(5619505, 5612137, 'FO', 'Hvítanes', 1, 'hvitanes', 61.5586, -6.8368),
(5619568, 5616145, 'FO', 'Hvannasund', 1, 'hvannasund', 62.29687, -6.51854),
(5619580, 5612225, 'FO', 'Hvalvík', 1, 'hvalvik', 62.18778, -7.03278),
(5619596, 5612137, 'FO', 'Hvalba', 1, 'hvalba', 61.60237, -6.96063),
(5619612, 5614219, 'FO', 'Húsavík', 1, 'husavik', 61.8076, -6.67091),
(5619615, 5622387, 'FO', 'Húsar', 1, 'husar', 62.26265, -6.68908),
(5619693, 5612225, 'FO', 'Hoyvík', 1, 'hoyvik', 62.03407, -6.78127),
(5619734, 5612137, 'FO', 'Hov', 1, 'hov', 61.50684, -6.75993),
(5619744, 5612225, 'FO', 'Hósvík', 1, 'hosvik', 62.15187, -6.94527),
(5620149, 5612137, 'FO', 'Hólar', 1, 'holar', 61.60513, -6.95063),
(5620327, 5612225, 'FO', 'Heyggjur', 1, 'heyggjur', 62.10263, -6.94433),
(5620338, 5612225, 'FO', 'Hestur', 1, 'hestur', 61.95581, -6.8826),
(5620482, 5622387, 'FO', 'Hellur', 1, 'hellur', 62.26245, -6.84142),
(5620680, 5616145, 'FO', 'Hattarvík', 1, 'hattarvik', 62.32942, -6.27572),
(5620774, 5616145, 'FO', 'Haraldssund', 1, 'haraldssund', 62.2725, -6.60299),
(5620811, 5612137, 'FO', 'Hamrabyrgi', 1, 'hamrabyrgi', 61.44063, -6.72576),
(5620837, 5612225, 'FO', 'Hamar', 1, 'hamar', 62.11986, -6.90485),
(5620838, 5612137, 'FO', 'Hamar', 1, 'hamar', 61.6, -6.95),
(5620913, 5612225, 'FO', 'Haldarsvík', 1, 'haldarsvik', 62.27555, -7.09331),
(5621180, 5622387, 'FO', 'Grógv', 1, 'grogv', 62.18064, -6.75078),
(5621294, 5622387, 'FO', 'Gøtugjógv', 1, 'gotugjogv', 62.19201, -6.74338),
(5621296, 5622387, 'FO', 'Gøtueiði', 1, 'gotueidi', 62.18333, -6.76667),
(5621300, 5622387, 'FO', 'Gøta', 1, 'gota', 62.19894, -6.73605),
(5621340, 5622387, 'FO', 'Glyvrar', 1, 'glyvrar', 62.12475, -6.72152),
(5621407, 5612225, 'FO', 'Gjógvin', 1, 'gjogvin', 62.14179, -7.02698),
(5621415, 5622387, 'FO', 'Gjógv', 1, 'gjogv', 62.32294, -6.93579),
(5621440, 5612225, 'FO', 'Gjánoyri', 1, 'gjanoyri', 62.22535, -7.03875),
(5621508, 5616145, 'FO', 'Gerðar', 1, 'gerdar', 62.23333, -6.56667),
(5621509, 5622387, 'FO', 'Gerðar', 1, 'gerdar', 62.10414, -6.76891),
(5621596, 5610816, 'FO', 'Gásadalur', 1, 'gasadalur', 62.11238, -7.43245),
(5621765, 5622387, 'FO', 'Funningur', 1, 'funningur', 62.28713, -6.96799),
(5621767, 5622387, 'FO', 'Funningsfjørður', 1, 'funningsfjordur', 62.23656, -6.92527),
(5621808, 5622387, 'FO', 'Fuglafjørður', 1, 'fuglafjordur', 62.24398, -6.81395),
(5621852, 5612137, 'FO', 'Froðba', 1, 'frodhba', 61.54382, -6.7703),
(5622039, 5616145, 'FO', 'Fodlendi', 1, 'fodlendi', 62.36292, -6.53588),
(5622348, 5612137, 'FO', 'Fámjin', 1, 'famjin', 61.52564, -6.88068),
(5622625, 5622387, 'FO', 'Elduvík', 1, 'elduvik', 62.28022, -6.90517),
(5622676, 5622387, 'FO', 'Eiði', 1, 'eidi', 62.2993, -7.09245),
(5623007, 5614219, 'FO', 'Djúpidalur', 1, 'djupidalur', 61.8, -6.75),
(5623031, 5616145, 'FO', 'Depil', 1, 'depil', 62.28686, -6.52282),
(5623092, 5614219, 'FO', 'Dalur', 1, 'dalur', 61.78456, -6.67153),
(5623713, 5610816, 'FO', 'Bøur', 1, 'bour', 62.08781, -7.36629),
(5623933, 5616145, 'FO', 'Blankskáli', 1, 'blankskali', 62.23195, -6.69799),
(5624094, 5616145, 'FO', 'Biskupsstøð', 1, 'biskupsstod', 62.22701, -6.57685),
(5624483, 5612225, 'FO', 'Á Steig', 1, 'a-steig', 62.15, -7.13333),
(5624633, 5616145, 'FO', 'Árnafjørður', 1, 'arnafjordur', 62.25264, -6.52006),
(5624653, 5612225, 'FO', 'Argir', 1, 'argir', 61.99595, -6.77154),
(5624689, 5616145, 'FO', 'Ánir', 1, 'anir', 62.25601, -6.57525),
(5624918, 5612137, 'FO', 'Akrar', 1, 'akrar', 61.45575, -6.7602),
(5624923, 5612137, 'FO', 'Akraberg', 1, 'akraberg', 61.39376, -6.67917),
(5625012, 5622387, 'FO', 'Æðuvík', 1, 'aedhuvik', 62.06917, -6.68606),
(9955573, 5612137, 'FO', 'Suduroy', 1, 'suduroy', 61.51877, -6.83006),
(11181592, 5612225, 'FO', 'millum Gilja', 1, 'millum-gilja', 62.03451, -6.78968);