REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('PF', 'French Polynesia', 'Polynésie française', 'french-polynesia', '689', 'XPF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(7019991, 'PF', 'Îles Marquises', 1, 'iles-marquises'),
(7030621, 'PF', 'Îles Tuamotu-Gambier', 1, 'iles-tuamotu-gambier'),
(7034364, 'PF', 'Leeward Islands', 1, 'leeward-islands'),
(7034365, 'PF', 'Îles du Vent', 1, 'iles-du-vent'),
(7034366, 'PF', 'Îles Australes', 1, 'iles-australes');

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 
(7020109, 7019991, 'PF', 'Atuona', 1, 'atuona', -9.80342, -139.04202),
(7030546, 7030621, 'PF', 'Taku', 1, 'taku', -23.08457, -134.9477),
(7030554, 7030621, 'PF', 'Rouru', 1, 'rouru', -23.13011, -134.96534),
(7030556, 7030621, 'PF', 'Rikitea', 1, 'rikitea', -23.12322, -134.96858),
(7030617, 7030621, 'PF', 'Kirimiro', 1, 'kirimiro', -23.10346, -134.97237),
(7030650, 7030621, 'PF', 'Gatavaké', 1, 'gatavake', -23.12025, -134.97939),
(7030672, 7030621, 'PF', 'Atituiti', 1, 'atituiti', -23.13156, -134.96775),
(7030674, 7030621, 'PF', 'Atirikigaro', 1, 'atirikigaro', -23.09355, -134.94498),
(7030675, 7030621, 'PF', 'Atiaoha', 1, 'atiaoha', -23.11971, -134.99214),
(7030679, 7030621, 'PF', 'Apeakava', 1, 'apeakava', -23.09699, -134.95801),
(7030682, 7030621, 'PF', 'Akaputu', 1, 'akaputu', -23.08041, -134.93652),
(7030840, 7030621, 'PF', 'Akamaru', 1, 'akamaru', -23.18108, -134.91462),
(7030852, 7030621, 'PF', 'Anganui', 1, 'anganui', -23.14506, -135.04116),
(7030862, 7030621, 'PF', 'Atihoi', 1, 'atihoi', -23.09436, -134.96574),
(7030863, 7030621, 'PF', 'Kairori', 1, 'kairori', -23.09118, -134.95271),
(7030864, 7030621, 'PF', 'Gataha', 1, 'gataha', -23.08873, -134.95175),
(7030867, 7030621, 'PF', 'Vaitinoua', 1, 'vaitinoua', -23.08135, -134.94553),
(7030868, 7030621, 'PF', 'Gahutu Tenohu', 1, 'gahutu-tenohu', -23.07924, -134.94193),
(7033042, 7034366, 'PF', 'Vaiuru', 1, 'vaiuru', -23.86977, -147.64573),
(7033061, 7034366, 'PF', 'Vaitoare', 1, 'vaitoare', -17.68333, -149.3),
(7033068, 7034364, 'PF', 'Vaitia', 1, 'vaitia', -16.43932, -152.26194),
(7033077, 7034364, 'PF', 'Vaitape', 1, 'vaitape', -16.50741, -151.74913),
(7033094, 7034365, 'PF', 'Vairao', 1, 'vairao', -17.78333, -149.28333),
(7033116, 7034365, 'PF', 'Vaipeu', 1, 'vaipeu', -17.48716, -149.83609),
(7033160, 7034365, 'PF', 'Vaihi', 1, 'vaihi', -17.77341, -149.30801),
(7033205, 7034364, 'PF', 'Uturoa', 1, 'uturoa', -16.72891, -151.44482),
(7033210, 7034365, 'PF', 'Uritutua', 1, 'uritutua', -17.80043, -149.29527),
(7033235, 7030621, 'PF', 'Tupana', 1, 'tupana', -16.1329, -146.33579),
(7033243, 7030621, 'PF', 'Tukuhora', 1, 'tukuhora', -17.34605, -145.51709),
(7033289, 7030621, 'PF', 'Toini', 1, 'toini', -16.36618, -144.35645),
(7033295, 7034365, 'PF', 'Tohautu', 1, 'tohautu', -17.76099, -149.31676),
(7033313, 7034365, 'PF', 'Toanoano', 1, 'toanoano', -17.86575, -149.21256),
(7033318, 7034365, 'PF', 'Toamara', 1, 'toamara', -17.72916, -149.29807),
(7033336, 7034365, 'PF', 'Tiripoa', 1, 'tiripoa', -17.71992, -149.30712),
(7033338, 7030621, 'PF', 'Tiputa', 1, 'tiputa', -14.97663, -147.62466),
(7033396, 7030621, 'PF', 'Tetamanu', 1, 'tetamanu', -16.5149, -145.45836),
(7033407, 7034365, 'PF', 'Teruafaroa', 1, 'teruafaroa', -17.67622, -149.3085),
(7033430, 7030621, 'PF', 'Tepukamaruia', 1, 'tepukamaruia', -14.16516, -141.27156),
(7033433, 7034366, 'PF', 'Tépuu', 1, 'tepuu', -23.39561, -149.51169),
(7033472, 7030621, 'PF', 'Temao', 1, 'temao', -15.82446, -148.27725),
(7033514, 7034365, 'PF', 'Teavaro', 1, 'teavaro', -17.5, -149.76667),
(7033540, 7030621, 'PF', 'Teana', 1, 'teana', -15.83049, -140.89562),
(7033543, 7034365, 'PF', 'Teahupoo', 1, 'teahupoo', -17.84645, -149.26682),
(7033557, 7034365, 'PF', 'Tautira', 1, 'tautira', -17.74744, -149.16123),
(7033566, 7034365, 'PF', 'Taunoa', 1, 'taunoa', -17.75139, -149.35602),
(7033571, 7034364, 'PF', 'Ta\'atoi', 1, 'ta-atoi', -16.45241, -152.27013),
(7033657, 7034365, 'PF', 'Taharoa', 1, 'taharoa', -17.74546, -149.20754),
(7033720, 7030621, 'PF', 'Rautini', 1, 'rautini', -15.36054, -146.62063),
(7033740, 7030621, 'PF', 'Raitahiti', 1, 'raitahiti', -15.673, -146.87635),
(7033742, 7034366, 'PF', 'Rairua', 1, 'rairua', -23.86959, -147.68565),
(7033743, 7034365, 'PF', 'Rairai', 1, 'rairai', -17.53333, -149.91667),
(7033779, 7034365, 'PF', 'Punaauia', 1, 'punaauia', -17.63333, -149.6),
(7033792, 7034365, 'PF', 'Pueu', 1, 'pueu', -17.73831, -149.22376),
(7033798, 7034365, 'PF', 'Pauiti', 1, 'pauiti', -17.65649, -149.31466),
(7033800, 7034364, 'PF', 'Puahua', 1, 'puahua', -16.7, -151.01667),
(7033804, 7034364, 'PF', 'Povaie', 1, 'povaie', -16.51594, -151.73437),
(7033806, 7030621, 'PF', 'Pouheva', 1, 'pouheva', -16.62238, -143.56938),
(7033838, 7034365, 'PF', 'Pirae', 1, 'pirae', -17.51667, -149.53333),
(7033844, 7034365, 'PF', 'Pihaena', 1, 'pihaena', -17.48822, -149.82699),
(7033846, 7034365, 'PF', 'Pihaa', 1, 'pihaa', -17.74384, -149.20341),
(7033867, 7034365, 'PF', 'Paui', 1, 'paui', -17.75377, -149.35078),
(7033871, 7034365, 'PF', 'Paturoa', 1, 'paturoa', -17.74808, -149.19904),
(7033872, 7034366, 'PF', 'Patu-Patu', 1, 'patu-patu', -23.35286, -149.48361),
(7033877, 7034364, 'PF', 'Patio', 1, 'patio', -16.58484, -151.49744),
(7033904, 7034365, 'PF', 'Paraeo', 1, 'paraeo', -17.73549, -149.2333),
(7033910, 7034365, 'PF', 'Papetoai', 1, 'papetoai', -17.49538, -149.87437),
(7033936, 7034365, 'PF', 'Papeete', 1, 'papeete', -17.53733, -149.5665),
(7033951, 7034365, 'PF', 'Papao', 1, 'papao', -17.75, -149.55),
(7033958, 7034365, 'PF', 'Paopao', 1, 'paopao', -17.51863, -149.82193),
(7033959, 7034365, 'PF', 'Paofai', 1, 'paofai', -17.81379, -149.12939),
(7033974, 7034365, 'PF', 'Pohua', 1, 'pohua', -17.73058, -149.28854),
(7033998, 7034365, 'PF', 'Paeau', 1, 'paeau', -17.51667, -149.91667),
(7034005, 7034365, 'PF', 'Paea', 1, 'paea', -17.68333, -149.58333),
(7034022, 7034365, 'PF', 'Otutara', 1, 'otutara', -17.77207, -149.41341),
(7034024, 7034365, 'PF', 'Utuofai', 1, 'utuofai', -17.66184, -149.31248),
(7034032, 7034365, 'PF', 'Otiaroa', 1, 'otiaroa', -17.76566, -149.40033),
(7034036, 7030621, 'PF', 'Otepa', 1, 'otepa', -18.10616, -140.9059),
(7034048, 7034365, 'PF', 'Oroihi', 1, 'oroihi', -17.79467, -149.29657),
(7034066, 7034365, 'PF', 'Opaura', 1, 'opaura', -17.56667, -149.85),
(7034118, 7034365, 'PF', 'Nutae', 1, 'nutae', -17.7401, -149.25387),
(7034132, 7030621, 'PF', 'Niutahi', 1, 'niutahi', -15.5712, -146.41226),
(7034135, 7034365, 'PF', 'Niumaa', 1, 'niumaa', -17.73576, -149.23649),
(7034154, 7034365, 'PF', 'Nairiri', 1, 'nairiri', -17.77106, -149.42697),
(7034188, 7034366, 'PF', 'Moerai', 1, 'moerai', -22.45133, -151.34191),
(7034216, 7034366, 'PF', 'Matotea', 1, 'matotea', -23.8754, -147.7001),
(7034219, 7034365, 'PF', 'Matiti', 1, 'matiti', -17.82428, -149.28791),
(7034233, 7034365, 'PF', 'Mataorio', 1, 'mataorio', -17.80453, -149.12709),
(7034307, 7034365, 'PF', 'Mahina', 1, 'mahina', -17.50648, -149.48899),
(7034309, 7034364, 'PF', 'Maeva', 1, 'maeva', -16.70037, -150.9888),
(7034311, 7034366, 'PF', 'Mahanatoa', 1, 'mahanatoa', -23.86166, -147.6747),
(7034331, 7034365, 'PF', 'Maaea', 1, 'maaea', -17.75865, -149.37872),
(7034378, 7034364, 'PF', 'Hurunanu', 1, 'hurunanu', -16.45382, -152.25638),
(7034387, 7034365, 'PF', 'Hutupu', 1, 'hutupu', -17.87652, -149.17962),
(7034434, 7034364, 'PF', 'Haapu', 1, 'haapu', -16.79217, -151.01091),
(7034438, 7034365, 'PF', 'Haapiti', 1, 'haapiti', -17.56352, -149.86905),
(7034451, 7034364, 'PF', 'Fitii', 1, 'fitii', -16.73535, -151.0327),
(7034496, 7034364, 'PF', 'Fare', 1, 'fare', -16.71085, -151.03455),
(7034497, 7034365, 'PF', 'Farauo', 1, 'farauo', -17.83449, -149.12921),
(7034508, 7030621, 'PF', 'Fakatopatere', 1, 'fakatopatere', -14.70977, -145.24673),
(7034528, 7034365, 'PF', 'Faatautia', 1, 'faatautia', -17.64101, -149.31156),
(7034548, 7034365, 'PF', 'Faone', 1, 'faone', -17.66917, -149.30919),
(7034561, 7034365, 'PF', 'Faaa', 1, 'faaa', -17.55, -149.6),
(7034588, 7034366, 'PF', 'Avera', 1, 'avera', -22.47814, -151.35126),
(7034590, 7030621, 'PF', 'Avatoru', 1, 'avatoru', -14.94172, -147.702),
(7034603, 7034366, 'PF', 'Hauti', 1, 'hauti', -22.48686, -151.32483),
(7034632, 7034365, 'PF', 'Ataiti', 1, 'ataiti', -17.75924, -149.38319),
(7034636, 7034365, 'PF', 'Arue', 1, 'arue', -17.51667, -149.5),
(7034654, 7034365, 'PF', 'Arahuta', 1, 'arahuta', -17.72649, -149.30056),
(7034684, 7034366, 'PF', 'Anua', 1, 'anua', -23.37782, -149.52664),
(7034688, 7034364, 'PF', 'Anau', 1, 'anau', -16.50148, -151.72135),
(7034741, 7034365, 'PF', 'Afareaitu', 1, 'afareaitu', -17.55, -149.78333),
(7036389, 7034365, 'PF', 'Vaïare', 1, 'vaiare', -17.52083, -149.77972),
(9690181, 7034365, 'PF', 'Maharepa', 1, 'maharepa', -17.48396, -149.80803),
(11063344, 7019991, 'PF', 'Taiohae', 1, 'taiohae', -8.91093, -140.09972),
(11554354, 7030621, 'PF', 'Moumu', 1, 'moumu', -15.83349, -148.24784),
(11554430, 7034364, 'PF', 'Tiva', 1, 'tiva', -16.641, -151.54423),
(11554431, 7034364, 'PF', 'Vaiaau', 1, 'vaiaau', -16.85964, -151.48018),
(11554432, 7034364, 'PF', 'Fetuna', 1, 'fetuna', -16.90893, -151.44126),
(11554433, 7034364, 'PF', 'Opoa', 1, 'opoa', -16.85021, -151.36288),
(11554434, 7034364, 'PF', 'Parea', 1, 'parea', -16.80822, -150.97968),
(11616973, 7034365, 'PF', 'Hauru', 1, 'hauru', -17.50729, -149.91377),
(13941901, 7034365, 'PF', 'Faie', 1, 'faie', -16.72969, -150.99548),
(14002820, 7034365, 'PF', 'Atiha', 1, 'atiha', -17.58475, -149.83965),
(14002821, 7034364, 'PF', 'Vai\'anae', 1, 'vai-anae', -17.58299, -149.84974),
(14002822, 7034365, 'PF', 'Nu\'urua', 1, 'nu-urua', -17.53598, -149.90141),
(14002823, 7034365, 'PF', 'Paevaeva', 1, 'paevaeva', -17.54453, -149.89017),
(14002923, 7034365, 'PF', 'Tiahura', 1, 'tiahura', -17.49291, -149.89705),
(14427337, 7034364, 'PF', 'Ha\'amene', 1, 'ha-amene', -16.63553, -151.49207),
(14427340, 7030621, 'PF', 'Hitianau', 1, 'hitianau', -16.70477, -145.35667),
(14592705, 7034365, 'PF', 'Pira\' e', 1, 'pira-e', -17.57743, -149.52397),
(14592707, 7034365, 'PF', 'Pape\' ete', 1, 'pape-ete', -17.55157, -149.5589),
(15042178, 7019991, 'PF', 'Hanapaaoa', 1, 'hanapaaoa', -9.74148, -138.96197),
(15042193, 7019991, 'PF', 'Hanamenu', 1, 'hanamenu', -9.76899, -139.14049),
(15042243, 7019991, 'PF', 'Tahauku', 1, 'tahauku', -9.80512, -139.02937),
(15042253, 7019991, 'PF', 'Hanaiapa', 1, 'hanaiapa', -9.72366, -139.00959),
(15042255, 7019991, 'PF', 'Hanatekuua', 1, 'hanatekuua', -9.70537, -138.99097),
(15042261, 7019991, 'PF', 'Anahi', 1, 'anahi', -9.74148, -138.93792),
(15042264, 7019991, 'PF', 'Eiaone', 1, 'eiaone', -9.74465, -138.90371),
(15042280, 7019991, 'PF', 'Hanaupe', 1, 'hanaupe', -9.79796, -138.90887),
(15042290, 7019991, 'PF', 'Puamau', 1, 'puamau', -9.76301, -138.88546),
(15042315, 7030621, 'PF', 'Hopiropiro', 1, 'hopiropiro', -15.22776, -147.75763),
(15042327, 7034365, 'PF', 'Paritautia', 1, 'paritautia', -17.64257, -149.31038),
(15042331, 7034365, 'PF', 'Pariauta', 1, 'pariauta', -17.65204, -149.31592),
(15042333, 7034365, 'PF', 'Fatau', 1, 'fatau', -17.73088, -149.3187),
(15042335, 7034365, 'PF', 'Patutera', 1, 'patutera', -17.74699, -149.34539),
(15042336, 7034365, 'PF', 'Vahitu', 1, 'vahitu', -17.7423, -149.3435),
(15042337, 7034365, 'PF', 'Aouatchora', 1, 'aouatchora', -17.73141, -149.29407),
(15042339, 7034365, 'PF', 'Papehere', 1, 'papehere', -17.82801, -149.28569),
(15042397, 7034364, 'PF', 'Faataoto', 1, 'faataoto', -16.67422, -151.45809),
(15042400, 7034364, 'PF', 'Motutiairi', 1, 'motutiairi', -16.65932, -151.45816),
(15042402, 7034364, 'PF', 'Para', 1, 'para', -16.64554, -151.44997),
(15042404, 7034364, 'PF', 'Aiai', 1, 'aiai', -16.63665, -151.44417),
(15042407, 7034364, 'PF', 'Faaha', 1, 'faaha', -16.62465, -151.45986),
(15042409, 7034364, 'PF', 'Faaopore', 1, 'faaopore', -16.62451, -151.43603),
(15042420, 7034364, 'PF', 'Hipu', 1, 'hipu', -16.5899, -151.46362),
(15042428, 7034364, 'PF', 'Pahure', 1, 'pahure', -16.58445, -151.48452),
(15042434, 7034364, 'PF', 'Teruaupai', 1, 'teruaupai', -16.61476, -151.54024),
(15042439, 7034364, 'PF', 'Hatupa', 1, 'hatupa', -16.64407, -151.53671),
(15042440, 7034364, 'PF', 'Murifenua', 1, 'murifenua', -16.60019, -151.54068),
(15042451, 7034364, 'PF', 'Vaipiti', 1, 'vaipiti', -16.65695, -151.49952),
(15042452, 7034364, 'PF', 'Patii', 1, 'patii', -16.66126, -151.5132),
(15042453, 7034364, 'PF', 'Apu', 1, 'apu', -16.67055, -151.48293),
(15042456, 7034364, 'PF', 'Tapuamu', 1, 'tapuamu', -16.61892, -151.54289),
(15042493, 7030621, 'PF', 'Mania', 1, 'mania', -17.45406, -145.47904),
(15042534, 7030621, 'PF', 'Tematahoa', 1, 'tematahoa', -17.48494, -145.39697),
(15042582, 7030621, 'PF', 'Otepipi', 1, 'otepipi', -17.40387, -145.52664),
(15042639, 7030621, 'PF', 'Temarie', 1, 'temarie', -17.34198, -145.56683),
(15042664, 7030621, 'PF', 'Paparara', 1, 'paparara', -15.50942, -145.45584),
(15043065, 7030621, 'PF', 'Tetauruga', 1, 'tetauruga', -16.61948, -143.55895),
(15043109, 7030621, 'PF', 'Teavaroa', 1, 'teavaroa', -14.47289, -145.03841),
(15043121, 7034364, 'PF', 'Opunu', 1, 'opunu', -16.8092, -151.48628),
(15043127, 7034364, 'PF', 'Faaini', 1, 'faaini', -16.72536, -151.03702),
(15043128, 7034364, 'PF', 'La Petite Ferme', 1, 'la-petite-ferme', -16.70014, -151.02886),
(15043139, 7034364, 'PF', 'Vaioa', 1, 'vaioa', -16.7689, -151.00824),
(15043140, 7034364, 'PF', 'Manu Meri', 1, 'manu-meri', -16.77876, -151.0228),
(15043158, 7034364, 'PF', 'Poutoru', 1, 'poutoru', -16.67367, -151.50191),
(15043161, 7034364, 'PF', 'Moanataa', 1, 'moanataa', -16.81323, -151.40479),
(15043166, 7034364, 'PF', 'Mauuraurii', 1, 'mauuraurii', -16.79504, -151.41303),
(15043167, 7034364, 'PF', 'Faremeho', 1, 'faremeho', -16.79004, -151.40986),
(15043169, 7034364, 'PF', 'Avera', 1, 'avera', -16.78576, -151.41423),
(15043178, 7034364, 'PF', 'Teroto', 1, 'teroto', -16.79682, -151.48993),
(15043180, 7034364, 'PF', 'Moroi', 1, 'moroi', -16.78498, -151.48585),
(15043182, 7034364, 'PF', 'Manuihi', 1, 'manuihi', -16.77871, -151.48898),
(15043185, 7034364, 'PF', 'Tairineneva', 1, 'tairineneva', -16.75096, -151.49003),
(15043188, 7034364, 'PF', 'Uturaerae', 1, 'uturaerae', -16.7383, -151.48408),
(15043193, 7034364, 'PF', 'Vaiurua', 1, 'vaiurua', -16.75136, -151.43358),
(15043201, 7034364, 'PF', 'Atitautu', 1, 'atitautu', -16.74289, -151.43815),
(15043214, 7034364, 'PF', 'Mana', 1, 'mana', -16.72423, -151.46482),
(15043247, 7034364, 'PF', 'Puohine', 1, 'puohine', -16.89063, -151.40022),
(15043256, 7034364, 'PF', 'Tautara', 1, 'tautara', -16.8992, -151.43299),
(15043305, 7034364, 'PF', 'Tehurui', 1, 'tehurui', -16.83827, -151.48266),
(15043308, 7034364, 'PF', 'Volande', 1, 'volande', -16.79576, -151.4061),
(15043309, 7034364, 'PF', 'Raiatea', 1, 'raiatea', -16.79791, -151.40198),
(15043310, 7034364, 'PF', 'Brotherson', 1, 'brotherson', -16.78617, -151.41317),
(15043311, 7034364, 'PF', 'Vaiapu', 1, 'vaiapu', -16.81357, -151.47544),
(15043313, 7034364, 'PF', 'Bali Haï', 1, 'bali-hai', -16.73946, -151.43631),
(15043335, 7030621, 'PF', 'Tereia', 1, 'tereia', -15.07353, -147.93561),
(15043450, 7030621, 'PF', 'Opipiné', 1, 'opipine', -17.44612, -143.45496),
(15043506, 7030621, 'PF', 'Vaitepaua', 1, 'vaitepaua', -15.82186, -148.2665),
(15043638, 7034364, 'PF', 'Vaiea', 1, 'vaiea', -16.4526, -152.25026),
(15043641, 7034364, 'PF', 'Pauma', 1, 'pauma', -16.44879, -152.24901),
(15043642, 7034364, 'PF', 'Petei', 1, 'petei', -16.44618, -152.24826),
(15043843, 7030621, 'PF', 'Taiore', 1, 'taiore', -14.94748, -148.05835),
(15043871, 7034366, 'PF', 'Haramea', 1, 'haramea', -23.38502, -149.5202),
(15043873, 7034366, 'PF', 'Tehaunatieva', 1, 'tehaunatieva', -23.39552, -149.48219),
(15043876, 7034366, 'PF', 'Taahuaia', 1, 'taahuaia', -23.34688, -149.45589);