REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('WF', 'Wallis and Futuna', 'Wallis et Futuna', 'wallis-and-futuna', '681', 'XPF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(7034759, 'WF', 'Uvea', 1, 'uvea'),
(7034776, 'WF', 'Sigave', 1, 'sigave'),
(7034884, 'WF', 'Alo', 1, 'alo');

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 
(7034753, 7034884, 'WF', 'Vele', 1, 'vele', -14.31021, -178.06538),
(7034754, 7034759, 'WF', 'Vaitupu', 1, 'vaitupu', -13.227, -176.18834),
(7034755, 7034759, 'WF', 'Vaimalau', 1, 'vaimalau', -13.31322, -176.24167),
(7034757, 7034759, 'WF', 'Vailala', 1, 'vailala', -13.22173, -176.20551),
(7034761, 7034759, 'WF', 'Utuloa', 1, 'utuloa', -13.26667, -176.18333),
(7034763, 7034759, 'WF', 'Utufua', 1, 'utufua', -13.34261, -176.19435),
(7034766, 7034759, 'WF', 'Tufuone', 1, 'tufuone', -13.22449, -176.21088),
(7034768, 7034759, 'WF', 'Tepa', 1, 'tepa', -13.32381, -176.18826),
(7034770, 7034759, 'WF', 'Teesi', 1, 'teesi', -13.35096, -176.20585),
(7034772, 7034776, 'WF', 'Tavai', 1, 'tavai', -14.24495, -178.16902),
(7034778, 7034776, 'WF', 'Leava', 1, 'leava', -14.29333, -178.15833),
(7034815, 7034884, 'WF', 'Mua', 1, 'mua', -14.32632, -178.05688),
(7034816, 7034759, 'WF', 'Mua', 1, 'mua', -13.34169, -176.18701),
(7034821, 7034759, 'WF', 'Mata-Utu', 1, 'mata-utu', -13.28163, -176.17453),
(7034831, 7034759, 'WF', 'Liku', 1, 'liku', -13.26852, -176.16586),
(7034839, 7034884, 'WF', 'Lano', 1, 'lano', -13.25632, -176.16792),
(7034843, 7034759, 'WF', 'Kolopopo', 1, 'kolopopo', -13.34703, -176.21512),
(7034845, 7034884, 'WF', 'Kolia', 1, 'kolia', -14.30751, -178.09683),
(7034854, 7034759, 'WF', 'Halamaitai', 1, 'halamaitai', -13.28184, -176.19045),
(7034856, 7034759, 'WF', 'Halalo', 1, 'halalo', -13.3454, -176.21464),
(7034857, 7034759, 'WF', 'Haatofo', 1, 'haatofo', -13.32807, -176.19058),
(7034858, 7034759, 'WF', 'Haafusia', 1, 'haafusia', -13.30034, -176.18362),
(7034859, 7034759, 'WF', 'Gamua', 1, 'gamua', -13.24855, -176.17813),
(7034860, 7034759, 'WF', 'Gahi', 1, 'gahi', -13.33793, -176.18774),
(7034865, 7034776, 'WF', 'Foi', 1, 'foi', -14.29445, -178.09289),
(7034867, 7034759, 'WF', 'Fineveke', 1, 'fineveke', -13.32624, -176.2213),
(7034872, 7034759, 'WF', 'Falaleu', 1, 'falaleu', -13.29266, -176.18328),
(7034874, 7034759, 'WF', 'Fakauita', 1, 'fakauita', -13.25, -176.18333),
(7034885, 7034884, 'WF', 'Alo', 1, 'alo', -14.31096, -178.11094),
(7034886, 7034759, 'WF', 'Alele', 1, 'alele', -13.24667, -176.18341),
(7034887, 7034759, 'WF', 'Akaka', 1, 'akaka', -13.27729, -176.17066),
(7034888, 7034759, 'WF', 'Ahoa', 1, 'ahoa', -13.28745, -176.23803),
(13632136, 7034759, 'WF', 'Fakapepe', 1, 'fakapepe', -13.22669, -176.21218),
(13632148, 7034884, 'WF', 'Mala\'e', 1, 'mala-e', -13.24435, -176.19346),
(13632334, 7034759, 'WF', 'Afala', 1, 'afala', -13.26799, -176.17921),
(13632339, 7034759, 'WF', 'Malelapa', 1, 'malelapa', -13.2353, -176.18288),
(13632353, 7034759, 'WF', 'Kaleva', 1, 'kaleva', -13.24234, -176.1808),
(13632354, 7034759, 'WF', 'Siaina', 1, 'siaina', -13.23144, -176.18584),
(13632355, 7034759, 'WF', 'Nefunefu', 1, 'nefunefu', -13.22924, -176.18557),
(13632356, 7034759, 'WF', 'Fakavaka', 1, 'fakavaka', -13.22665, -176.18674),
(13632357, 7034759, 'WF', 'Suva', 1, 'suva', -13.22423, -176.1915),
(13632358, 7034759, 'WF', 'Polata', 1, 'polata', -13.22211, -176.19661),
(13632436, 7034759, 'WF', 'Tutu\'ila', 1, 'tutu-ila', -13.34315, -176.21751),
(13632437, 7034759, 'WF', 'Lotoalahi', 1, 'lotoalahi', -13.34089, -176.20857),
(13632438, 7034759, 'WF', 'Ha\'apai', 1, 'ha-apai', -13.34733, -176.21172),
(13632459, 7034759, 'WF', 'Mala\'efo\'ou', 1, 'mala-efo-ou', -13.34544, -176.2016),
(13632460, 7034759, 'WF', 'Mala\'etoli', 1, 'mala-etoli', -13.31964, -176.2289),
(13632467, 7034759, 'WF', 'Lavegahau', 1, 'lavegahau', -13.31367, -176.18825),
(13632468, 7034759, 'WF', 'Makeke', 1, 'makeke', -13.30308, -176.18898),
(13632470, 7034759, 'WF', 'Taumata', 1, 'taumata', -13.29347, -176.18599),
(13632471, 7034759, 'WF', 'Havelu', 1, 'havelu', -13.28429, -176.18298),
(13632472, 7034759, 'WF', 'Kafika Tu\'utahi', 1, 'kafika-tu-utahi', -13.28231, -176.19021),
(13632473, 7034759, 'WF', 'Apaogo', 1, 'apaogo', -13.27077, -176.16591),
(13632474, 7034759, 'WF', 'Tekolo', 1, 'tekolo', -13.23061, -176.19247),
(13632475, 7034759, 'WF', 'Ala', 1, 'ala', -13.24465, -176.18024),
(13632476, 7034759, 'WF', 'Tukifatu', 1, 'tukifatu', -13.22775, -176.18957),
(13649227, 7034759, 'WF', 'Golf de Ololiki', 1, 'golf-de-ololiki', -13.25922, -176.20562),
(14880064, 7034884, 'WF', 'Taoa', 1, 'taoa', -14.30871, -178.12683),
(14880065, 7034884, 'WF', 'Fuga Alo', 1, 'fuga-alo', -14.30452, -178.12422),
(14880066, 7034884, 'WF', 'Kaleveleve', 1, 'kaleveleve', -14.30817, -178.13323),
(14880072, 7034776, 'WF', 'Fiua', 1, 'fiua', -14.27069, -178.17378),
(14880079, 7034776, 'WF', 'Vaisei', 1, 'vaisei', -14.27772, -178.17048),
(14880084, 7034776, 'WF', 'Luanuku', 1, 'luanuku', -14.30138, -178.15689),
(14880085, 7034776, 'WF', 'Vilamalia', 1, 'vilamalia', -14.2984, -178.1563),
(14880089, 7034884, 'WF', 'Fakaki', 1, 'fakaki', -14.29262, -178.09573),
(14880091, 7034884, 'WF', 'Tufu\'one', 1, 'tufu-one', -14.28702, -178.1024),
(14880092, 7034884, 'WF', 'Tamana', 1, 'tamana', -14.28439, -178.10431),
(14880093, 7034884, 'WF', 'Olu', 1, 'olu', -14.27848, -178.11151),
(14880094, 7034884, 'WF', 'Fikavi', 1, 'fikavi', -14.27124, -178.12006),
(14880097, 7034884, 'WF', 'Kapau', 1, 'kapau', -14.25598, -178.14342),
(14880098, 7034884, 'WF', 'Ogea', 1, 'ogea', -14.25683, -178.14128),
(14880099, 7034884, 'WF', 'Afaga', 1, 'afaga', -14.25939, -178.13414),
(14880100, 7034884, 'WF', 'Pouma', 1, 'pouma', -14.26209, -178.13086),
(14880101, 7034884, 'WF', 'Suma', 1, 'suma', -14.26862, -178.12335),
(14880105, 7034884, 'WF', 'Sisia', 1, 'sisia', -14.30687, -178.11367),
(14880106, 7034884, 'WF', 'Kolopelu', 1, 'kolopelu', -14.30902, -178.11854),
(14880862, 7034884, 'WF', 'Aletafa', 1, 'aletafa', -14.30784, -178.08997),
(14880863, 7034884, 'WF', 'Muli', 1, 'muli', -14.31162, -178.08227),
(14880864, 7034884, 'WF', 'Vaotea', 1, 'vaotea', -14.31034, -178.08439),
(14880886, 7034776, 'WF', 'Pito', 1, 'pito', -14.26103, -178.17769),
(14880892, 7034776, 'WF', 'Toloke', 1, 'toloke', -14.25349, -178.18093),
(14880901, 7034884, 'WF', 'Tuatafa', 1, 'tuatafa', -14.25467, -178.1515),
(14880916, 7034776, 'WF', 'Sausau', 1, 'sausau', -14.28854, -178.16746),
(14880917, 7034776, 'WF', 'Nuku', 1, 'nuku', -14.29104, -178.16536),
(14880934, 7034884, 'WF', 'Siku', 1, 'siku', -14.31024, -178.06529),
(14880937, 7034884, 'WF', 'Laloua', 1, 'laloua', -14.29941, -178.08029),
(14880938, 7034884, 'WF', 'Ava', 1, 'ava', -14.29661, -178.08968),
(14881004, 7034884, 'WF', 'Sologa', 1, 'sologa', -14.32449, -178.04063),
(14881005, 7034884, 'WF', 'Keu', 1, 'keu', -14.33546, -178.06897),
(14881006, 7034884, 'WF', 'Sa\'avaka', 1, 'sa-avaka', -14.3502, -178.02841);