REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('PW', 'Palau', 'Palau', 'palau', '680', 'USD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(4559532, 'PW', 'Ngatpang', 1, 'ngatpang'),
(4559630, 'PW', 'Sonsorol', 1, 'sonsorol'),
(4559774, 'PW', 'Kayangel', 1, 'kayangel'),
(4559776, 'PW', 'Hatohobei', 1, 'hatohobei'),
(4559964, 'PW', 'Aimeliik', 1, 'aimeliik'),
(7037645, 'PW', 'Airai', 1, 'airai'),
(7037653, 'PW', 'Angaur', 1, 'angaur'),
(7037892, 'PW', 'Koror', 1, 'koror'),
(7037930, 'PW', 'Melekeok', 1, 'melekeok'),
(7037962, 'PW', 'Ngaraard', 1, 'ngaraard'),
(7037976, 'PW', 'Ngchesar', 1, 'ngchesar'),
(7038037, 'PW', 'Ngarchelong', 1, 'ngarchelong'),
(7038043, 'PW', 'Ngardmau', 1, 'ngardmau'),
(7038068, 'PW', 'Ngaremlengui', 1, 'ngaremlengui'),
(7038179, 'PW', 'Ngiwal', 1, 'ngiwal'),
(7038261, 'PW', 'Peleliu', 1, 'peleliu');

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 
(4559338, 7038037, 'PW', 'Iebukel Hamlet', 1, 'iebukel-hamlet', 7.70006, 134.64097),
(4559350, 7037892, 'PW', 'Ngermid Hamlet', 1, 'ngermid-hamlet', 7.33983, 134.50163),
(4559351, 7038261, 'PW', 'Kloulklubed Hamlet', 1, 'kloulklubed-hamlet', 7.04193, 134.25549),
(4559353, 7037892, 'PW', 'Tngeronger Hamlet', 1, 'tngeronger-hamlet', 7.34449, 134.47912),
(4559362, 7037645, 'PW', 'Ngchesechang Hamlet', 1, 'ngchesechang-hamlet', 7.38472, 134.58027),
(4559400, 7037892, 'PW', 'Ngerbeched Hamlet', 1, 'ngerbeched-hamlet', 7.33249, 134.47623),
(4559419, 7037645, 'PW', 'Oikull Hamlet', 1, 'oikull-hamlet', 7.37192, 134.58773),
(4559444, 7037892, 'PW', 'Echang Hamlet', 1, 'echang-hamlet', 7.34661, 134.45289),
(4559446, 7037892, 'PW', 'Koror', 1, 'koror', 7.33978, 134.47326),
(4559475, 7037930, 'PW', 'Ngermelech Hamlet', 1, 'ngermelech-hamlet', 7.49966, 134.6347),
(4559480, 4559964, 'PW', 'Ngchemiangel Hamlet', 1, 'ngchemiangel-hamlet', 7.446, 134.47596),
(4559482, 7037892, 'PW', 'Echol Hamlet', 1, 'echol-hamlet', 7.35133, 134.44693),
(4559484, 7037892, 'PW', 'Idid Hamlet', 1, 'idid-hamlet', 7.34299, 134.48373),
(4559488, 4559964, 'PW', 'Ngerkeai Hamlet', 1, 'ngerkeai-hamlet', 7.42072, 134.49786),
(4559513, 7037892, 'PW', 'Ngerchemai Hamlet', 1, 'ngerchemai-hamlet', 7.35, 134.4889),
(4559534, 7037645, 'PW', 'Ngetkib Hamlet', 1, 'ngetkib-hamlet', 7.36438, 134.51439),
(4559543, 7037962, 'PW', 'Ulimang', 1, 'ulimang', 7.62416, 134.64208),
(4559604, 7038037, 'PW', 'Chollei Hamlet', 1, 'chollei-hamlet', 7.71985, 134.61414),
(4559617, 7038037, 'PW', 'Ngriil Hamlet', 1, 'ngriil-hamlet', 7.69032, 134.63609),
(4559635, 7037930, 'PW', 'Ertong Hamlet', 1, 'ertong-hamlet', 7.50442, 134.6148),
(4559645, 7037976, 'PW', 'Ngeruikl Hamlet', 1, 'ngeruikl-hamlet', 7.48362, 134.61664),
(4559654, 7037645, 'PW', 'Ngeruluobel Hamlet', 1, 'ngeruluobel-hamlet', 7.36448, 134.52412),
(4559670, 7037976, 'PW', 'Ngerngesang Hamlet', 1, 'ngerngesang-hamlet', 7.45304, 134.60375),
(4559673, 7038068, 'PW', 'Ngermetengel Hamlet', 1, 'ngermetengel-hamlet', 7.52253, 134.50268),
(4559674, 4559964, 'PW', 'Elechui Hamlet', 1, 'elechui-hamlet', 7.43161, 134.47997),
(4559694, 7037892, 'PW', 'Meketii Hamlet', 1, 'meketii-hamlet', 7.34708, 134.48299),
(4559703, 7037892, 'PW', 'Ngerekebesang Hamlet', 1, 'ngerekebesang-hamlet', 7.35444, 134.44648),
(4559720, 7038179, 'PW', 'Ngerkeai', 1, 'ngerkeai', 7.55458, 134.63582),
(4559728, 7037892, 'PW', 'Ngerbodel Hamlet', 1, 'ngerbodel-hamlet', 7.35, 134.4939),
(4559732, 7038037, 'PW', 'Ngerbau Hamlet', 1, 'ngerbau-hamlet', 7.70291, 134.64106),
(4559755, 7037930, 'PW', 'Ngeburch Hamlet', 1, 'ngeburch-hamlet', 7.50762, 134.62932),
(4559785, 7037653, 'PW', 'Angaur', 1, 'angaur', 6.90331, 134.13133),
(4559797, 7037892, 'PW', 'Meyungs Hamlet', 1, 'meyungs-hamlet', 7.35381, 134.45963),
(4559804, 7037930, 'PW', 'Melekeok Village', 1, 'melekeok-village', 7.49567, 134.63671),
(4559812, 4559964, 'PW', 'Medorm Hamlet', 1, 'medorm-hamlet', 7.4565, 134.47901),
(4559847, 7037892, 'PW', 'Iyebukel Hamlet', 1, 'iyebukel-hamlet', 7.34929, 134.48594),
(4559864, 7038068, 'PW', 'Imeong Hamlet', 1, 'imeong-hamlet', 7.53134, 134.52713),
(4559890, 4559964, 'PW', 'Eimelik Hamlet', 1, 'eimelik-hamlet', 7.3973, 134.51034),
(4559914, 7037962, 'PW', 'Chelab Hamlet', 1, 'chelab-hamlet', 7.63575, 134.63885),
(4559962, 7037645, 'PW', 'Airai Hamlet', 1, 'airai-hamlet', 7.35985, 134.55946),
(7036778, 7037976, 'PW', 'Ngchesar Hamlet', 1, 'ngchesar-hamlet', 7.46932, 134.60991),
(7037733, 7037962, 'PW', 'Chol Hamlet', 1, 'chol-hamlet', 7.67063, 134.63587),
(7037770, 4559964, 'PW', 'Elauesachel Hamlet', 1, 'elauesachel-hamlet', 7.45743, 134.50616),
(7037805, 7037930, 'PW', 'Ngerubesang Hamlet', 1, 'ngerubesang-hamlet', 7.48969, 134.63093),
(7037823, 7038261, 'PW', 'Imelechol Hamlet', 1, 'imelechol-hamlet', 7.03966, 134.2656),
(7037993, 7038037, 'PW', 'Ngebei Hamlet', 1, 'ngebei-hamlet', 7.69887, 134.63672),
(7038053, 4559532, 'PW', 'Ngereklmadel', 1, 'ngereklmadel', 7.48822, 134.4848),
(7038080, 7037976, 'PW', 'Ngerkesou Hamlet', 1, 'ngerkesou-hamlet', 7.46363, 134.60478),
(7038084, 7037892, 'PW', 'Ngerkeseuaol Hamlet', 1, 'ngerkeseuaol-hamlet', 7.34301, 134.48949),
(7038107, 7037976, 'PW', 'Ngersuul Hamlet', 1, 'ngersuul-hamlet', 7.43479, 134.59495),
(7038109, 7037645, 'PW', 'Ngersung Hamlet', 1, 'ngersung-hamlet', 7.35412, 134.53576),
(7038130, 7037930, 'PW', 'Ngeruling Hamlet', 1, 'ngeruling-hamlet', 7.50535, 134.63249),
(7038140, 7037645, 'PW', 'Ngerusar Hamlet', 1, 'ngerusar-hamlet', 7.35987, 134.52965),
(7038144, 7037962, 'PW', 'Ngesang', 1, 'ngesang', 7.62695, 134.64373),
(7038170, 7038037, 'PW', 'Mengellang', 1, 'mengellang', 7.6957, 134.63054),
(7038174, 7037962, 'PW', 'Ngkeklau Hamlet', 1, 'ngkeklau-hamlet', 7.59296, 134.6402),
(7038282, 7037653, 'PW', 'Angaur State', 1, 'angaur-state', 6.90601, 134.12997),
(7038316, 7038043, 'PW', 'Ngardmau Village', 1, 'ngardmau-village', 7.60988, 134.57418),
(7038353, 7037645, 'PW', 'Yelch - New Village', 1, 'yelch-new-village', 7.36051, 134.5457),
(10670730, 4559776, 'PW', 'Tobi Village', 1, 'tobi-village', 3.00488, 131.12168),
(10670816, 4559630, 'PW', 'Sonsorol Village', 1, 'sonsorol-village', 5.32608, 132.21943),
(10670861, 4559630, 'PW', 'Pulo Anna Village', 1, 'pulo-anna-village', 4.65404, 131.94901),
(10670994, 4559774, 'PW', 'Kayangel', 1, 'kayangel', 8.08228, 134.71725),
(10671223, 7038261, 'PW', 'Kloulklubed', 1, 'kloulklubed', 7.04192, 134.25561),
(10701398, 7037962, 'PW', 'Ngebuked Hamlet', 1, 'ngebuked-hamlet', 7.64191, 134.63049),
(10701544, 7037645, 'PW', 'Ordomel Hamlet', 1, 'ordomel-hamlet', 7.38111, 134.5552),
(10701549, 7037645, 'PW', 'Ngetkib', 1, 'ngetkib', 7.36451, 134.51484),
(10732276, 4559964, 'PW', 'Ngchemiangel', 1, 'ngchemiangel', 7.44613, 134.47678),
(10732297, 7038043, 'PW', 'Ngardmau', 1, 'ngardmau', 7.60986, 134.5744),
(10732314, 7037930, 'PW', 'Ngeremecheluch Hamlet', 1, 'ngeremecheluch-hamlet', 7.49199, 134.63596),
(10732415, 7037892, 'PW', 'Koror Town', 1, 'koror-town', 7.34257, 134.47888),
(10732825, 7037976, 'PW', 'Ngeraus Hamlet', 1, 'ngeraus-hamlet', 7.47667, 134.61346);