REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('TF', 'French Southern Territories', 'Territoire des Terres australes et antarctiques fr', 'french-southern-territories', '', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(3936339, 'TF', 'Crozet', 1, 'crozet'),
(4546558, 'TF', 'Kerguelen', 1, 'kerguelen'),
(4547221, 'TF', 'Saint-Paul-et-Amsterdam', 1, 'saint-paul-et-amsterdam'),
(9690916, 'TF', 'Îles Éparses', 1, 'iles-eparses'),
(9690917, 'TF', 'Terre-Adélie', 1, 'terre-adelie');

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 
(4546102, 4546558, 'TF', 'Port-aux-Français', 1, 'port-aux-francais', -49.34916, 70.21937),
(14594686, 4547221, 'TF', 'Martin-de-Viviès', 1, 'martin-de-vivies', -37.79703, 77.5648);