REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('DM', 'Dominica', 'Dominica', 'dominica', '+1-767', 'XCD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6575618, 'DM', 'Saint Peter', 1, 'saint-peter'),
(6575619, 'DM', 'Saint Paul', 1, 'saint-paul'),
(6575620, 'DM', 'Saint Patrick', 1, 'saint-patrick'),
(6575621, 'DM', 'Saint Mark', 1, 'saint-mark'),
(6575622, 'DM', 'Saint Luke', 1, 'saint-luke'),
(6575625, 'DM', 'Saint Joseph', 1, 'saint-joseph'),
(6575626, 'DM', 'Saint John', 1, 'saint-john'),
(6575628, 'DM', 'Saint George', 1, 'saint-george'),
(6575630, 'DM', 'Saint David', 1, 'saint-david'),
(6575632, 'DM', 'Saint Andrew', 1, 'saint-andrew');

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 
(6575565, 6575632, 'DM', 'Woodford Hill', 1, 'woodford-hill', 15.58093, -61.33149),
(6575568, 6575632, 'DM', 'Wesley', 1, 'wesley', 15.56667, -61.31667),
(6575570, 6575628, 'DM', 'Wall House', 1, 'wall-house', 15.27822, -61.37139),
(6575573, 6575632, 'DM', 'Vieille Case', 1, 'vieille-case', 15.61418, -61.40823),
(6575578, 6575628, 'DM', 'Trafalgar', 1, 'trafalgar', 15.32728, -61.3456),
(6575583, 6575626, 'DM', 'Toucari', 1, 'toucari', 15.61124, -61.46382),
(6575585, 6575632, 'DM', 'Tobino', 1, 'tobino', 15.61435, -61.40592),
(6575587, 6575632, 'DM', 'Thibaud', 1, 'thibaud', 15.59969, -61.39729),
(6575588, 6575630, 'DM', 'The Cross', 1, 'the-cross', 15.3636, -61.27371),
(6575589, 6575620, 'DM', 'Tête Morne', 1, 'tete-morne', 15.23545, -61.33396),
(6575593, 6575619, 'DM', 'Tarou', 1, 'tarou', 15.38862, -61.41484),
(6575594, 6575626, 'DM', 'Tanetane', 1, 'tanetane', 15.60188, -61.46111),
(6575597, 6575619, 'DM', 'Sylvania', 1, 'sylvania', 15.3593, -61.35555),
(6575600, 6575620, 'DM', 'Stowe', 1, 'stowe', 15.24568, -61.29336),
(6575602, 6575621, 'DM', 'Soufrière', 1, 'soufriere', 15.23374, -61.35881),
(6575604, 6575630, 'DM', 'Sineku', 1, 'sineku', 15.46632, -61.24825),
(6575605, 6575622, 'DM', 'Sibouli', 1, 'sibouli', 15.25795, -61.37702),
(6575606, 6575621, 'DM', 'Scotts Head Village', 1, 'scotts-head-village', 15.21222, -61.36482),
(6575612, 6575625, 'DM', 'Salisbury', 1, 'salisbury', 15.43689, -61.43637),
(6575614, 6575630, 'DM', 'Salybia', 1, 'salybia', 15.49382, -61.25753),
(6575617, 6575630, 'DM', 'Saint Sauveur', 1, 'saint-sauveur', 15.40258, -61.2547),
(6575624, 6575625, 'DM', 'Saint Joseph', 1, 'saint-joseph', 15.4, -61.43333),
(6575631, 6575630, 'DM', 'Saint Cyr', 1, 'saint-cyr', 15.49025, -61.25353),
(6575635, 6575628, 'DM', 'Roseau', 1, 'roseau', 15.30174, -61.38808),
(6575639, 6575630, 'DM', 'Rosalie', 1, 'rosalie', 15.36667, -61.26667),
(6575641, 6575619, 'DM', 'Roger', 1, 'roger', 15.33904, -61.38812),
(6575642, 6575630, 'DM', 'Rivière Ciriques', 1, 'riviere-ciriques', 15.3599, -61.25835),
(6575643, 6575625, 'DM', 'Riversdale', 1, 'riversdale', 15.41667, -61.36667),
(6575654, 6575626, 'DM', 'Portsmouth', 1, 'portsmouth', 15.58333, -61.46667),
(6575656, 6575619, 'DM', 'Pont Cassé', 1, 'pont-casse', 15.36667, -61.35),
(6575660, 6575622, 'DM', 'Pointe Michel', 1, 'pointe-michel', 15.25976, -61.37452),
(6575663, 6575620, 'DM', 'Pichelin', 1, 'pichelin', 15.26423, -61.32583),
(6575667, 6575630, 'DM', 'Petite Soufrière', 1, 'petite-soufriere', 15.39025, -61.25617),
(6575670, 6575620, 'DM', 'Petite Savane', 1, 'petite-savane', 15.25534, -61.26792),
(6575674, 6575632, 'DM', 'Pineville', 1, 'pineville', 15.6311, -61.42456),
(6575679, 6575632, 'DM', 'Paix Bouche', 1, 'paix-bouche', 15.59248, -61.41133),
(6575695, 6575630, 'DM', 'Morpo', 1, 'morpo', 15.42663, -61.25556),
(6575697, 6575626, 'DM', 'Morne Soleil', 1, 'morne-soleil', 15.61374, -61.46537),
(6575698, 6575625, 'DM', 'Morne Raquette', 1, 'morne-raquette', 15.45637, -61.44732),
(6575699, 6575628, 'DM', 'Morne Prosper', 1, 'morne-prosper', 15.29698, -61.36002),
(6575700, 6575630, 'DM', 'Morne Jaune', 1, 'morne-jaune', 15.35285, -61.26401),
(6575702, 6575630, 'DM', 'Morne Aux Frégates', 1, 'morne-aux-fregates', 15.35741, -61.26206),
(6575704, 6575630, 'DM', 'Monkey Hill', 1, 'monkey-hill', 15.49959, -61.26481),
(6575709, 6575625, 'DM', 'Méro', 1, 'mero', 15.41866, -61.42894),
(6575711, 6575632, 'DM', 'Melville Hall', 1, 'melville-hall', 15.54526, -61.29222),
(6575717, 6575619, 'DM', 'Massacre', 1, 'massacre', 15.34685, -61.3916),
(6575721, 6575632, 'DM', 'Marigot', 1, 'marigot', 15.53743, -61.282),
(6575733, 6575619, 'DM', 'Mahaut', 1, 'mahaut', 15.36357, -61.39701),
(6575734, 6575630, 'DM', 'Madjini', 1, 'madjini', 15.46766, -61.24937),
(6575737, 6575628, 'DM', 'Loubiere', 1, 'loubiere', 15.27893, -61.3722),
(6575746, 6575625, 'DM', 'Layou', 1, 'layou', 15.397, -61.42546),
(6575747, 6575628, 'DM', 'Laudat', 1, 'laudat', 15.3372, -61.33211),
(6575749, 6575632, 'DM', 'La Source', 1, 'la-source', 15.58788, -61.40574),
(6575752, 6575632, 'DM', 'Larieu', 1, 'larieu', 15.58617, -61.3287),
(6575755, 6575620, 'DM', 'La Plaine', 1, 'la-plaine', 15.32768, -61.24753),
(6575758, 6575626, 'DM', 'Là Haut', 1, 'la-haut', 15.62603, -61.41628),
(6575761, 6575626, 'DM', 'Lagon', 1, 'lagon', 15.57998, -61.45782),
(6575776, 6575632, 'DM', 'Hampstead', 1, 'hampstead', 15.59457, -61.3663),
(6575777, 6575626, 'DM', 'Guillet', 1, 'guillet', 15.6051, -61.46106),
(6575784, 6575630, 'DM', 'Grand Fond', 1, 'grand-fond', 15.35626, -61.28187),
(6575793, 6575630, 'DM', 'Good Hope', 1, 'good-hope', 15.41168, -61.25406),
(6575794, 6575632, 'DM', 'Gommier', 1, 'gommier', 15.6097, -61.40347),
(6575797, 6575626, 'DM', 'Glanvillia', 1, 'glanvillia', 15.56707, -61.45612),
(6575798, 6575628, 'DM', 'Giraudet', 1, 'giraudet', 15.2918, -61.34869),
(6575803, 6575620, 'DM', 'Geneva', 1, 'geneva', 15.24539, -61.31658),
(6575804, 6575630, 'DM', 'Gaulette', 1, 'gaulette', 15.48255, -61.25279),
(6575805, 6575621, 'DM', 'Galion', 1, 'galion', 15.22258, -61.35736),
(6575814, 6575620, 'DM', 'Fond Saint Jean', 1, 'fond-saint-jean', 15.24485, -61.28211),
(6575816, 6575628, 'DM', 'Fond Cani', 1, 'fond-cani', 15.31875, -61.35401),
(6575823, 6575620, 'DM', 'Dubuc', 1, 'dubuc', 15.24671, -61.30379),
(6575825, 6575618, 'DM', 'Dublanc', 1, 'dublanc', 15.51361, -61.46679),
(6575829, 6575632, 'DM', 'Dos D’Âne', 1, 'dos-d-ane', 15.58516, -61.41271),
(6575839, 6575632, 'DM', 'Demitrie', 1, 'demitrie', 15.62968, -61.41829),
(6575841, 6575620, 'DM', 'Délices', 1, 'delices', 15.28735, -61.26617),
(6575847, 6575630, 'DM', 'Crayfish River', 1, 'crayfish-river', 15.49702, -61.25755),
(6575852, 6575625, 'DM', 'Coulibistrie', 1, 'coulibistrie', 15.46066, -61.45089),
(6575854, 6575626, 'DM', 'Cottage', 1, 'cottage', 15.61579, -61.46369),
(6575857, 6575618, 'DM', 'Colihaut', 1, 'colihaut', 15.48478, -61.46215),
(6575860, 6575626, 'DM', 'Cocoyer', 1, 'cocoyer', 15.61677, -61.46035),
(6575862, 6575619, 'DM', 'Cochrane', 1, 'cochrane', 15.33775, -61.3619),
(6575863, 6575626, 'DM', 'Clifton', 1, 'clifton', 15.6238, -61.46284),
(6575867, 6575628, 'DM', 'Newtown', 1, 'newtown', 15.29437, -61.38173),
(6575870, 6575630, 'DM', 'Castle Bruce', 1, 'castle-bruce', 15.44397, -61.25723),
(6575875, 6575626, 'DM', 'Capucin', 1, 'capucin', 15.63071, -61.46124),
(6575882, 6575632, 'DM', 'Calibishie', 1, 'calibishie', 15.59297, -61.34901),
(6575889, 6575626, 'DM', 'Borne', 1, 'borne', 15.57946, -61.42076),
(6575892, 6575620, 'DM', 'Boetica', 1, 'boetica', 15.30911, -61.25053),
(6575897, 6575618, 'DM', 'Bioche', 1, 'bioche', 15.50895, -61.46683),
(6575899, 6575620, 'DM', 'Berekua', 1, 'berekua', 15.23333, -61.31667),
(6575900, 6575632, 'DM', 'Bense', 1, 'bense', 15.58771, -61.37558),
(6575901, 6575620, 'DM', 'Belvidere', 1, 'belvidere', 15.28333, -61.25),
(6575902, 6575632, 'DM', 'Belmanier', 1, 'belmanier', 15.58867, -61.40725),
(6575903, 6575625, 'DM', 'Bells', 1, 'bells', 15.42214, -61.33933),
(6575907, 6575628, 'DM', 'Bellevue Chopin', 1, 'bellevue-chopin', 15.26448, -61.34504),
(6575915, 6575630, 'DM', 'Bataka', 1, 'bataka', 15.50646, -61.2663),
(6575916, 6575625, 'DM', 'Bassinville', 1, 'bassinville', 15.43333, -61.36667),
(6575923, 6575632, 'DM', 'Au Parc', 1, 'au-parc', 15.61143, -61.40646),
(6575928, 6575632, 'DM', 'Anse de Mai', 1, 'anse-de-mai', 15.59311, -61.38278),
(11504974, 6575619, 'DM', 'Canefield', 1, 'canefield', 15.33137, -61.38916),
(13303656, 6575626, 'DM', 'Capuchin', 1, 'capuchin', 15.6315, -61.46033),
(13793753, 6575628, 'DM', 'Castle Comfort', 1, 'castle-comfort', 15.28439, -61.37049),
(13793754, 6575628, 'DM', 'Wotten Waven', 1, 'wotten-waven', 15.31813, -61.33839),
(14002642, 6575628, 'DM', 'Upper King\'s Hill', 1, 'upper-king-s-hill', 15.299, -61.37521),
(14525034, 6575619, 'DM', 'Belfast', 1, 'belfast', 15.3668, -61.39615),
(14897803, 6575628, 'DM', 'Eggleston', 1, 'eggleston', 15.29785, -61.35688),
(14897807, 6575625, 'DM', 'Grand Savane', 1, 'grand-savane', 15.44491, -61.43518),
(14897808, 6575619, 'DM', 'Jimmit', 1, 'jimmit', 15.37145, -61.40314),
(14897809, 6575619, 'DM', 'Campbell', 1, 'campbell', 15.37521, -61.37282),
(14897827, 6575619, 'DM', 'Warner', 1, 'warner', 15.39298, -61.39375),
(14897829, 6575626, 'DM', 'Picard', 1, 'picard', 15.55281, -61.45939),
(15151279, 6575619, 'DM', 'Bon Repos', 1, 'bon-repos', 15.37359, -61.38572),
(15151286, 6575628, 'DM', 'Copt Hall Estate', 1, 'copt-hall-estate', 15.31299, -61.35756),
(15151287, 6575620, 'DM', 'Laronde', 1, 'laronde', 15.31912, -61.24782),
(15151297, 6575619, 'DM', 'River Estate', 1, 'river-estate', 15.32849, -61.38732),
(15160987, 6575628, 'DM', 'Citronnière', 1, 'citronniere', 15.28919, -61.37698);