REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('PM', 'Saint Pierre and Miquelon', 'Saint-Pierre-et-Miquelon', 'saint-pierre-and-miquelon', '508', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6424935, 'PM', 'Saint-Pierre', 1, 'saint-pierre'),
(6424938, 'PM', 'Miquelon-Langlade', 1, 'miquelon-langlade');

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 
(6424934, 6424935, 'PM', 'Saint-Pierre', 1, 'saint-pierre', 46.77914, -56.1773),
(6424941, 6424938, 'PM', 'Miquelon', 1, 'miquelon', 47.0975, -56.38139),
(6425682, 6424938, 'PM', 'Petit Barachois', 1, 'petit-barachois', 46.86268, -56.36123),
(11609303, 6424938, 'PM', 'Village de l\'Anse du Gouvernement', 1, 'village-de-l-anse-du-gouvernement', 46.89748, -56.30125),
(11614838, 6424938, 'PM', 'Le Ruisseau Debons', 1, 'le-ruisseau-debons', 46.87365, -56.34258);