REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('SH', 'Saint Helena', 'Saint Helena', 'saint-helena', '290', 'SHP');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5411430, 'SH', 'Ascension', 1, 'ascension'),
(6370684, 'SH', 'Tristan da Cunha', 1, 'tristan-da-cunha'),
(9930057, 'SH', 'Saint Helena', 1, 'saint-helena');

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 
(5411327, 5411430, 'SH', 'Thornton', 1, 'thornton', -7.93333, -14.41667),
(5411397, 5411430, 'SH', 'Georgetown', 1, 'georgetown', -7.92861, -14.41194),
(5572137, 5411430, 'SH', 'Two Boats Village', 1, 'two-boats-village', -7.94466, -14.37081),
(6370695, 9930057, 'SH', 'Taglate', 1, 'taglate', -15.96667, -5.68333),
(6370726, 6370684, 'SH', 'Edinburgh of the Seven Seas', 1, 'edinburgh-of-the-seven-seas', -37.06757, -12.31155),
(6370831, 9930057, 'SH', 'New Ground', 1, 'new-ground', -15.94395, -5.7249),
(6370867, 9930057, 'SH', 'Longwood', 1, 'longwood', -15.94916, -5.68571),
(6370880, 9930057, 'SH', 'Levelwood', 1, 'levelwood', -15.96667, -5.68333),
(6370903, 9930057, 'SH', 'Jamestown', 1, 'jamestown', -15.93872, -5.71675),
(6370907, 9930057, 'SH', 'Hutts Gate', 1, 'hutts-gate', -15.96667, -5.7),
(6370936, 9930057, 'SH', 'Half Tree Hollow', 1, 'half-tree-hollow', -15.93723, -5.71996),
(6371004, 9930057, 'SH', 'Deadwood', 1, 'deadwood', -15.93333, -5.68333),
(10730332, 9930057, 'SH', 'Barren Ground', 1, 'barren-ground', -15.98028, -5.75);