REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('TO', 'Tonga', 'Tonga', 'tonga', '676', 'TOP');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(7032231, 'TO', 'Vava‘u', 1, 'vava-u'),
(7032279, 'TO', 'Tongatapu', 1, 'tongatapu'),
(7032637, 'TO', 'Ha‘apai', 1, 'ha-apai'),
(10668021, 'TO', 'ʻEua', 1, 'eua'),
(10668055, 'TO', 'Niuas', 1, 'niuas');

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 
(7032228, 7032279, 'TO', 'Veitongo', 1, 'veitongo', -21.18478, -175.21251),
(7032234, 7032279, 'TO', 'Vaotu‘u', 1, 'vaotu-u', -21.1607, -175.31116),
(7032242, 10668055, 'TO', 'Vaipoa', 1, 'vaipoa', -15.94755, -173.78242),
(7032243, 7032279, 'TO', 'Vaini', 1, 'vaini', -21.19292, -175.17678),
(7032244, 7032231, 'TO', 'Vaimalo', 1, 'vaimalo', -18.63821, -174.0056),
(7032249, 7032231, 'TO', 'Utungake', 1, 'utungake', -18.66624, -174.0215),
(7032250, 7032231, 'TO', 'Utulei', 1, 'utulei', -18.65346, -173.9966),
(7032251, 7032279, 'TO', 'Utulau', 1, 'utulau', -21.18333, -175.26667),
(7032252, 7032231, 'TO', 'Utui', 1, 'utui', -18.63848, -173.95709),
(7032270, 10668021, 'TO', 'Tufurai', 1, 'tufurai', -21.36667, -174.96667),
(7032272, 7032231, 'TO', 'Tu‘anuku', 1, 'tu-anuku', -18.66271, -174.03291),
(7032274, 7032231, 'TO', 'Tu‘anekivale', 1, 'tu-anekivale', -18.62875, -173.92095),
(7032281, 7032231, 'TO', 'Tongamama‘o', 1, 'tongamama-o', -15.61535, -175.60851),
(7032288, 7032279, 'TO', 'Tokomololo', 1, 'tokomololo', -21.17656, -175.24512),
(7032295, 7032279, 'TO', 'Tofoa', 1, 'tofoa', -21.1579, -175.2263),
(7032306, 7032231, 'TO', 'Tefisi', 1, 'tefisi', -18.62976, -174.01448),
(7032307, 7032279, 'TO', 'Te‘ekiu', 1, 'te-ekiu', -21.12822, -175.31868),
(7032323, 7032279, 'TO', 'Talafo‘ou', 1, 'talafo-ou', -21.13333, -175.1),
(7032326, 7032231, 'TO', 'Ta‘anea', 1, 'ta-anea', -18.60769, -173.93739),
(7032336, 7032231, 'TO', 'Sapa‘ata', 1, 'sapa-ata', -15.56839, -175.62466),
(7032348, 7032637, 'TO', 'Puleieia', 1, 'puleieia', -19.6, -174.45),
(7032349, 7032637, 'TO', 'Pukutala', 1, 'pukutala', -19.67889, -174.28017),
(7032352, 7032279, 'TO', 'Puke', 1, 'puke', -21.13178, -175.23872),
(7032360, 7032231, 'TO', 'Petani', 1, 'petani', -15.61848, -175.61414),
(7032363, 7032279, 'TO', 'Pea', 1, 'pea', -21.17178, -175.23502),
(7032368, 10668021, 'TO', 'Pangai', 1, 'pangai', -21.36229, -174.95294),
(7032369, 7032637, 'TO', 'Pangai', 1, 'pangai', -19.81468, -174.35423),
(7032370, 7032231, 'TO', 'Pangaimotu', 1, 'pangaimotu', -18.6855, -173.99739),
(7032384, 10668021, 'TO', '‘Ohonua', 1, 'ohonua', -21.33333, -174.95),
(7032392, 7032279, 'TO', 'Nukunuku', 1, 'nukunuku', -21.13333, -175.3),
(7032395, 7032279, 'TO', 'Nukuleka', 1, 'nukuleka', -21.15191, -175.12674),
(7032400, 7032279, 'TO', 'Nukuhetulu', 1, 'nukuhetulu', -21.16705, -175.18928),
(7032402, 7032279, 'TO', 'Nuku‘alofa', 1, 'nuku-alofa', -21.13938, -175.2018),
(7032407, 7032231, 'TO', 'Nopapu', 1, 'nopapu', -18.69929, -174.07507),
(7032411, 7032279, 'TO', 'Niutoua', 1, 'niutoua', -21.13333, -175.05),
(7032419, 7032279, 'TO', 'Neiafu', 1, 'neiafu', -21.07738, -175.33312),
(7032420, 7032231, 'TO', 'Neiafu', 1, 'neiafu', -18.6506, -173.98404),
(7032421, 7032279, 'TO', 'Navutoka', 1, 'navutoka', -21.11667, -175.1),
(7032422, 7032637, 'TO', 'Navea', 1, 'navea', -19.8, -174.35),
(7032425, 7032279, 'TO', 'Nakolo', 1, 'nakolo', -21.26759, -175.12304),
(7032431, 7032637, 'TO', 'Muitoa', 1, 'muitoa', -19.65229, -174.29441),
(7032443, 7032279, 'TO', 'Mu‘a', 1, 'mu-a', -21.18195, -175.11832),
(7032444, 7032231, 'TO', 'Mu‘a', 1, 'mu-a', -15.59741, -175.60478),
(7032467, 10668055, 'TO', 'Matavai', 1, 'matavai', -15.96667, -173.75),
(7032478, 7032231, 'TO', 'Mataika', 1, 'mataika', -18.61733, -173.96632),
(7032480, 7032279, 'TO', 'Matahau', 1, 'matahau', -21.1425, -175.3129),
(7032482, 7032231, 'TO', 'Mata‘aho', 1, 'mata-aho', -15.57769, -175.61273),
(7032483, 7032279, 'TO', 'Masilamea', 1, 'masilamea', -21.12535, -175.32424),
(7032487, 7032279, 'TO', 'Manuka', 1, 'manuka', -21.11667, -175.1),
(7032492, 7032231, 'TO', 'Mangia', 1, 'mangia', -18.62524, -173.95616),
(7032496, 7032279, 'TO', 'Malapo', 1, 'malapo', -21.20112, -175.15456),
(7032499, 7032231, 'TO', 'Makave', 1, 'makave', -18.65194, -173.96567),
(7032500, 7032279, 'TO', 'Makaunga', 1, 'makaunga', -21.14245, -175.12111),
(7032515, 7032637, 'TO', 'Lotofoa', 1, 'lotofoa', -19.74179, -174.305),
(7032518, 7032279, 'TO', 'Longoteme', 1, 'longoteme', -21.1807, -175.16982),
(7032519, 7032231, 'TO', 'Longomapu', 1, 'longomapu', -18.64463, -174.0579),
(7032529, 7032279, 'TO', 'Liahona', 1, 'liahona', -21.165, -175.27143),
(7032535, 7032231, 'TO', 'Leimatu‘a', 1, 'leimatu-a', -18.59964, -173.98121),
(7032537, 7032279, 'TO', 'Lavengatonga', 1, 'lavengatonga', -21.23493, -175.1071),
(7032543, 7032279, 'TO', 'Lapaha', 1, 'lapaha', -21.17735, -175.1172),
(7032548, 7032279, 'TO', 'Lakepa', 1, 'lakepa', -21.14211, -175.27939),
(7032557, 7032637, 'TO', 'Koulo', 1, 'koulo', -19.78835, -174.34487),
(7032563, 7032279, 'TO', 'Kolovai', 1, 'kolovai', -21.10101, -175.33766),
(7032566, 7032279, 'TO', 'Kolonga', 1, 'kolonga', -21.13333, -175.06667),
(7032568, 7032279, 'TO', 'Kolofuu', 1, 'kolofuu', -21.2, -175.16667),
(7032570, 7032231, 'TO', 'Koloa', 1, 'koloa', -18.64599, -173.93672),
(7032583, 7032279, 'TO', 'Kanokupolu', 1, 'kanokupolu', -21.0807, -175.33474),
(7032587, 7032279, 'TO', 'Kala‘au', 1, 'kala-au', -21.13941, -175.3355),
(7032602, 7032231, 'TO', 'Hunga', 1, 'hunga', -18.68354, -174.12244),
(7032603, 10668021, 'TO', 'Huma', 1, 'huma', -21.31667, -174.93333),
(7032606, 7032279, 'TO', 'Houma', 1, 'houma', -21.17005, -175.30213),
(7032611, 7032637, 'TO', 'Holopeka', 1, 'holopeka', -19.78367, -174.34316),
(7032613, 7032279, 'TO', 'Holonga', 1, 'holonga', -21.19258, -175.14282),
(7032614, 7032231, 'TO', 'Holonga', 1, 'holonga', -18.58947, -173.95048),
(7032615, 7032279, 'TO', 'Hoi', 1, 'hoi', -21.16598, -175.11173),
(7032616, 7032279, 'TO', 'Hofoa', 1, 'hofoa', -21.13135, -175.22733),
(7032618, 7032637, 'TO', 'Hihifo', 1, 'hihifo', -19.82097, -174.36633),
(7032619, 10668055, 'TO', 'Hihifo', 1, 'hihifo', -15.9544, -173.79616),
(7032622, 7032279, 'TO', 'Haveluliku', 1, 'haveluliku', -21.2, -175.1),
(7032623, 7032279, 'TO', 'Haveluloto', 1, 'haveluloto', -21.15216, -175.21333),
(7032624, 7032637, 'TO', 'Hatou', 1, 'hatou', -19.81667, -174.35),
(7032625, 7032279, 'TO', 'Hamula', 1, 'hamula', -21.2525, -175.11136),
(7032630, 7032279, 'TO', 'Ha‘avakatolo', 1, 'ha-avakatolo', -21.10861, -175.33854),
(7032631, 10668021, 'TO', 'Haatua', 1, 'haatua', -21.38333, -174.96667),
(7032632, 7032279, 'TO', 'Ha‘ateiho', 1, 'ha-ateiho', -21.1776, -175.23291),
(7032634, 7032279, 'TO', 'Ha‘atafu', 1, 'ha-atafu', -21.0715, -175.32751),
(7032635, 7032279, 'TO', 'Ha‘asini', 1, 'ha-asini', -21.24814, -175.11008),
(7032639, 7032637, 'TO', 'Ha‘ano', 1, 'ha-ano', -19.66233, -174.29028),
(7032641, 7032231, 'TO', 'Haalaufuli', 1, 'haalaufuli', -18.60877, -173.93445),
(7032642, 7032279, 'TO', 'Ha‘alalo', 1, 'ha-alalo', -21.18451, -175.28088),
(7032643, 7032279, 'TO', 'Ha‘akili', 1, 'ha-akili', -21.09099, -175.33792),
(7032644, 7032279, 'TO', 'Ha‘akame', 1, 'ha-akame', -21.18288, -175.28491),
(7032652, 7032279, 'TO', 'Fua‘amotu', 1, 'fua-amotu', -21.26403, -175.13902),
(7032653, 7032279, 'TO', 'Fo‘ui', 1, 'fo-ui', -21.11329, -175.33832),
(7032670, 7032637, 'TO', 'Fangale’ounga', 1, 'fangale-ounga', -19.75285, -174.32257),
(7032671, 7032279, 'TO', 'Folaha', 1, 'folaha', -21.16895, -175.17961),
(7032681, 7032231, 'TO', 'Feletoa', 1, 'feletoa', -18.61066, -173.97108),
(7032683, 7032279, 'TO', 'Fatumu', 1, 'fatumu', -21.21387, -175.10944),
(7032687, 7032231, 'TO', 'Fata‘ulua', 1, 'fata-ulua', -15.5731, -175.61777),
(7032688, 7032279, 'TO', 'Fatai', 1, 'fatai', -21.13385, -175.27612),
(7032701, 7032231, 'TO', 'Falevai', 1, 'falevai', -18.70505, -174.03527),
(7032702, 7032231, 'TO', 'Faleono', 1, 'faleono', -18.63322, -173.94213),
(7032703, 7032637, 'TO', 'Faleloa', 1, 'faleloa', -19.73392, -174.28729),
(7032704, 10668055, 'TO', 'Falehau', 1, 'falehau', -15.94565, -173.76569),
(7032709, 7032637, 'TO', 'Fakakai', 1, 'fakakai', -19.68459, -174.27406),
(7032716, 7032279, 'TO', 'Fahefa', 1, 'fahefa', -21.14436, -175.33303),
(7032726, 7032231, 'TO', 'Esia', 1, 'esia', -15.56802, -175.63609),
(7032773, 7032637, 'TO', 'Fotua', 1, 'fotua', -19.74925, -174.31748),
(7032774, 7032279, 'TO', 'Alaki', 1, 'alaki', -21.19282, -175.13158),
(7032776, 7032279, 'TO', 'Ahau', 1, 'ahau', -21.09336, -175.3381),
(7032781, 7032279, 'TO', 'Afa', 1, 'afa', -21.13333, -175.05),
(7036396, 7032279, 'TO', 'Hā‘utu', 1, 'ha-utu', -21.14459, -175.32984),
(10668008, 10668021, 'TO', 'Eua', 1, 'eua', -21.36407, -174.93866),
(11527822, 7032637, 'TO', 'Futu', 1, 'futu', -15.58725, -175.67),
(11527824, 7032637, 'TO', '’Alele’uta', 1, 'alele-uta', -15.56841, -175.62832),
(11528753, 7032231, 'TO', 'Taoa', 1, 'taoa', -18.62888, -173.98503),
(11528758, 7032231, 'TO', 'Kei', 1, 'kei', -18.62671, -173.92364),
(11528760, 7032231, 'TO', 'Ha’akio', 1, 'ha-akio', -18.62026, -173.94447),
(11528761, 7032231, 'TO', 'Houma', 1, 'houma', -18.63073, -173.94508),
(11528762, 7032231, 'TO', 'Toula', 1, 'toula', -18.67585, -173.98239),
(11528763, 7032231, 'TO', '’Olo’ua', 1, 'olo-ua', -18.6719, -173.95623),
(11528764, 7032231, 'TO', 'Ofu', 1, 'ofu', -18.69672, -173.96257),
(11528765, 7032231, 'TO', '’Otea', 1, 'otea', -18.68827, -174.03592),
(11528766, 7032231, 'TO', 'Kapa', 1, 'kapa', -18.70705, -174.03664),
(11528768, 7032231, 'TO', 'Holeva', 1, 'holeva', -18.64246, -173.92205),
(11528772, 7032231, 'TO', 'Nga’unoho', 1, 'nga-unoho', -18.68474, -174.02195),
(11528821, 10668055, 'TO', 'Ve’elolo', 1, 've-elolo', -15.94821, -173.72038),
(11528878, 7032231, 'TO', 'Kotomaka', 1, 'kotomaka', -20.2573, -174.79858),
(11528891, 7032637, 'TO', 'Luahoko', 1, 'luahoko', -19.67198, -174.39229),
(11529075, 7032231, 'TO', 'Topuefio', 1, 'topuefio', -19.68801, -175.02098),
(11529076, 7032231, 'TO', 'Hokula', 1, 'hokula', -19.71527, -175.05919),
(11529077, 7032637, 'TO', 'Manaka', 1, 'manaka', -19.75856, -175.02775),
(11529135, 7032231, 'TO', 'Talasiu', 1, 'talasiu', -21.17678, -175.11157),
(11529147, 7032231, 'TO', 'Pelehake', 1, 'pelehake', -21.21283, -175.14328),
(11529566, 7032231, 'TO', 'Taliai Camp', 1, 'taliai-camp', -21.24342, -175.13475),
(11529573, 7032279, 'TO', 'Houmakelikao', 1, 'houmakelikao', -21.14779, -175.17541),
(11529574, 7032279, 'TO', 'Koloua', 1, 'koloua', -21.16, -175.22705),
(11529575, 7032231, 'TO', 'Lotoha’apai', 1, 'lotoha-apai', -21.18811, -175.21335),
(14543613, 7032279, 'TO', 'Tatakamotonga', 1, 'tatakamotonga', -21.18627, -175.12453),
(14592701, 7032279, 'TO', 'Fanga O Pilolevu', 1, 'fanga-o-pilolevu', -21.14575, -175.21086);