REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('SJ', 'Svalbard and Jan Mayen', 'Svalbard og Jan Mayen', 'svalbard-and-jan-mayen', '47', 'NOK');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6041964, 'SJ', 'Jan Mayen', 1, 'jan-mayen'),
(10521757, 'SJ', 'Svalbard', 1, 'svalbard');

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 
(5728377, 10521757, 'SJ', 'Sveagruva', 1, 'sveagruva', 77.90029, 16.72006),
(5729216, 10521757, 'SJ', 'Pyramiden', 1, 'pyramiden', 78.65, 16.41667),
(5729456, 10521757, 'SJ', 'Nybyen', 1, 'nybyen', 78.20185, 15.59119),
(5729907, 10521757, 'SJ', 'Longyearbyen', 1, 'longyearbyen', 78.22334, 15.64689),
(5730733, 10521757, 'SJ', 'Haugen', 1, 'haugen', 78.21667, 15.63333),
(5731990, 10521757, 'SJ', 'Barentsburg', 1, 'barentsburg', 78.06435, 14.21169),
(10535941, 6041964, 'SJ', 'Olonkinbyen', 1, 'olonkinbyen', 70.9221, -8.7187),
(10535963, 10521757, 'SJ', 'Ny-Ålesund', 1, 'ny-alesund', 78.92373, 11.92497);