REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('SK', 'Slovakia', 'slovakia', '421', 'Slovensko', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004352, 'SK', 'Banská Bystrica Region', 1, 'banska-bystrica-region');

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 
(1104370, 1004352, 'SK', 'Banská Bystrica', 1, 'banska-bystrica', 48.73946000, 19.15349000),
(1104371, 1004352, 'SK', 'Banská Štiavnica', 1, 'banska-stiavnica', 48.44858000, 18.91003000),
(1104376, 1004352, 'SK', 'Brezno', 1, 'brezno', 48.80431000, 19.63631000),
(1104589, 1004352, 'SK', 'Čierny Balog', 1, 'cierny-balog', 48.74722000, 19.65125000),
(1104381, 1004352, 'SK', 'Detva', 1, 'detva', 48.56082000, 19.41954000),
(1104385, 1004352, 'SK', 'Dudince', 1, 'dudince', 48.17135000, 18.88782000),
(1104388, 1004352, 'SK', 'Fiľakovo', 1, 'filakovo', 48.26757000, 19.82473000),
(1104397, 1004352, 'SK', 'Hriňová', 1, 'hrinova', 48.57787000, 19.52574000),
(1104398, 1004352, 'SK', 'Hrochoť,Slovakia', 1, 'hrochot-slovakia', 48.65567000, 19.31284000),
(1104408, 1004352, 'SK', 'Kováčová', 1, 'kovacova', 48.60148000, 19.10252000),
(1104415, 1004352, 'SK', 'Kremnica', 1, 'kremnica', 48.70519000, 18.91834000),
(1104417, 1004352, 'SK', 'Krupina', 1, 'krupina', 48.35540000, 19.06474000),
(1104426, 1004352, 'SK', 'Lučenec', 1, 'lucenec', 48.33249000, 19.66708000),
(1104440, 1004352, 'SK', 'Nová Baňa', 1, 'nova-bana', 48.42305000, 18.64037000),
(1104447, 1004352, 'SK', 'Okres Banská Bystrica', 1, 'okres-banska-bystrica', 48.73333000, 19.15000000),
(1104448, 1004352, 'SK', 'Okres Banská Štiavnica', 1, 'okres-banska-stiavnica', 48.44961000, 18.90820000),
(1104455, 1004352, 'SK', 'Okres Brezno', 1, 'okres-brezno', 48.80000000, 19.75000000),
(1104458, 1004352, 'SK', 'Okres Detva', 1, 'okres-detva', 48.55985000, 19.42044000),
(1104469, 1004352, 'SK', 'Okres Krupina', 1, 'okres-krupina', 48.35736000, 19.06334000),
(1104474, 1004352, 'SK', 'Okres Lučenec', 1, 'okres-lucenec', 48.33333000, 19.66667000),
(1104487, 1004352, 'SK', 'Okres Poltár', 1, 'okres-poltar', 48.42895000, 19.79488000),
(1104493, 1004352, 'SK', 'Okres Revúca', 1, 'okres-revuca', 48.68300000, 20.11568000),
(1104512, 1004352, 'SK', 'Okres Veľký Krtíš', 1, 'okres-velky-krtis', 48.20000000, 19.35000000),
(1104518, 1004352, 'SK', 'Okres Žarnovica', 1, 'okres-zarnovica', 48.48438000, 18.72076000),
(1104519, 1004352, 'SK', 'Okres Žiar nad Hronom', 1, 'okres-ziar-nad-hronom', 48.58333000, 18.86667000),
(1104515, 1004352, 'SK', 'Okres Zvolen', 1, 'okres-zvolen', 48.58333000, 19.13333000),
(1104527, 1004352, 'SK', 'Poltár', 1, 'poltar', 48.43094000, 19.79408000),
(1104535, 1004352, 'SK', 'Revúca', 1, 'revuca', 48.68346000, 20.11734000),
(1104536, 1004352, 'SK', 'Rimavská Sobota', 1, 'rimavska-sobota', 48.38284000, 20.02239000),
(1104559, 1004352, 'SK', 'Svätý Anton', 1, 'svaty-anton', 48.41923000, 18.94010000),
(1104562, 1004352, 'SK', 'Tisovec', 1, 'tisovec', 48.67738000, 19.94364000),
(1104573, 1004352, 'SK', 'Veľký Krtíš', 1, 'velky-krtis', 48.21059000, 19.35043000),
(1104597, 1004352, 'SK', 'Žarnovica', 1, 'zarnovica', 48.48123000, 18.71565000),
(1104601, 1004352, 'SK', 'Žiar nad Hronom', 1, 'ziar-nad-hronom', 48.59184000, 18.84958000),
(1104585, 1004352, 'SK', 'Zvolen', 1, 'zvolen', 48.57442000, 19.15324000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004356, 'SK', 'Bratislava Region', 1, 'bratislava-region');

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 
(1104374, 1004356, 'SK', 'Bratislava', 1, 'bratislava', 48.14816000, 17.10674000),
(1104375, 1004356, 'SK', 'Bratislava - Vajnory', 1, 'bratislava-vajnory', 48.20563000, 17.20759000),
(1104386, 1004356, 'SK', 'Dunajská Lužná', 1, 'dunajska-luzna', 48.08347000, 17.26072000),
(1104403, 1004356, 'SK', 'Ivanka pri Dunaji', 1, 'ivanka-pri-dunaji', 48.18675000, 17.25540000),
(1104428, 1004356, 'SK', 'Malacky', 1, 'malacky', 48.43604000, 17.02188000),
(1104429, 1004356, 'SK', 'Marianka', 1, 'marianka', 48.24903000, 17.06400000),
(1104434, 1004356, 'SK', 'Modra', 1, 'modra', 48.33397000, 17.30711000),
(1104450, 1004356, 'SK', 'Okres Bratislava I', 1, 'okres-bratislava-i', 48.14653000, 17.10584000),
(1104451, 1004356, 'SK', 'Okres Bratislava II', 1, 'okres-bratislava-ii', 48.15280000, 17.17764000),
(1104452, 1004356, 'SK', 'Okres Bratislava III', 1, 'okres-bratislava-iii', 48.18543000, 17.13790000),
(1104453, 1004356, 'SK', 'Okres Bratislava IV', 1, 'okres-bratislava-iv', 48.22787000, 16.99722000),
(1104454, 1004356, 'SK', 'Okres Bratislava V', 1, 'okres-bratislava-v', 48.11122000, 17.09444000),
(1104475, 1004356, 'SK', 'Okres Malacky', 1, 'okres-malacky', 48.43458000, 17.02166000),
(1104485, 1004356, 'SK', 'Okres Pezinok', 1, 'okres-pezinok', 48.28785000, 17.26799000),
(1104497, 1004356, 'SK', 'Okres Senec', 1, 'okres-senec', 48.22187000, 17.40328000),
(1104524, 1004356, 'SK', 'Pezinok', 1, 'pezinok', 48.28986000, 17.26664000),
(1104540, 1004356, 'SK', 'Senec', 1, 'senec', 48.21951000, 17.40043000),
(1104555, 1004356, 'SK', 'Stupava', 1, 'stupava', 48.27474000, 17.03173000),
(1104560, 1004356, 'SK', 'Svätý Jur', 1, 'svaty-jur', 48.25216000, 17.21539000),
(1104576, 1004356, 'SK', 'Vinosady', 1, 'vinosady', 48.31142000, 17.29042000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004353, 'SK', 'Košice Region', 1, 'kosice-region');

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 
(1104588, 1004353, 'SK', 'Čierna nad Tisou', 1, 'cierna-nad-tisou', 48.41704000, 22.08865000),
(1104382, 1004353, 'SK', 'Dobšiná', 1, 'dobsina', 48.82073000, 20.36988000),
(1104392, 1004353, 'SK', 'Gelnica', 1, 'gelnica', 48.85584000, 20.93713000),
(1104404, 1004353, 'SK', 'Kavečany', 1, 'kavecany', 48.77592000, 21.20587000),
(1104409, 1004353, 'SK', 'Košice', 1, 'kosice', 48.71395000, 21.25808000),
(1104410, 1004353, 'SK', 'Košice I', 1, 'kosice-i', 48.72914000, 21.25004000),
(1104411, 1004353, 'SK', 'Košice II', 1, 'kosice-ii', 48.69753000, 21.22273000),
(1104412, 1004353, 'SK', 'Košice III', 1, 'kosice-iii', 48.73242000, 21.29047000),
(1104413, 1004353, 'SK', 'Košice IV', 1, 'kosice-iv', 48.68691000, 21.26570000),
(1104416, 1004353, 'SK', 'Krompachy', 1, 'krompachy', 48.91447000, 20.87514000),
(1104431, 1004353, 'SK', 'Medzev', 1, 'medzev', 48.70041000, 20.89367000),
(1104433, 1004353, 'SK', 'Michalovce', 1, 'michalovce', 48.75434000, 21.91950000),
(1104435, 1004353, 'SK', 'Moldava nad Bodvou', 1, 'moldava-nad-bodvou', 48.61428000, 20.99957000),
(1104462, 1004353, 'SK', 'Okres Gelnica', 1, 'okres-gelnica', 48.85207000, 20.93385000),
(1104468, 1004353, 'SK', 'Okres Kosice-okolie', 1, 'okres-kosice-okolie', 48.77897000, 21.41373000),
(1104478, 1004353, 'SK', 'Okres Michalovce', 1, 'okres-michalovce', 48.75000000, 21.93333000),
(1104494, 1004353, 'SK', 'Okres Rožňava', 1, 'okres-roznava', 48.66667000, 20.53333000),
(1104501, 1004353, 'SK', 'Okres Sobrance', 1, 'okres-sobrance', 48.74247000, 22.18197000),
(1104502, 1004353, 'SK', 'Okres Spišská Nová Ves', 1, 'okres-spisska-nova-ves', 48.95000000, 20.56667000),
(1104507, 1004353, 'SK', 'Okres Trebišov', 1, 'okres-trebisov', 48.63333000, 21.71667000),
(1104537, 1004353, 'SK', 'Rožňava', 1, 'roznava', 48.66009000, 20.53758000),
(1104542, 1004353, 'SK', 'Sečovce', 1, 'secovce', 48.70074000, 21.66104000),
(1104547, 1004353, 'SK', 'Sobrance', 1, 'sobrance', 48.74455000, 22.18136000),
(1104549, 1004353, 'SK', 'Spišská Nová Ves', 1, 'spisska-nova-ves', 48.94464000, 20.56153000),
(1104554, 1004353, 'SK', 'Strážske', 1, 'strazske', 48.87350000, 21.83668000),
(1104565, 1004353, 'SK', 'Trebišov', 1, 'trebisov', 48.62858000, 21.71954000),
(1104575, 1004353, 'SK', 'Vinné', 1, 'vinne', 48.80965000, 21.96757000),
(1104599, 1004353, 'SK', 'Žehra', 1, 'zehra', 48.97960000, 20.79170000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004357, 'SK', 'Nitra Region', 1, 'nitra-region');

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 
(1104400, 1004357, 'SK', 'Hurbanovo', 1, 'hurbanovo', 47.86984000, 18.19233000),
(1104406, 1004357, 'SK', 'Kolárovo', 1, 'kolarovo', 47.92294000, 17.98467000),
(1104407, 1004357, 'SK', 'Komárno', 1, 'komarno', 47.76356000, 18.12263000),
(1104421, 1004357, 'SK', 'Levice', 1, 'levice', 48.21563000, 18.60705000),
(1104438, 1004357, 'SK', 'Nitra', 1, 'nitra', 48.30763000, 18.08453000),
(1104445, 1004357, 'SK', 'Nové Zámky', 1, 'nove-zamky', 47.98544000, 18.16195000),
(1104467, 1004357, 'SK', 'Okres Komárno', 1, 'okres-komarno', 47.76667000, 18.13333000),
(1104471, 1004357, 'SK', 'Okres Levice', 1, 'okres-levice', 48.21667000, 18.60000000),
(1104481, 1004357, 'SK', 'Okres Nitra', 1, 'okres-nitra', 48.31667000, 18.08333000),
(1104483, 1004357, 'SK', 'Okres Nové Zámky', 1, 'okres-nove-zamky', 47.98333000, 18.16667000),
(1104517, 1004357, 'SK', 'Okres Šaľa', 1, 'okres-sala', 48.14770000, 17.87306000),
(1104506, 1004357, 'SK', 'Okres Topoľčany', 1, 'okres-topolcany', 48.56667000, 18.18333000),
(1104514, 1004357, 'SK', 'Okres Zlaté Moravce', 1, 'okres-zlate-moravce', 48.38294000, 18.39842000),
(1104591, 1004357, 'SK', 'Šahy', 1, 'sahy', 48.07408000, 18.94946000),
(1104593, 1004357, 'SK', 'Šaľa', 1, 'sala', 48.15127000, 17.88062000),
(1104595, 1004357, 'SK', 'Štúrovo', 1, 'sturovo', 47.79495000, 18.71750000),
(1104596, 1004357, 'SK', 'Šurany', 1, 'surany', 48.08613000, 18.18447000),
(1104558, 1004357, 'SK', 'Svodín', 1, 'svodin', 47.91054000, 18.49967000),
(1104563, 1004357, 'SK', 'Tlmače', 1, 'tlmace', 48.28926000, 18.53152000),
(1104564, 1004357, 'SK', 'Topoľčany', 1, 'topolcany', 48.56361000, 18.16712000),
(1104580, 1004357, 'SK', 'Vráble', 1, 'vrable', 48.24371000, 18.30846000),
(1104600, 1004357, 'SK', 'Želiezovce', 1, 'zeliezovce', 48.05075000, 18.65421000),
(1104584, 1004357, 'SK', 'Zlaté Moravce', 1, 'zlate-moravce', 48.38553000, 18.40063000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004354, 'SK', 'Prešov Region', 1, 'presov-region');

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 
(1104372, 1004354, 'SK', 'Bardejov', 1, 'bardejov', 49.29175000, 21.27271000),
(1104380, 1004354, 'SK', 'Chlmec', 1, 'chlmec', 48.88628000, 21.93930000),
(1104393, 1004354, 'SK', 'Giraltovce', 1, 'giraltovce', 49.11398000, 21.51731000),
(1104399, 1004354, 'SK', 'Humenné', 1, 'humenne', 48.93707000, 21.91625000),
(1104405, 1004354, 'SK', 'Kežmarok', 1, 'kezmarok', 49.13571000, 20.43352000),
(1104422, 1004354, 'SK', 'Levoča', 1, 'levoca', 49.02173000, 20.59212000),
(1104423, 1004354, 'SK', 'Lipany', 1, 'lipany', 49.15376000, 20.96382000),
(1104590, 1004354, 'SK', 'Ľubica', 1, 'lubica', 49.11667000, 20.45000000),
(1104432, 1004354, 'SK', 'Medzilaborce', 1, 'medzilaborce', 49.27195000, 21.90073000),
(1104442, 1004354, 'SK', 'Nová Lesná', 1, 'nova-lesna', 49.12253000, 20.26737000),
(1104449, 1004354, 'SK', 'Okres Bardejov', 1, 'okres-bardejov', 49.28333000, 21.28333000),
(1104464, 1004354, 'SK', 'Okres Humenné', 1, 'okres-humenne', 48.93333000, 21.91667000),
(1104466, 1004354, 'SK', 'Okres Kežmarok', 1, 'okres-kezmarok', 49.13593000, 20.42929000),
(1104472, 1004354, 'SK', 'Okres Levoča', 1, 'okres-levoca', 49.01986000, 20.57688000),
(1104477, 1004354, 'SK', 'Okres Medzilaborce', 1, 'okres-medzilaborce', 49.27062000, 21.90200000),
(1104488, 1004354, 'SK', 'Okres Poprad', 1, 'okres-poprad', 49.05000000, 20.30000000),
(1104490, 1004354, 'SK', 'Okres Prešov', 1, 'okres-presov', 49.00000000, 21.25000000),
(1104496, 1004354, 'SK', 'Okres Sabinov', 1, 'okres-sabinov', 49.10115000, 21.09844000),
(1104500, 1004354, 'SK', 'Okres Snina', 1, 'okres-snina', 48.98579000, 22.15059000),
(1104503, 1004354, 'SK', 'Okres Stará Ĺubovňa', 1, 'okres-stara-lubovna', 49.30000000, 20.70000000),
(1104504, 1004354, 'SK', 'Okres Stropkov', 1, 'okres-stropkov', 49.20249000, 21.65025000),
(1104505, 1004354, 'SK', 'Okres Svidník', 1, 'okres-svidnik', 49.30000000, 21.56667000),
(1104513, 1004354, 'SK', 'Okres Vranov nad Topľou', 1, 'okres-vranov-nad-toplou', 48.90000000, 21.68333000),
(1104526, 1004354, 'SK', 'Podolínec', 1, 'podolinec', 49.25869000, 20.53600000),
(1104528, 1004354, 'SK', 'Poprad', 1, 'poprad', 49.06144000, 20.29798000),
(1104530, 1004354, 'SK', 'Prešov', 1, 'presov', 48.99839000, 21.23393000),
(1104539, 1004354, 'SK', 'Sabinov', 1, 'sabinov', 49.10309000, 21.09880000),
(1104546, 1004354, 'SK', 'Snina', 1, 'snina', 48.98857000, 22.15099000),
(1104548, 1004354, 'SK', 'Spišská Belá', 1, 'spisska-bela', 49.18725000, 20.45948000),
(1104550, 1004354, 'SK', 'Spišské Podhradie', 1, 'spisske-podhradie', 49.00088000, 20.75307000),
(1104552, 1004354, 'SK', 'Stará Ľubovňa', 1, 'stara-lubovna', 49.29859000, 20.68620000),
(1104594, 1004354, 'SK', 'Štrba', 1, 'strba', 49.05913000, 20.07975000),
(1104553, 1004354, 'SK', 'Stropkov', 1, 'stropkov', 49.20211000, 21.65216000),
(1104556, 1004354, 'SK', 'Svidník', 1, 'svidnik', 49.30819000, 21.57030000),
(1104557, 1004354, 'SK', 'Svit', 1, 'svit', 49.06014000, 20.20695000),
(1104577, 1004354, 'SK', 'Vranov nad Topľou', 1, 'vranov-nad-toplou', 48.88836000, 21.68479000),
(1104578, 1004354, 'SK', 'Vrbov', 1, 'vrbov', 49.08764000, 20.42530000),
(1104583, 1004354, 'SK', 'Vyšné Ružbachy', 1, 'vysne-ruzbachy', 49.30387000, 20.56558000),
(1104582, 1004354, 'SK', 'Vysoké Tatry', 1, 'vysoke-tatry', 49.13637000, 20.24386000),
(1104598, 1004354, 'SK', 'Ždiar', 1, 'zdiar', 49.27100000, 20.26239000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004358, 'SK', 'Trenčín Region', 1, 'trencin-region');

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 
(1104379, 1004358, 'SK', 'Bánovce nad Bebravou', 1, 'banovce-nad-bebravou', 48.72130000, 18.25754000),
(1104373, 1004358, 'SK', 'Bojnice', 1, 'bojnice', 48.78511000, 18.58640000),
(1104377, 1004358, 'SK', 'Brezová pod Bradlom', 1, 'brezova-pod-bradlom', 48.66349000, 17.53905000),
(1104586, 1004358, 'SK', 'Čachtice', 1, 'cachtice', 48.71226000, 17.78704000),
(1104384, 1004358, 'SK', 'Dubnica nad Váhom', 1, 'dubnica-nad-vahom', 48.95981000, 18.16634000),
(1104394, 1004358, 'SK', 'Handlová', 1, 'handlova', 48.72760000, 18.76012000),
(1104402, 1004358, 'SK', 'Ilava', 1, 'ilava', 48.99769000, 18.23530000),
(1104419, 1004358, 'SK', 'Lehota pod Vtáčnikom', 1, 'lehota-pod-vtacnikom', 48.69138000, 18.59944000),
(1104436, 1004358, 'SK', 'Myjava', 1, 'myjava', 48.75876000, 17.56866000),
(1104437, 1004358, 'SK', 'Nemšová', 1, 'nemsova', 48.96702000, 18.11892000),
(1104441, 1004358, 'SK', 'Nová Dubnica', 1, 'nova-dubnica', 48.93479000, 18.14632000),
(1104443, 1004358, 'SK', 'Nováky', 1, 'novaky', 48.71106000, 18.53389000),
(1104444, 1004358, 'SK', 'Nové Mesto nad Váhom', 1, 'nove-mesto-nad-vahom', 48.75763000, 17.83090000),
(1104457, 1004358, 'SK', 'Okres Bánovce nad Bebravou', 1, 'okres-banovce-nad-bebravou', 48.71908000, 18.25773000),
(1104465, 1004358, 'SK', 'Okres Ilava', 1, 'okres-ilava', 48.99641000, 18.23374000),
(1104479, 1004358, 'SK', 'Okres Myjava', 1, 'okres-myjava', 48.75000000, 17.58333000),
(1104482, 1004358, 'SK', 'Okres Nové Mesto nad Váhom', 1, 'okres-nove-mesto-nad-vahom', 48.75466000, 17.83506000),
(1104484, 1004358, 'SK', 'Okres Partizánske', 1, 'okres-partizanske', 48.62613000, 18.37957000),
(1104489, 1004358, 'SK', 'Okres Považská Bystrica', 1, 'okres-povazska-bystrica', 49.11667000, 18.45000000),
(1104491, 1004358, 'SK', 'Okres Prievidza', 1, 'okres-prievidza', 48.76667000, 18.63333000),
(1104492, 1004358, 'SK', 'Okres Púchov', 1, 'okres-puchov', 49.12406000, 18.32477000),
(1104508, 1004358, 'SK', 'Okres Trenčín', 1, 'okres-trencin', 48.89520000, 18.04264000),
(1104523, 1004358, 'SK', 'Partizánske', 1, 'partizanske', 48.62861000, 18.38455000),
(1104529, 1004358, 'SK', 'Považská Bystrica', 1, 'povazska-bystrica', 49.12153000, 18.42169000),
(1104532, 1004358, 'SK', 'Prievidza', 1, 'prievidza', 48.77446000, 18.62750000),
(1104533, 1004358, 'SK', 'Púchov', 1, 'puchov', 49.12494000, 18.32597000),
(1104551, 1004358, 'SK', 'Stará Turá', 1, 'stara-tura', 48.77721000, 17.69433000),
(1104566, 1004358, 'SK', 'Trenčianske Teplice', 1, 'trencianske-teplice', 48.91063000, 18.16691000),
(1104567, 1004358, 'SK', 'Trenčín', 1, 'trencin', 48.89452000, 18.04436000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004355, 'SK', 'Trnava Region', 1, 'trnava-region');

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 
(1104387, 1004355, 'SK', 'Dunajská Streda', 1, 'dunajska-streda', 47.99268000, 17.61211000),
(1104389, 1004355, 'SK', 'Gabčíkovo', 1, 'gabcikovo', 47.89211000, 17.57884000),
(1104390, 1004355, 'SK', 'Galanta', 1, 'galanta', 48.19001000, 17.72747000),
(1104391, 1004355, 'SK', 'Gbely', 1, 'gbely', 48.71800000, 17.11628000),
(1104395, 1004355, 'SK', 'Hlohovec', 1, 'hlohovec', 48.43174000, 17.80310000),
(1104396, 1004355, 'SK', 'Holíč', 1, 'holic', 48.81105000, 17.16238000),
(1104420, 1004355, 'SK', 'Leopoldov', 1, 'leopoldov', 48.44575000, 17.76458000),
(1104460, 1004355, 'SK', 'Okres Dunajská Streda', 1, 'okres-dunajska-streda', 47.99635000, 17.60937000),
(1104461, 1004355, 'SK', 'Okres Galanta', 1, 'okres-galanta', 48.20000000, 17.71667000),
(1104463, 1004355, 'SK', 'Okres Hlohovec', 1, 'okres-hlohovec', 48.41667000, 17.75000000),
(1104486, 1004355, 'SK', 'Okres Piešťany', 1, 'okres-piestany', 48.59064000, 17.82679000),
(1104498, 1004355, 'SK', 'Okres Senica', 1, 'okres-senica', 48.68333000, 17.36667000),
(1104499, 1004355, 'SK', 'Okres Skalica', 1, 'okres-skalica', 48.75000000, 17.16667000),
(1104509, 1004355, 'SK', 'Okres Trnava', 1, 'okres-trnava', 48.36667000, 17.60000000),
(1104525, 1004355, 'SK', 'Piešťany', 1, 'piestany', 48.59479000, 17.82591000),
(1104592, 1004355, 'SK', 'Šamorín', 1, 'samorin', 48.03015000, 17.30972000),
(1104541, 1004355, 'SK', 'Senica', 1, 'senica', 48.67922000, 17.36697000),
(1104543, 1004355, 'SK', 'Skalica', 1, 'skalica', 48.84490000, 17.22635000),
(1104544, 1004355, 'SK', 'Sládkovičovo', 1, 'sladkovicovo', 48.20137000, 17.63852000),
(1104545, 1004355, 'SK', 'Smolenice', 1, 'smolenice', 48.50478000, 17.43067000),
(1104568, 1004355, 'SK', 'Trnava', 1, 'trnava', 48.37741000, 17.58723000),
(1104574, 1004355, 'SK', 'Veľký Meder', 1, 'velky-meder', 47.85798000, 17.76884000),
(1104579, 1004355, 'SK', 'Vrbové', 1, 'vrbove', 48.61973000, 17.72260000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004359, 'SK', 'Žilina Region', 1, 'zilina-region');

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 
(1104378, 1004359, 'SK', 'Bytča', 1, 'bytca', 49.22404000, 18.55878000),
(1104587, 1004359, 'SK', 'Čadca', 1, 'cadca', 49.43503000, 18.78895000),
(1104383, 1004359, 'SK', 'Dolný Kubín', 1, 'dolny-kubin', 49.20983000, 19.30341000),
(1104401, 1004359, 'SK', 'Hybe', 1, 'hybe', 49.04439000, 19.82895000),
(1104414, 1004359, 'SK', 'Krasňany', 1, 'krasnany', 49.21491000, 18.88718000),
(1104418, 1004359, 'SK', 'Kysucké Nové Mesto', 1, 'kysucke-nove-mesto', 49.30000000, 18.78333000),
(1104424, 1004359, 'SK', 'Liptovský Hrádok', 1, 'liptovsky-hradok', 49.03962000, 19.72335000),
(1104425, 1004359, 'SK', 'Liptovský Mikuláš', 1, 'liptovsky-mikulas', 49.08061000, 19.62218000),
(1104427, 1004359, 'SK', 'Lúčky', 1, 'lucky', 49.12944000, 19.40228000),
(1104430, 1004359, 'SK', 'Martin', 1, 'martin', 49.06651000, 18.92399000),
(1104446, 1004359, 'SK', 'Námestovo', 1, 'namestovo', 49.40790000, 19.48032000),
(1104439, 1004359, 'SK', 'Nižná', 1, 'nizna', 49.31046000, 19.52428000),
(1104456, 1004359, 'SK', 'Okres Bytča', 1, 'okres-bytca', 49.22267000, 18.55844000),
(1104516, 1004359, 'SK', 'Okres Čadca', 1, 'okres-cadca', 49.43333000, 18.78333000),
(1104459, 1004359, 'SK', 'Okres Dolný Kubín', 1, 'okres-dolny-kubin', 49.20000000, 19.30000000),
(1104470, 1004359, 'SK', 'Okres Kysucké Nové Mesto', 1, 'okres-kysucke-nove-mesto', 49.30206000, 18.78603000),
(1104473, 1004359, 'SK', 'Okres Liptovský Mikuláš', 1, 'okres-liptovsky-mikulas', 49.08333000, 19.61667000),
(1104476, 1004359, 'SK', 'Okres Martin', 1, 'okres-martin', 49.06667000, 18.93333000),
(1104480, 1004359, 'SK', 'Okres Namestovo', 1, 'okres-namestovo', 49.40651000, 19.47670000),
(1104495, 1004359, 'SK', 'Okres Ružomberok', 1, 'okres-ruzomberok', 49.07494000, 19.30083000),
(1104510, 1004359, 'SK', 'Okres Turčianske Teplice', 1, 'okres-turcianske-teplice', 48.86283000, 18.85759000),
(1104511, 1004359, 'SK', 'Okres Tvrdošín', 1, 'okres-tvrdosin', 49.33421000, 19.55461000),
(1104520, 1004359, 'SK', 'Okres Žilina', 1, 'okres-zilina', 49.22303000, 18.74044000),
(1104521, 1004359, 'SK', 'Oravská Lesná', 1, 'oravska-lesna', 49.36672000, 19.18093000),
(1104522, 1004359, 'SK', 'Oravský Podzámok', 1, 'oravsky-podzamok', 49.25939000, 19.35690000),
(1104531, 1004359, 'SK', 'Pribylina', 1, 'pribylina', 49.09950000, 19.79427000),
(1104534, 1004359, 'SK', 'Rajec', 1, 'rajec', 49.08899000, 18.64007000),
(1104538, 1004359, 'SK', 'Ružomberok', 1, 'ruzomberok', 49.07480000, 19.30751000),
(1104561, 1004359, 'SK', 'Terchová', 1, 'terchova', 49.25895000, 19.02935000),
(1104569, 1004359, 'SK', 'Trstená', 1, 'trstena', 49.36101000, 19.61249000),
(1104571, 1004359, 'SK', 'Turčianske Teplice', 1, 'turcianske-teplice', 48.86225000, 18.86048000),
(1104570, 1004359, 'SK', 'Turzovka', 1, 'turzovka', 49.40429000, 18.62258000),
(1104572, 1004359, 'SK', 'Tvrdošín', 1, 'tvrdosin', 49.33700000, 19.55600000),
(1104581, 1004359, 'SK', 'Vrútky', 1, 'vrutky', 49.11328000, 18.91714000),
(1104602, 1004359, 'SK', 'Žilina', 1, 'zilina', 49.22315000, 18.73941000);

