REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'united-states-minor-outlying-islands', '1', 'USD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(7041685, 'UM', 'Wake Island', 1, 'wake-island'),
(7743755, 'UM', 'Navassa Island', 1, 'navassa-island'),
(8854907, 'UM', 'Baker Island', 1, 'baker-island'),
(8854922, 'UM', 'Howland Island', 1, 'howland-island'),
(8854926, 'UM', 'Jarvis Island', 1, 'jarvis-island'),
(8854929, 'UM', 'Johnston Atoll', 1, 'johnston-atoll'),
(8854936, 'UM', 'Kingman Reef', 1, 'kingman-reef'),
(8854943, 'UM', 'Midway Islands', 1, 'midway-islands'),
(8854952, 'UM', 'Palmyra Atoll', 1, 'palmyra-atoll');

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 
(8854924, 8854922, 'UM', 'Itascatown pre-WW2', 1, 'itascatown-pre-ww2', 0.80776, -176.6185),
(14695312, 8854929, 'UM', 'Johnston', 1, 'johnston', 16.7314, -169.52775),
(14695313, 8854943, 'UM', 'Midway', 1, 'midway', 28.21222, -177.37515),
(14695315, 7041685, 'UM', 'Wake', 1, 'wake', 19.30434, 166.63612),
(14695316, 8854907, 'UM', 'Baker', 1, 'baker', 0.19471, -176.47644),
(14695317, 8854926, 'UM', 'Jarvis', 1, 'jarvis', -0.3719, -159.99321),
(14695319, 8854952, 'UM', 'Palmyra', 1, 'palmyra', 5.88977, -162.07563),
(14695320, 8854922, 'UM', 'Kamakaiwi Field', 1, 'kamakaiwi-field', 0.80343, -176.61698),
(15206892, 7743755, 'UM', 'Navassa II', 1, 'navassa-ii', 18.39704, -75.00839),
(15206893, 8854936, 'UM', 'Kingman', 1, 'kingman', 6.38225, -162.36726);