REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('SC', 'Seychelles', 'Seychelles', 'seychelles', '248', 'SCR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(3241151, 'SC', 'Takamaka', 1, 'takamaka'),
(3241181, 'SC', 'Saint Louis', 1, 'saint-louis'),
(3241215, 'SC', 'Port Glaud', 1, 'port-glaud'),
(3241221, 'SC', 'Pointe Larue', 1, 'pointe-larue'),
(3241224, 'SC', 'Plaisance', 1, 'plaisance'),
(3241251, 'SC', 'Mont Fleuri', 1, 'mont-fleuri'),
(3241252, 'SC', 'Mont Buxton', 1, 'mont-buxton'),
(3241302, 'SC', 'English River', 1, 'english-river'),
(3241311, 'SC', 'La Digue', 1, 'la-digue'),
(3241330, 'SC', 'Grand Anse Mahe', 1, 'grand-anse-mahe'),
(3241331, 'SC', 'Grand Anse Praslin', 1, 'grand-anse-praslin'),
(3241336, 'SC', 'Glacis', 1, 'glacis'),
(3241396, 'SC', 'Cascade', 1, 'cascade'),
(3241424, 'SC', 'Bel Ombre', 1, 'bel-ombre'),
(3241426, 'SC', 'Bel Air', 1, 'bel-air'),
(3241428, 'SC', 'Beau Vallon', 1, 'beau-vallon'),
(3241438, 'SC', 'Baie Sainte Anne', 1, 'baie-sainte-anne'),
(3241439, 'SC', 'Baie Lazare', 1, 'baie-lazare'),
(3241444, 'SC', 'Anse Royale', 1, 'anse-royale'),
(3241447, 'SC', 'Anse Etoile', 1, 'anse-etoile'),
(3241449, 'SC', 'Anse Boileau', 1, 'anse-boileau'),
(3241450, 'SC', 'Anse-aux-Pins', 1, 'anse-aux-pins'),
(3448408, 'SC', 'Les Mamelles', 1, 'les-mamelles'),
(3448409, 'SC', 'Roche Caiman', 1, 'roche-caiman'),
(3448410, 'SC', 'Au Cap', 1, 'au-cap'),
(14876017, 'SC', 'Outer Islands', 1, 'outer-islands'),
(15200079, 'SC', 'Ile Perseverance I', 1, 'ile-perseverance-i'),
(15200080, 'SC', 'Ile Perseverance II', 1, 'ile-perseverance-ii');

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 
(3241131, 3241302, 'SC', 'Victoria', 1, 'victoria', -4.62001, 55.45501),
(3241150, 3241151, 'SC', 'Takamaka', 1, 'takamaka', -4.76667, 55.5),
(3241214, 3241215, 'SC', 'Port Glaud', 1, 'port-glaud', -4.66667, 55.41667),
(3241257, 3241330, 'SC', 'Misere', 1, 'misere', -4.66667, 55.46667),
(3241276, 3241336, 'SC', 'Machabee', 1, 'machabee', -4.56523, 55.4457),
(3241287, 3241449, 'SC', 'L’Espérance', 1, 'l-esperance', -4.71667, 55.48333),
(3241303, 3241311, 'SC', 'La Réunion', 1, 'la-reunion', -4.35544, 55.83527),
(3241357, 3241447, 'SC', 'De Quincey Village', 1, 'de-quincey-village', -4.6026, 55.45692),
(3241395, 3241396, 'SC', 'Cascade', 1, 'cascade', -4.66667, 55.5),
(3241423, 3241424, 'SC', 'Bel Ombre', 1, 'bel-ombre', -4.61667, 55.41667),
(3241427, 3241428, 'SC', 'Beau Vallon', 1, 'beau-vallon', -4.62091, 55.43015),
(3241442, 3241438, 'SC', 'Anse Volbert Village', 1, 'anse-volbert-village', -4.31667, 55.73333),
(3241443, 3241444, 'SC', 'Anse Royale', 1, 'anse-royale', -4.73333, 55.51667),
(3241448, 3241449, 'SC', 'Anse Boileau', 1, 'anse-boileau', -4.71667, 55.48333),
(9691843, 3241438, 'SC', 'Cote d\'Or', 1, 'cote-d-or', -4.31997, 55.75338),
(9691844, 3241331, 'SC', 'Anse Kerlan', 1, 'anse-kerlan', -4.30524, 55.6845),
(11629285, 3241331, 'SC', 'Grand Anse', 1, 'grand-anse', -4.33109, 55.72206),
(11693252, 3241251, 'SC', 'Eden Island', 1, 'eden-island', -4.63875, 55.47679),
(13629843, 14876017, 'SC', 'Silhouette Island', 1, 'silhouette-island', -4.48599, 55.25262),
(13792304, 3241450, 'SC', 'Anse aux Pins', 1, 'anse-aux-pins', -4.7034, 55.52055),
(13793687, 3241221, 'SC', 'Anse des Genets', 1, 'anse-des-genets', -4.67323, 55.5131),
(13793745, 3241439, 'SC', 'Baie Lazare', 1, 'baie-lazare', -4.74971, 55.4754),
(13860737, 3241151, 'SC', 'Quatre Bornes', 1, 'quatre-bornes', -4.77873, 55.51012),
(14003008, 3448410, 'SC', 'Pointe Au Sel', 1, 'pointe-au-sel', -4.72834, 55.52416),
(14184853, 3241251, 'SC', 'Ile au Cerf', 1, 'ile-au-cerf', -4.63108, 55.49278),
(14395546, 3241336, 'SC', 'Vista do Mar', 1, 'vista-do-mar', -4.57578, 55.4368),
(14694884, 3241447, 'SC', 'La Gouge', 1, 'la-gouge', -4.59093, 55.4462),
(14694885, 3241447, 'SC', 'Maldive Village', 1, 'maldive-village', -4.59093, 55.45225),
(14694887, 3241438, 'SC', 'Anse Lazio', 1, 'anse-lazio', -4.29583, 55.70249),
(14694888, 3241438, 'SC', 'Cap Samy', 1, 'cap-samy', -4.33036, 55.76008),
(14694889, 3241426, 'SC', 'Bel Air', 1, 'bel-air', -4.62947, 55.44547),
(14694891, 3241252, 'SC', 'Mont Buxton', 1, 'mont-buxton', -4.61638, 55.44821),
(14694892, 3448408, 'SC', 'Saint Anne', 1, 'saint-anne', -4.61362, 55.49666),
(14694893, 3241251, 'SC', 'South Point', 1, 'south-point', -4.63937, 55.50344),
(14694894, 3241224, 'SC', 'Fairview', 1, 'fairview', -4.65877, 55.46431),
(14694895, 3241181, 'SC', 'Saint Louis', 1, 'saint-louis', -4.62457, 55.44441),
(14694896, 3448409, 'SC', 'Roche Caïman', 1, 'roche-caiman', -4.6401, 55.46879),
(14822653, 14876017, 'SC', 'North Island', 1, 'north-island', -4.39342, 55.24407);