REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('BM', 'Bermuda', 'Bermuda', 'bermuda', '+1-441', 'BMD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6572972, 'BM', 'Warwick', 1, 'warwick'),
(6573026, 'BM', 'Southampton', 1, 'southampton'),
(6573031, 'BM', 'Smithʼs', 1, 'smith-s-parish'),
(6573050, 'BM', 'Sandys', 1, 'sandys'),
(6573057, 'BM', 'Saint Georgeʼs', 1, 'saint-george-s-parish'),
(6573062, 'BM', 'Saint George', 1, 'saint-george'),
(6573095, 'BM', 'Pembroke', 1, 'pembroke'),
(6573103, 'BM', 'Paget', 1, 'paget'),
(6573195, 'BM', 'Hamilton', 1, 'hamilton'),
(6573198, 'BM', 'Hamilton city', 1, 'hamilton-city'),
(6573251, 'BM', 'Devonshire', 1, 'devonshire');

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 
(6572974, 6572972, 'BM', 'Warwick Camp', 1, 'warwick-camp', 32.25722, -64.81611),
(6572988, 6573057, 'BM', 'Tucker’s Town', 1, 'tucker-s-town', 32.33278, -64.68806),
(6573001, 6573031, 'BM', 'Flatt’s Village', 1, 'flatt-s-village', 32.32094, -64.74016),
(6573008, 6573195, 'BM', 'Sunnyside', 1, 'sunnyside', 32.32639, -64.74111),
(6573029, 6573050, 'BM', 'Somerset', 1, 'somerset', 32.29833, -64.86833),
(6573046, 6573050, 'BM', 'Scotts Hill', 1, 'scotts-hill', 32.29722, -64.86556),
(6573061, 6573062, 'BM', 'Saint George', 1, 'saint-george', 32.38167, -64.67806),
(6573110, 6573251, 'BM', 'North Shore Village', 1, 'north-shore-village', 32.30639, -64.77361),
(6573121, 6573103, 'BM', 'Mount Pleasant', 1, 'mount-pleasant', 32.27417, -64.78361),
(6573131, 6573057, 'BM', 'Melrose', 1, 'melrose', 32.36845, -64.67739),
(6573181, 6573050, 'BM', 'Hog Bay', 1, 'hog-bay', 32.27111, -64.88),
(6573183, 6573031, 'BM', 'Hinson Hall', 1, 'hinson-hall', 32.31361, -64.74361),
(6573185, 6572972, 'BM', 'Hill View', 1, 'hill-view', 32.26944, -64.80889),
(6573197, 6573198, 'BM', 'Hamilton', 1, 'hamilton', 32.2949, -64.78303),
(6573289, 6573103, 'BM', 'Chelston', 1, 'chelston', 32.28361, -64.77056),
(6573304, 6573057, 'BM', 'Cashew City', 1, 'cashew-city', 32.37028, -64.65444),
(6573307, 6573103, 'BM', 'Camden', 1, 'camden', 32.29417, -64.76056),
(6573339, 6573251, 'BM', 'Bethaven', 1, 'bethaven', 32.28333, -64.75),
(6740524, 6573031, 'BM', 'Harrington Hundreds', 1, 'harrington-hundreds', 32.31861, -64.72889),
(14054831, 6573026, 'BM', 'Cross Bay', 1, 'cross-bay', 32.25346, -64.83882),
(14054833, 6573095, 'BM', 'Stovel Bay', 1, 'stovel-bay', 32.30587, -64.81429);