REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('NC', 'New Caledonia', 'Nouvelle-Calédonie', 'new-caledonia', '687', 'XPF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5140464, 'NC', 'South Province', 1, 'south-province'),
(5140685, 'NC', 'North Province', 1, 'north-province'),
(10521415, 'NC', 'Loyalty Islands', 1, 'loyalty-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 
(5137666, 5140464, 'NC', 'Yahoué', 1, 'yahoue', -22.20726, 166.48574),
(5137675, 10521415, 'NC', 'Winikuye', 1, 'winikuye', -21.54272, 167.87673),
(5137686, 10521415, 'NC', 'Webegunin', 1, 'webegunin', -21.52125, 167.85247),
(5137690, 10521415, 'NC', 'Wé', 1, 'we', -20.91687, 167.26461),
(5137713, 5140685, 'NC', 'Wala', 1, 'wala', -19.71161, 163.64702),
(5137715, 10521415, 'NC', 'Wakuarori', 1, 'wakuarori', -21.43743, 167.89021),
(5137716, 10521415, 'NC', 'Wakone', 1, 'wakone', -21.45932, 168.09294),
(5137721, 5140464, 'NC', 'Yaté', 1, 'yate', -22.16667, 166.95),
(5137735, 10521415, 'NC', 'Wacamadra', 1, 'wacamadra', -21.46741, 168.03102),
(5137739, 10521415, 'NC', 'Wabao', 1, 'wabao', -21.60237, 167.93668),
(5137748, 5140685, 'NC', 'Voh', 1, 'voh', -20.96667, 164.7),
(5137773, 5140464, 'NC', 'Vao', 1, 'vao', -22.66645, 167.49627),
(5137826, 10521415, 'NC', 'Tuo', 1, 'tuo', -21.49792, 167.89461),
(5137873, 5140685, 'NC', 'Touho', 1, 'touho', -20.79094, 165.24987),
(5137901, 5140464, 'NC', 'Tongouin', 1, 'tongouin', -22.10774, 166.20224),
(5137904, 5140464, 'NC', 'Tonghoué', 1, 'tonghoue', -22.2, 166.47969),
(5137908, 5140464, 'NC', 'Tomo', 1, 'tomo', -21.95771, 166.14924),
(5137927, 10521415, 'NC', 'Toen', 1, 'toen', -21.49626, 167.8425),
(5138003, 5140464, 'NC', 'Timbia', 1, 'timbia', -22.13707, 166.22377),
(5138056, 5140464, 'NC', 'Tiaré', 1, 'tiare', -22.16261, 166.27866),
(5138095, 10521415, 'NC', 'Thuma', 1, 'thuma', -21.48773, 167.89564),
(5138099, 10521415, 'NC', 'Thogoon', 1, 'thogoon', -21.39619, 167.90118),
(5138103, 5140464, 'NC', 'Thio', 1, 'thio', -21.61667, 166.21667),
(5138152, 10521415, 'NC', 'Tenan', 1, 'tenan', -21.40496, 167.89444),
(5138203, 10521415, 'NC', 'Tawainedr', 1, 'tawainedr', -21.502, 168.08301),
(5138234, 10521415, 'NC', 'Taode', 1, 'taode', -21.45044, 167.91039),
(5138285, 10521415, 'NC', 'Tadine', 1, 'tadine', -21.54751, 167.88019),
(5138356, 5140464, 'NC', 'Sarraméa', 1, 'sarramea', -21.65, 165.85),
(5138373, 5140464, 'NC', 'Saint-Vincent', 1, 'saint-vincent', -22.06232, 166.27287),
(5138439, 10521415, 'NC', 'Sailali', 1, 'sailali', -21.45883, 167.97939),
(5138449, 10521415, 'NC', 'Ruete', 1, 'ruete', -21.54028, 167.89044),
(5138466, 10521415, 'NC', 'Ro', 1, 'ro', -21.39253, 167.86233),
(5138481, 10521415, 'NC', 'Rawa', 1, 'rawa', -21.49515, 167.97665),
(5138522, 5140685, 'NC', 'Poya', 1, 'poya', -21.35, 165.15),
(5138555, 5140685, 'NC', 'Poum', 1, 'poum', -20.23333, 164.01667),
(5138592, 5140685, 'NC', 'Pouembout', 1, 'pouembout', -21.13333, 164.9),
(5138607, 5140685, 'NC', 'Pouébo', 1, 'pouebo', -20.4, 164.56667),
(5138661, 5140464, 'NC', 'Pote', 1, 'pote', -21.45399, 165.49114),
(5138663, 10521415, 'NC', 'Port-Saïd', 1, 'port-said', -21.5129, 167.90881),
(5138671, 5140685, 'NC', 'Poro', 1, 'poro', -21.31667, 165.63333),
(5138679, 5140464, 'NC', 'Pont des Français', 1, 'pont-des-francais', -22.22028, 166.49446),
(5138682, 10521415, 'NC', 'Ponibok', 1, 'ponibok', -21.50288, 167.97374),
(5138687, 5140685, 'NC', 'Ponérihouen', 1, 'ponerihouen', -21.08333, 165.4),
(5138717, 5140685, 'NC', 'Poindimié', 1, 'poindimie', -20.93333, 165.33333),
(5138772, 5140464, 'NC', 'Plum', 1, 'plum', -22.27226, 166.6144),
(5138776, 5140464, 'NC', 'Plaine aux Cailloux', 1, 'plaine-aux-cailloux', -22.09319, 166.36993),
(5138825, 10521415, 'NC', 'Peyec', 1, 'peyec', -21.45366, 167.97847),
(5138827, 10521415, 'NC', 'Pewaet', 1, 'pewaet', -21.54772, 168.07276),
(5138857, 10521415, 'NC', 'Penelo', 1, 'penelo', -21.57205, 168.08964),
(5138896, 10521415, 'NC', 'Patho', 1, 'patho', -21.57991, 168.1061),
(5138981, 5140464, 'NC', 'Païta', 1, 'paita', -22.13105, 166.35717),
(5139128, 5140464, 'NC', 'Ouinané-Nétéa', 1, 'ouinane-netea', -21.92016, 166.15964),
(5139259, 5140685, 'NC', 'Ouégoa', 1, 'ouegoa', -20.35, 164.43333),
(5139435, 5140685, 'NC', 'Ouåco', 1, 'ouaco', -20.83531, 164.46945),
(5139521, 5140464, 'NC', 'Nouméa', 1, 'noumea', -22.27407, 166.44884),
(5139651, 10521415, 'NC', 'Hnidenod', 1, 'hnidenod', -21.56543, 167.87757),
(5139729, 5140685, 'NC', 'Népoui', 1, 'nepoui', -21.32832, 164.99851),
(5139843, 10521415, 'NC', 'Nece', 1, 'nece', -21.49161, 167.83898),
(5139897, 5140464, 'NC', 'Ndé', 1, 'nde', -22.1507, 166.30788),
(5139922, 5140464, 'NC', 'Nassirah', 1, 'nassirah', -21.80152, 166.06293),
(5139925, 5140464, 'NC', 'Nassandou', 1, 'nassandou', -22.08228, 166.25729),
(5139959, 5140464, 'NC', 'Naniouni', 1, 'naniouni', -22.12435, 166.29426),
(5139961, 10521415, 'NC', 'Nang', 1, 'nang', -20.80595, 167.22646),
(5139973, 5140464, 'NC', 'Nakutakoin', 1, 'nakutakoin', -22.16561, 166.42478),
(5139988, 5140464, 'NC', 'Naïa', 1, 'naia', -22.15903, 166.26037),
(5140044, 10521415, 'NC', 'Mou', 1, 'mou', -21.09357, 167.39902),
(5140066, 5140464, 'NC', 'Mont-Dore', 1, 'mont-dore', -22.26257, 166.56621),
(5140110, 5140464, 'NC', 'Moindou', 1, 'moindou', -21.7, 165.68333),
(5140217, 10521415, 'NC', 'Menaku', 1, 'menaku', -21.44342, 167.96908),
(5140246, 10521415, 'NC', 'Medu', 1, 'medu', -21.62174, 167.95284),
(5140252, 10521415, 'NC', 'Mebuet', 1, 'mebuet', -21.5121, 167.84869),
(5140377, 10521415, 'NC', 'Lot', 1, 'lot', -21.38747, 167.85527),
(5140385, 10521415, 'NC', 'Lion', 1, 'lion', -21.47566, 167.93728),
(5140388, 10521415, 'NC', 'Kaewaura', 1, 'kaewaura', -21.47128, 167.95821),
(5140450, 10521415, 'NC', 'La Roche', 1, 'la-roche', -21.47799, 168.02593),
(5140466, 5140464, 'NC', 'La Foa', 1, 'la-foa', -21.71079, 165.82764),
(5140469, 5140464, 'NC', 'La Couvelée', 1, 'la-couvelee', -22.139, 166.46535),
(5140471, 5140464, 'NC', 'La Coulée', 1, 'la-coulee', -22.23127, 166.57582),
(5140485, 10521415, 'NC', 'Kurin', 1, 'kurin', -21.59897, 168.10905),
(5140521, 5140464, 'NC', 'Koutio', 1, 'koutio', -22.2056, 166.4624),
(5140558, 5140685, 'NC', 'Koumac', 1, 'koumac', -20.56667, 164.28333),
(5140621, 5140685, 'NC', 'Kouaoua', 1, 'kouaoua', -21.39554, 165.82695),
(5140649, 5140464, 'NC', 'Koua', 1, 'koua', -21.74638, 166.08931),
(5140691, 5140685, 'NC', 'Koné', 1, 'kone', -21.05951, 164.86582),
(5140773, 10521415, 'NC', 'Kezien', 1, 'kezien', -21.59737, 167.89818),
(5140827, 5140464, 'NC', 'Karenga', 1, 'karenga', -22.01698, 166.23709),
(5140884, 10521415, 'NC', 'Kalen', 1, 'kalen', -21.49799, 167.84271),
(5140903, 10521415, 'NC', 'Kaewatin', 1, 'kaewatin', -21.39594, 167.93562),
(5140915, 5140685, 'NC', 'Kaala-Gomén', 1, 'kaala-gomen', -20.66667, 164.4),
(5140952, 10521415, 'NC', 'Inagod', 1, 'inagod', -21.01745, 167.37413),
(5141006, 5140685, 'NC', 'Houaïlou', 1, 'houailou', -21.28333, 165.61667),
(5141016, 10521415, 'NC', 'Hnawayaca', 1, 'hnawayaca', -21.44162, 167.86125),
(5141030, 10521415, 'NC', 'Hnaenedr', 1, 'hnaenedr', -21.47217, 168.00405),
(5141031, 10521415, 'NC', 'Hnadidi', 1, 'hnadidi', -21.45575, 168.10102),
(5141050, 5140685, 'NC', 'Hienghène', 1, 'hienghene', -20.68333, 164.93333),
(5141061, 5140464, 'NC', 'Haute Tamoa', 1, 'haute-tamoa', -22.06252, 166.29864),
(5141063, 5140464, 'NC', 'Haute Couvelée', 1, 'haute-couvelee', -22.12817, 166.46545),
(5141195, 5140464, 'NC', 'Gillês', 1, 'gilles', -21.89218, 166.01889),
(5141305, 10521415, 'NC', 'Fayaoué', 1, 'fayaoue', -20.65284, 166.53641),
(5141316, 5140464, 'NC', 'Farino', 1, 'farino', -21.66667, 165.76667),
(5141340, 10521415, 'NC', 'Ete', 1, 'ete', -21.51964, 167.854),
(5141360, 10521415, 'NC', 'Eni', 1, 'eni', -21.62744, 167.94826),
(5141362, 10521415, 'NC', 'Enene', 1, 'enene', -21.51669, 168.05775),
(5141394, 5140464, 'NC', 'Dumbéa', 1, 'dumbea', -22.15757, 166.4572),
(5141529, 10521415, 'NC', 'Cuaden', 1, 'cuaden', -21.54763, 168.09538),
(5141568, 5140464, 'NC', 'La Conception', 1, 'la-conception', -22.22431, 166.5011),
(5141600, 10521415, 'NC', 'Chépénéhé', 1, 'chepenehe', -20.78333, 167.15),
(5141626, 10521415, 'NC', 'Ceni', 1, 'ceni', -21.47169, 168.01267),
(5141627, 10521415, 'NC', 'Cengeite', 1, 'cengeite', -21.59415, 167.89736),
(5141658, 5140685, 'NC', 'Canala', 1, 'canala', -21.53333, 165.95),
(5141714, 5140464, 'NC', 'Bourail', 1, 'bourail', -21.5669, 165.49736),
(5141722, 5140464, 'NC', 'Bouloupari', 1, 'bouloupari', -21.86226, 166.05122),
(5141905, 10521415, 'NC', 'Beshe', 1, 'beshe', -21.52481, 167.85473),
(5142010, 5140464, 'NC', 'Azareu', 1, 'azareu', -21.45814, 165.47088),
(5142013, 10521415, 'NC', 'Awi', 1, 'awi', -21.60771, 167.94891),
(5142026, 5140464, 'NC', 'Auteuil', 1, 'auteuil', -22.20776, 166.47405),
(5142033, 10521415, 'NC', 'Atha', 1, 'atha', -21.47205, 168.01631),
(11469107, 5140464, 'NC', 'La Tontouta', 1, 'la-tontouta', -22.01285, 166.22375),
(11520155, 5140464, 'NC', 'Xéré', 1, 'xere', -22.28636, 167.01141),
(11520198, 10521415, 'NC', 'Huathalo', 1, 'huathalo', -20.79086, 167.25286),
(13234196, 5140464, 'NC', 'Yuate Tremwatre', 1, 'yuate-tremwatre', -22.62542, 167.49082),
(13861676, 5140464, 'NC', 'Anse Vata', 1, 'anse-vata', -22.30037, 166.44347),
(14956099, 5140464, 'NC', 'Ferme Nord', 1, 'ferme-nord', -22.25676, 166.39157),
(14956120, 5140464, 'NC', 'Les Koghis', 1, 'les-koghis', -22.18063, 166.49137),
(14956121, 5140464, 'NC', 'La Rhumerie', 1, 'la-rhumerie', -22.15498, 166.46776),
(14956122, 5140464, 'NC', 'La Caféirie', 1, 'la-cafeirie', -22.15063, 166.4783),
(14956124, 5140464, 'NC', 'Nondoué', 1, 'nondoue', -22.12926, 166.44324),
(14956125, 5140464, 'NC', 'Katiramona', 1, 'katiramona', -22.13454, 166.43169),
(14956132, 5140464, 'NC', 'Val Fleuri', 1, 'val-fleuri', -22.12066, 166.43305),
(14956133, 5140464, 'NC', 'Val Suzon', 1, 'val-suzon', -22.11483, 166.42361),
(14956137, 5140464, 'NC', 'Ondémia', 1, 'ondemia', -22.12793, 166.34334),
(14956165, 5140464, 'NC', 'La Pépinière', 1, 'la-pepiniere', -22.1723, 166.46754),
(14956166, 5140464, 'NC', 'L\'Ermitage', 1, 'l-ermitage', -22.17925, 166.47679),
(14956175, 5140464, 'NC', 'Saint-Laurent', 1, 'saint-laurent', -22.07743, 166.30654),
(14956241, 5140464, 'NC', 'Nakouta', 1, 'nakouta', -22.1618, 166.26336),
(14956853, 5140464, 'NC', 'Enghoué', 1, 'enghoue', -22.14744, 166.24507),
(14956878, 5140464, 'NC', 'Karikaté', 1, 'karikate', -22.10747, 166.18778),
(14956879, 5140464, 'NC', 'Neto', 1, 'neto', -22.12157, 166.21473),
(14956880, 5140464, 'NC', 'Port Ouenghi', 1, 'port-ouenghi', -21.90255, 166.06786),
(14956881, 5140464, 'NC', 'Némokwêdö', 1, 'nemokwedo', -21.82582, 166.11581),
(14956882, 5140464, 'NC', 'Tagi', 1, 'tagi', -21.80323, 166.06638),
(14958023, 5140464, 'NC', 'Xwê Pwé', 1, 'xwe-pwe', -21.90208, 166.01382),
(14958033, 5140464, 'NC', 'Saint-Maurice', 1, 'saint-maurice', -21.76715, 166.11324),
(14959020, 5140464, 'NC', 'Anderson', 1, 'anderson', -21.8705, 166.0433),
(14959055, 5140464, 'NC', 'Station de Ouinané', 1, 'station-de-ouinane', -21.92817, 166.13867),
(15023818, 10521415, 'NC', 'Padawa', 1, 'padawa', -21.46055, 167.84151),
(15023819, 10521415, 'NC', 'Webehned', 1, 'webehned', -21.48666, 167.8383),
(15023820, 10521415, 'NC', 'Wadiric', 1, 'wadiric', -21.48181, 167.83409),
(15023821, 10521415, 'NC', 'Pawaguam', 1, 'pawaguam', -21.50466, 167.84594),
(15023822, 10521415, 'NC', 'Esho', 1, 'esho', -21.50053, 167.84485),
(15023823, 10521415, 'NC', 'Wateta', 1, 'wateta', -21.54261, 167.87376),
(15023824, 10521415, 'NC', 'Hnaridimen', 1, 'hnaridimen', -21.55673, 167.87834),
(15023825, 10521415, 'NC', 'La Kaw', 1, 'la-kaw', -21.59594, 167.88599),
(15023827, 10521415, 'NC', 'Bone', 1, 'bone', -21.46384, 167.93166),
(15023828, 10521415, 'NC', 'Toka', 1, 'toka', -21.09428, 167.79685),
(15023850, 10521415, 'NC', 'Cerethi', 1, 'cerethi', -21.57575, 168.08419),
(15023851, 10521415, 'NC', 'Denaco', 1, 'denaco', -21.56937, 168.08757),
(15023897, 10521415, 'NC', 'Wacebeu', 1, 'wacebeu', -21.49266, 167.87817),
(15023898, 10521415, 'NC', 'Degene', 1, 'degene', -21.48828, 167.86407),
(15023899, 10521415, 'NC', 'Udekeu', 1, 'udekeu', -21.48677, 167.87083),
(15023953, 10521415, 'NC', 'Cadralo', 1, 'cadralo', -21.39212, 167.93442),
(15023990, 10521415, 'NC', 'Peucade', 1, 'peucade', -21.47015, 168.09832),
(15023991, 10521415, 'NC', 'Watha', 1, 'watha', -21.4653, 167.96265),
(15023997, 10521415, 'NC', 'Wiawia', 1, 'wiawia', -21.47551, 168.02494),
(15023998, 10521415, 'NC', 'Loi', 1, 'loi', -21.5616, 167.87665),
(15024005, 10521415, 'NC', 'Hnabaek', 1, 'hnabaek', -21.46653, 168.07086),
(15024006, 10521415, 'NC', 'Kaeguahnakun', 1, 'kaeguahnakun', -21.46184, 168.07562),
(15024007, 10521415, 'NC', 'Uni', 1, 'uni', -21.62095, 167.9516),
(15024008, 10521415, 'NC', 'Waetetubene', 1, 'waetetubene', -21.62257, 167.95416),
(15024011, 10521415, 'NC', 'Jore', 1, 'jore', -21.60376, 167.93436),
(15024012, 10521415, 'NC', 'Ninic', 1, 'ninic', -21.60188, 167.92803),
(15024046, 10521415, 'NC', 'Papa', 1, 'papa', -21.4466, 167.97226),
(15024052, 10521415, 'NC', 'Wahmetu', 1, 'wahmetu', -21.45621, 167.91848);