REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('WS', 'Samoa', 'Samoa', 'samoa', '685', 'WST');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(7034910, 'WS', 'Vaisigano', 1, 'vaisigano'),
(7034943, 'WS', 'Va‘a-o-Fonoti', 1, 'va-a-o-fonoti'),
(7034977, 'WS', 'Tuamasaga', 1, 'tuamasaga'),
(7035046, 'WS', 'Satupa‘itea', 1, 'satupa-itea'),
(7035154, 'WS', 'Palauli', 1, 'palauli'),
(7035313, 'WS', 'Gagaifomauga', 1, 'gagaifomauga'),
(7035314, 'WS', 'Gaga‘emauga', 1, 'gaga-emauga'),
(7035383, 'WS', 'Fa‘asaleleaga', 1, 'fa-asaleleaga'),
(7035402, 'WS', 'Atua', 1, 'atua'),
(7035425, 'WS', 'Aiga-i-le-Tai', 1, 'aiga-i-le-tai'),
(7035434, 'WS', 'A\'ana', 1, 'a-ana');

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 
(7034896, 7035402, 'WS', 'Vavau', 1, 'vavau', -14.04268, -171.54855),
(7034903, 7034977, 'WS', 'Vaiusu', 1, 'vaiusu', -13.82678, -171.79333),
(7034912, 7034910, 'WS', 'Vaisala', 1, 'vaisala', -13.51439, -172.67522),
(7034913, 7035046, 'WS', 'Vaipu’a', 1, 'vaipu-a', -13.67783, -172.63375),
(7034917, 7034977, 'WS', 'Vaimoso', 1, 'vaimoso', -13.83655, -171.77713),
(7034924, 7034977, 'WS', 'Vailima', 1, 'vailima', -13.86417, -171.76126),
(7034930, 7034977, 'WS', 'Vaie’e', 1, 'vaie-e', -13.98811, -171.83095),
(7034938, 7035154, 'WS', 'Vailoa', 1, 'vailoa', -13.75551, -172.30698),
(7034962, 7034943, 'WS', 'Uafato', 1, 'uafato', -13.95202, -171.5154),
(7034967, 7034910, 'WS', 'Tufutafoe', 1, 'tufutafoe', -13.53073, -172.78963),
(7034971, 7035383, 'WS', 'Tuasivi', 1, 'tuasivi', -13.6676, -172.17559),
(7034995, 7034977, 'WS', 'Tanugamanono', 1, 'tanugamanono', -13.85099, -171.75921),
(7034998, 7035154, 'WS', 'Taga', 1, 'taga', -13.794, -172.5111),
(7034999, 7035154, 'WS', 'Tafua', 1, 'tafua', -13.7927, -172.2538),
(7035000, 7034977, 'WS', 'Tafitoala', 1, 'tafitoala', -14.00703, -171.81238),
(7035013, 7035402, 'WS', 'Solosolo', 1, 'solosolo', -13.87504, -171.64181),
(7035017, 7034910, 'WS', 'Siuvao', 1, 'siuvao', -13.56667, -172.66667),
(7035021, 7035402, 'WS', 'Si’uniu', 1, 'si-uniu', -14.02065, -171.61735),
(7035029, 7035154, 'WS', 'Sili', 1, 'sili', -13.75602, -172.37733),
(7035037, 7035434, 'WS', 'Savaia', 1, 'savaia', -13.95514, -171.95711),
(7035049, 7035046, 'WS', 'Satuiatua', 1, 'satuiatua', -13.70805, -172.60058),
(7035051, 7035046, 'WS', 'Satufia', 1, 'satufia', -13.77345, -172.32769),
(7035052, 7035314, 'WS', 'Sato’alepai', 1, 'sato-alepai', -13.44361, -172.34484),
(7035053, 7035402, 'WS', 'Satitoa', 1, 'satitoa', -14.0276, -171.43022),
(7035056, 7034910, 'WS', 'Sataua', 1, 'sataua', -13.51742, -172.69436),
(7035059, 7035434, 'WS', 'Satapuala', 1, 'satapuala', -13.83535, -171.97963),
(7035060, 7034977, 'WS', 'Sataoa', 1, 'sataoa', -13.98758, -171.86317),
(7035062, 7035313, 'WS', 'Sasina', 1, 'sasina', -13.46995, -172.4492),
(7035066, 7035383, 'WS', 'Sapapali’i', 1, 'sapapali-i', -13.68726, -172.1918),
(7035075, 7035434, 'WS', 'Samatau', 1, 'samatau', -13.89964, -172.05706),
(7035076, 7035046, 'WS', 'Samataitai', 1, 'samataitai', -13.64614, -172.66578),
(7035078, 7034943, 'WS', 'Samamea', 1, 'samamea', -13.93375, -171.53122),
(7035079, 7035314, 'WS', 'Samalaeulu', 1, 'samalaeulu', -13.50098, -172.30015),
(7035099, 7035046, 'WS', 'Sale’aula', 1, 'sale-aula', -13.44894, -172.33521),
(7035103, 7035402, 'WS', 'Saleapaga', 1, 'saleapaga', -14.04173, -171.50456),
(7035106, 7035402, 'WS', 'Salani', 1, 'salani', -14, -171.56667),
(7035108, 7035314, 'WS', 'Salamumu', 1, 'salamumu', -13.99813, -171.9219),
(7035111, 7035383, 'WS', 'Saipipi', 1, 'saipipi', -13.62921, -172.1979),
(7035113, 7035046, 'WS', 'Sagone', 1, 'sagone', -13.68733, -172.61864),
(7035118, 7035313, 'WS', 'Safotu', 1, 'safotu', -13.45132, -172.40177),
(7035120, 7035434, 'WS', 'Safa’atoa', 1, 'safa-atoa', -13.94202, -171.96578),
(7035121, 7035314, 'WS', 'Safa’i', 1, 'safa-i', -13.44654, -172.33971),
(7035123, 7035383, 'WS', 'Sa’asa’ai', 1, 'sa-asa-ai', -13.63714, -172.1942),
(7035130, 7035154, 'WS', 'Puleia', 1, 'puleia', -13.77614, -172.37761),
(7035135, 7035383, 'WS', 'Pu’apu’a', 1, 'pu-apu-a', -13.58996, -172.20984),
(7035137, 7035402, 'WS', 'Poutasi', 1, 'poutasi', -14.0295, -171.69275),
(7035141, 7035314, 'WS', 'Patamea', 1, 'patamea', -13.52463, -172.30678),
(7035150, 7034910, 'WS', 'Papa', 1, 'papa', -13.53077, -172.71516),
(7035174, 7035434, 'WS', 'Nofoali‘i', 1, 'nofoali-i', -13.8217, -171.95873),
(7035176, 7034910, 'WS', 'Neiafu', 1, 'neiafu', -13.56653, -172.75225),
(7035185, 7034943, 'WS', 'Musumusu', 1, 'musumusu', -13.9303, -171.55875),
(7035196, 7035425, 'WS', 'Mulifanua', 1, 'mulifanua', -13.83183, -172.03602),
(7035209, 7035313, 'WS', 'Matavai', 1, 'matavai', -14.03208, -171.64768),
(7035213, 7035402, 'WS', 'Matautu', 1, 'matautu', -14.03831, -171.67763),
(7035217, 7035402, 'WS', 'Matatufu', 1, 'matatufu', -14.04355, -171.58376),
(7035231, 7035313, 'WS', 'Manase', 1, 'manase', -13.44796, -172.37647),
(7035234, 7035314, 'WS', 'Malua', 1, 'malua', -13.79909, -171.9027),
(7035235, 7034977, 'WS', 'Malololelei', 1, 'malololelei', -13.90564, -171.77836),
(7035236, 7034977, 'WS', 'Malie', 1, 'malie', -13.80044, -171.8469),
(7035249, 7035402, 'WS', 'Lufilufi', 1, 'lufilufi', -13.87449, -171.59857),
(7035251, 7035402, 'WS', 'Lotofaga', 1, 'lotofaga', -14.04288, -171.57036),
(7035252, 7035402, 'WS', 'Lotofagā', 1, 'lotofaga', -13.97643, -171.85781),
(7035260, 7035434, 'WS', 'Leulumoega', 1, 'leulumoega', -13.82297, -171.96127),
(7035263, 7034977, 'WS', 'Letogo', 1, 'letogo', -13.85252, -171.72167),
(7035268, 7034977, 'WS', 'Lepea', 1, 'lepea', -13.83575, -171.79),
(7035273, 7035314, 'WS', 'Lelepa', 1, 'lelepa', -13.44544, -172.36047),
(7035300, 7035402, 'WS', 'Lalomanu', 1, 'lalomanu', -14.04454, -171.43925),
(7035301, 7035383, 'WS', 'Lalomalava', 1, 'lalomalava', -13.70178, -172.20038),
(7035304, 7035383, 'WS', 'Iva', 1, 'iva', -13.71019, -172.20324),
(7035310, 7035154, 'WS', 'Gataivai', 1, 'gataivai', -13.7736, -172.38802),
(7035324, 7035046, 'WS', 'Fogatuli', 1, 'fogatuli', -13.66146, -172.6465),
(7035325, 7035046, 'WS', 'Fogasavai’i', 1, 'fogasavai-i', -13.68026, -172.62672),
(7035326, 7035154, 'WS', 'Foailuga', 1, 'foailuga', -13.69666, -172.60924),
(7035327, 7035154, 'WS', 'Foailalo', 1, 'foailalo', -13.70226, -172.60453),
(7035335, 7035434, 'WS', 'Fasito‘outa', 1, 'fasito-outa', -13.81163, -171.94063),
(7035347, 7035402, 'WS', 'Faleapuna', 1, 'faleapuna', -13.87761, -171.59235),
(7035352, 7034910, 'WS', 'Falelima', 1, 'falelima', -13.59572, -172.72204),
(7035358, 7035402, 'WS', 'Falefa', 1, 'falefa', -13.88695, -171.58805),
(7035359, 7035434, 'WS', 'Faleatiu', 1, 'faleatiu', -13.82885, -171.97895),
(7035367, 7034910, 'WS', 'Faleālupo', 1, 'falealupo', -13.50103, -172.78768),
(7035371, 7035046, 'WS', 'Fai’a’ai', 1, 'fai-a-ai', -13.6703, -172.64112),
(7035372, 7035314, 'WS', 'Fagamalo', 1, 'fagamalo', -13.44219, -172.34901),
(7035381, 7035046, 'WS', 'Fagafau', 1, 'fagafau', -13.64026, -172.67023),
(7035397, 7035314, 'WS', 'Avao', 1, 'avao', -13.44883, -172.36249),
(7035400, 7034910, 'WS', 'Auala', 1, 'auala', -13.5167, -172.65245),
(7035413, 7034977, 'WS', 'Apia', 1, 'apia', -13.83333, -171.76666),
(7035414, 7035313, 'WS', 'A’opo', 1, 'a-opo', -13.53975, -172.51931),
(7035430, 7034977, 'WS', 'Afiamalu', 1, 'afiamalu', -13.91657, -171.71674),
(7035432, 7034977, 'WS', 'Afega', 1, 'afega', -13.79726, -171.85308),
(10106234, 7035425, 'WS', 'Manono-uta', 1, 'manono-uta', -13.89091, -172.06409),
(10106298, 7034977, 'WS', 'Lotopa', 1, 'lotopa', -13.8467, -171.78704),
(10106300, 7034977, 'WS', 'Pesega', 1, 'pesega', -13.83735, -171.78407),
(10106305, 7034977, 'WS', 'Lalovaea', 1, 'lalovaea', -13.83987, -171.76664),
(10106323, 7035425, 'WS', 'Lepuia’i', 1, 'lepuia-i', -13.85659, -172.11317),
(10106325, 7035425, 'WS', 'Apai', 1, 'apai', -13.84754, -172.11807),
(10106329, 7035425, 'WS', 'Salua', 1, 'salua', -13.84549, -172.10503),
(10106337, 7035046, 'WS', 'Vaega', 1, 'vaega', -13.77007, -172.32666),
(10106368, 7035383, 'WS', 'Fogapoā', 1, 'fogapoa', -13.67264, -172.17716),
(10106382, 7035046, 'WS', 'Samataiuta', 1, 'samataiuta', -13.64926, -172.65725),
(10106392, 7034910, 'WS', 'Falealupo-uta', 1, 'falealupo-uta', -13.53978, -172.73471),
(10106405, 7035313, 'WS', 'Faletagaloa', 1, 'faletagaloa', -13.46972, -172.42649),
(10106406, 7035313, 'WS', 'Lefagaoali’i', 1, 'lefagaoali-i', -13.46752, -172.41869),
(10106422, 7035314, 'WS', 'Mauga', 1, 'mauga', -13.47572, -172.31519),
(10106453, 7034910, 'WS', 'Matega', 1, 'matega', -13.61333, -172.69796),
(10106456, 7034910, 'WS', 'Asau', 1, 'asau', -13.51963, -172.63784),
(10106463, 7034977, 'WS', 'Vailele', 1, 'vailele', -13.84568, -171.72317),
(10109494, 7035313, 'WS', 'Safune', 1, 'safune', -13.47169, -172.42279),
(10669215, 7034977, 'WS', 'Lelata', 1, 'lelata', -13.84316, -171.75729);