REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('MP', 'Northern Mariana Islands', 'Northern Mariana Islands', 'northern-mariana-islands', '+1-670', 'USD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(7041530, 'MP', 'Rota', 1, 'rota'),
(7041552, 'MP', 'Saipan', 1, 'saipan'),
(7041650, 'MP', 'Tinian', 1, 'tinian'),
(10733156, 'MP', 'Northern Islands', 1, 'northern-islands');

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 
(7041178, 7041552, 'MP', 'Chalan Kanoa Village', 1, 'chalan-kanoa-village', 15.14636, 145.70304),
(7041348, 7041552, 'MP', 'Koblerville Village', 1, 'koblerville-village', 15.12382, 145.70228),
(7041462, 7041552, 'MP', 'Navy Hill Village', 1, 'navy-hill-village', 15.21109, 145.73394),
(7041534, 7041530, 'MP', 'Dugi Village', 1, 'dugi-village', 14.18851, 145.27874),
(7041560, 7041552, 'MP', 'San Roque Village', 1, 'san-roque-village', 15.24889, 145.77553),
(7041561, 7041552, 'MP', 'San Vicente Village', 1, 'san-vicente-village', 15.15165, 145.7376),
(7041575, 10733156, 'MP', 'Pagan Village', 1, 'pagan-village', 18.12539, 145.75938),
(7041576, 7041530, 'MP', 'Sinapalo Village', 1, 'sinapalo-village', 14.16608, 145.2317),
(7041579, 7041530, 'MP', 'Songsong', 1, 'songsong', 14.13972, 145.14111),
(7041619, 7041552, 'MP', 'Tanapag Village', 1, 'tanapag-village', 15.24205, 145.75626),
(10267926, 7041552, 'MP', 'Dandan Village', 1, 'dandan-village', 15.13511, 145.73404),
(10267930, 7041552, 'MP', 'Garapan Village', 1, 'garapan-village', 15.20545, 145.72025),
(10267932, 7041552, 'MP', 'Gualo Rai Village', 1, 'gualo-rai-village', 15.19415, 145.71682),
(10267947, 7041552, 'MP', 'San Antonio Village', 1, 'san-antonio-village', 15.13299, 145.69716),
(10267948, 7041552, 'MP', 'San Jose Village', 1, 'san-jose-village', 15.16853, 145.71016),
(10267949, 7041650, 'MP', 'San Jose Village', 1, 'san-jose-village', 14.96823, 145.61998),
(10267956, 7041552, 'MP', 'Susupe Village', 1, 'susupe-village', 15.15634, 145.70258),
(10778779, 10733156, 'MP', 'Agrihan Village', 1, 'agrihan-village', 18.73638, 145.65295),
(10778853, 10733156, 'MP', 'Alamagan Village', 1, 'alamagan-village', 17.61252, 145.82147),
(10798575, 7041650, 'MP', 'Carolinas Heights', 1, 'carolinas-heights', 14.96655, 145.64914),
(10828758, 7041552, 'MP', 'Saipan', 1, 'saipan', 15.21233, 145.7545),
(10828768, 7041552, 'MP', 'Capitol Hill Village', 1, 'capitol-hill-village', 15.20825, 145.75313),
(10838654, 7041552, 'MP', 'Kagman Village', 1, 'kagman-village', 15.17354, 145.78057),
(10838658, 7041552, 'MP', 'Puerto Rico Village', 1, 'puerto-rico-village', 15.2197, 145.73296),
(10838874, 7041552, 'MP', 'Achugao Hamlet', 1, 'achugao-hamlet', 15.23165, 145.76707),
(10838875, 7041552, 'MP', 'As Lito Hamlet', 1, 'as-lito-hamlet', 15.12963, 145.72377),
(10838876, 7041552, 'MP', 'As Perdido Hamlet', 1, 'as-perdido-hamlet', 15.1339, 145.7092),
(10838877, 7041552, 'MP', 'Chalan Kiya Hamlet', 1, 'chalan-kiya-hamlet', 15.16364, 145.71909),
(10838878, 7041552, 'MP', 'Fina Sisu Hamlet', 1, 'fina-sisu-hamlet', 15.14558, 145.71927),
(10838879, 7041552, 'MP', 'Matansa Hamlet', 1, 'matansa-hamlet', 15.2509, 145.78596),
(10838880, 7041552, 'MP', 'Papago Hamlet', 1, 'papago-hamlet', 15.17358, 145.74703);