REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('AS', 'American Samoa', 'American Samoa', 'american-samoa', '+1-684', 'USD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(8880873, 'AS', 'Western District', 1, 'western-district'),
(8881199, 'AS', 'Swains Island', 1, 'swains-island'),
(8881219, 'AS', 'Eastern District', 1, 'eastern-district'),
(8881436, 'AS', 'Manu\'a', 1, 'manu-a'),
(10309441, 'AS', 'Rose Island', 1, 'rose-island');

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 
(8880735, 8880873, 'AS', 'Sogi', 1, 'sogi', -14.35417, -170.78361),
(8880737, 8881219, 'AS', 'Utulei', 1, 'utulei', -14.28694, -170.68306),
(8880743, 8881219, 'AS', 'Aganoa', 1, 'aganoa', -14.27944, -170.57917),
(8880744, 8881219, 'AS', 'Afulei', 1, 'afulei', -14.28, -170.62389),
(8880749, 8880873, 'AS', 'Afao', 1, 'afao', -14.33667, -170.79917),
(8880751, 8880873, 'AS', 'A‘asufou', 1, 'a-asufou', -14.32028, -170.76389),
(8880752, 8880873, 'AS', 'Aasu', 1, 'aasu', -14.2975, -170.75833),
(8880755, 8881219, 'AS', 'Āfono', 1, 'afono', -14.26417, -170.65083),
(8880757, 8881219, 'AS', 'Alofau', 1, 'alofau', -14.27917, -170.60222),
(8880758, 8881436, 'AS', 'Alaufau', 1, 'alaufau', -14.17167, -169.67889),
(8880764, 8881219, 'AS', 'Alao', 1, 'alao', -14.2675, -170.56361),
(8880773, 8881219, 'AS', 'Ālega', 1, 'alega', -14.28528, -170.6375),
(8880781, 8880873, 'AS', 'Agugulu', 1, 'agugulu', -14.33556, -170.82167),
(8880784, 8880873, 'AS', 'A‘oloaufou', 1, 'a-oloaufou', -14.31972, -170.76778),
(8880791, 8880873, 'AS', '‘Āmanave', 1, 'amanave', -14.33, -170.82944),
(8880793, 8880873, 'AS', 'Amaluia', 1, 'amaluia', -14.33833, -170.79111),
(8880796, 8881219, 'AS', 'Amaua', 1, 'amaua', -14.27694, -170.62167),
(8880799, 8881219, 'AS', 'Āmouli', 1, 'amouli', -14.27806, -170.5825),
(8880808, 8881219, 'AS', 'Anasosopo', 1, 'anasosopo', -14.28861, -170.66278),
(8880812, 8880873, 'AS', 'Tafeta', 1, 'tafeta', -14.32556, -170.75167),
(8880813, 8881219, 'AS', 'Anua', 1, 'anua', -14.275, -170.68778),
(8880818, 8880873, 'AS', 'Asili', 1, 'asili', -14.33556, -170.79556),
(8880820, 8881219, 'AS', '‘Aoa', 1, 'aoa', -14.26556, -170.58389),
(8880826, 8881219, 'AS', 'Atu‘u', 1, 'atu-u', -14.27444, -170.68472),
(8880828, 8881219, 'AS', 'Aūa', 1, 'aua', -14.27611, -170.66389),
(8880829, 8881219, 'AS', 'Auasi', 1, 'auasi', -14.27667, -170.57444),
(8880833, 8880873, 'AS', 'Aoloau', 1, 'aoloau', -14.31972, -170.77),
(8880835, 8880873, 'AS', 'Auma', 1, 'auma', -14.34083, -170.78639),
(8880836, 8881219, 'AS', 'Aumi', 1, 'aumi', -14.29194, -170.64667),
(8880837, 8881219, 'AS', 'Aunu‘u', 1, 'aunu-u', -14.28861, -170.55917),
(8880844, 8881219, 'AS', 'Auto', 1, 'auto', -14.28306, -170.62694),
(8880849, 8881219, 'AS', 'Avau', 1, 'avau', -14.31083, -170.69278),
(8880859, 8881219, 'AS', 'Autapini', 1, 'autapini', -14.27889, -170.6975),
(8880860, 8881219, 'AS', 'Avaio', 1, 'avaio', -14.28528, -170.63083),
(8880881, 8881219, 'AS', 'Vatia', 1, 'vatia', -14.255, -170.67528),
(8880884, 8881219, 'AS', 'Vasaaiga', 1, 'vasaaiga', -14.30556, -170.68611),
(8880891, 8880873, 'AS', 'Vaitogi', 1, 'vaitogi', -14.35889, -170.73472),
(8880921, 8881219, 'AS', 'Faga‘itua', 1, 'faga-itua', -14.27194, -170.61194),
(8880931, 8881219, 'AS', 'Fagalea', 1, 'fagalea', -14.28917, -170.71861),
(8880944, 8880873, 'AS', 'Vailoatai', 1, 'vailoatai', -14.36111, -170.78222),
(8880946, 8880873, 'AS', 'Fagali‘i', 1, 'fagali-i', -14.31222, -170.82472),
(8880948, 8880873, 'AS', 'Fagamalo', 1, 'fagamalo', -14.30361, -170.80889),
(8880956, 8880873, 'AS', 'Vaiala', 1, 'vaiala', -14.34611, -170.77861),
(8880963, 8881219, 'AS', 'Tafananai', 1, 'tafananai', -14.2925, -170.66222),
(8880970, 8881219, 'AS', 'Utusia', 1, 'utusia', -14.27583, -170.61861),
(8880984, 8880873, 'AS', 'Se‘etaga', 1, 'se-etaga', -14.33056, -170.81056),
(8880998, 8881219, 'AS', 'Sa‘ilele', 1, 'sa-ilele', -14.26222, -170.59639),
(8881001, 8881219, 'AS', 'Satala', 1, 'satala', -14.27124, -170.69222),
(8881017, 8881436, 'AS', 'Fitiuta', 1, 'fitiuta', -14.21675, -169.42493),
(8881018, 8881219, 'AS', 'Si‘ufaga', 1, 'si-ufaga', -14.27917, -170.58528),
(8881026, 8881436, 'AS', 'Sili', 1, 'sili', -14.16944, -169.61889),
(8881043, 8881436, 'AS', 'Si‘ufaga', 1, 'si-ufaga', -14.24083, -169.51167),
(8881055, 8881219, 'AS', 'Utumea East', 1, 'utumea-east', -14.27583, -170.56833),
(8881057, 8880873, 'AS', 'Utumea West', 1, 'utumea-west', -14.33417, -170.81722),
(8881060, 8881219, 'AS', 'Utumea', 1, 'utumea', -14.27583, -170.56917),
(8881061, 8880873, 'AS', 'Utumea', 1, 'utumea', -14.33361, -170.81389),
(8881066, 8881219, 'AS', 'Utuloa', 1, 'utuloa', -14.26444, -170.61722),
(8881098, 8881219, 'AS', 'Tula', 1, 'tula', -14.25806, -170.56417),
(8881101, 8881436, 'AS', 'Faiava', 1, 'faiava', -14.16639, -169.61667),
(8881109, 8880873, 'AS', 'Tuaolo', 1, 'tuaolo', -14.31944, -170.75917),
(8881150, 8881199, 'AS', 'Taulaga', 1, 'taulaga', -11.05528, -171.08833),
(8881165, 8881436, 'AS', 'Ta`ū', 1, 'ta-u', -14.23361, -169.51444),
(8881168, 8880873, 'AS', 'Taputimu', 1, 'taputimu', -14.36028, -170.77306),
(8881169, 8880873, 'AS', 'Falili', 1, 'falili', -14.35639, -170.78),
(8881189, 8880873, 'AS', 'Tafunafou', 1, 'tafunafou', -14.32917, -170.73083),
(8881190, 8881219, 'AS', 'Tagapofu', 1, 'tagapofu', -14.30333, -170.6825),
(8881192, 8880873, 'AS', 'Tāfuna', 1, 'tafuna', -14.33583, -170.72),
(8881193, 8880873, 'AS', 'Puapua', 1, 'puapua', -14.34472, -170.7719),
(8881222, 8881219, 'AS', 'Faalefu', 1, 'faalefu', -14.26694, -170.58917),
(8881224, 8880873, 'AS', 'Faleniu', 1, 'faleniu', -14.3325, -170.74444),
(8881225, 8881219, 'AS', 'Faganeanea', 1, 'faganeanea', -14.30611, -170.68889),
(8881227, 8881436, 'AS', 'Faga', 1, 'faga', -14.21778, -169.455),
(8881231, 8881219, 'AS', 'Faga‘alu', 1, 'faga-alu', -14.29639, -170.68361),
(8881233, 8880873, 'AS', 'Fagamutu', 1, 'fagamutu', -14.33611, -170.805),
(8881236, 8880873, 'AS', 'Fagalele', 1, 'fagalele', -14.34667, -170.78444),
(8881241, 8881219, 'AS', 'Fagatogo', 1, 'fagatogo', -14.2825, -170.69),
(8881242, 8881219, 'AS', 'Fagatele', 1, 'fagatele', -14.29333, -170.72278),
(8881243, 8881219, 'AS', 'Fagasā', 1, 'fagasa', -14.29083, -170.71861),
(8881249, 8880873, 'AS', 'Failolo', 1, 'failolo', -14.33361, -170.82583),
(8881265, 8881219, 'AS', 'Fatumafuti', 1, 'fatumafuti', -14.30139, -170.67722),
(8881266, 8880873, 'AS', 'Fogāgogo', 1, 'fogagogo', -14.34278, -170.72222),
(8881270, 8881219, 'AS', 'Fogaau', 1, 'fogaau', -14.28194, -170.58806),
(8881273, 8880873, 'AS', 'Itū‘au', 1, 'itu-au', -14.34778, -170.76639),
(8881274, 8881436, 'AS', 'Fusi', 1, 'fusi', -14.24361, -169.51028),
(8881275, 8881219, 'AS', 'Fogausa', 1, 'fogausa', -14.28611, -170.60361),
(8881278, 8881219, 'AS', 'Fusi', 1, 'fusi', -14.27889, -170.70028),
(8881287, 8880873, 'AS', 'Ili‘ili', 1, 'ili-ili', -14.35167, -170.74694),
(8881294, 8881219, 'AS', 'Lalopua', 1, 'lalopua', -14.27528, -170.69528),
(8881300, 8881219, 'AS', 'Lauagae', 1, 'lauagae', -14.25444, -170.56861),
(8881334, 8881219, 'AS', 'Lauliituai', 1, 'lauliituai', -14.29167, -170.65278),
(8881342, 8881219, 'AS', 'Leloaloa', 1, 'leloaloa', -14.27222, -170.67806),
(8881347, 8880873, 'AS', 'Leone', 1, 'leone', -14.34389, -170.785),
(8881354, 8880873, 'AS', 'Lepine', 1, 'lepine', -14.32389, -170.72778),
(8881356, 8881219, 'AS', 'Lauliifou', 1, 'lauliifou', -14.29361, -170.65889),
(8881364, 8881219, 'AS', 'Lauli‘i', 1, 'lauli-i', -14.29222, -170.65306),
(8881368, 8881436, 'AS', 'Leusoali‘i', 1, 'leusoali-i', -14.22611, -169.42111),
(8881396, 8881436, 'AS', 'Lumā', 1, 'luma', -14.23167, -169.51472),
(8881401, 8880873, 'AS', 'Malaeloa/Ituau', 1, 'malaeloa-ituau', -14.34722, -170.76722),
(8881409, 8880873, 'AS', 'Malaeloa/Aitulagi', 1, 'malaeloa-aitulagi', -14.33861, -170.76784),
(8881410, 8880873, 'AS', 'Malaeimi', 1, 'malaeimi', -14.32278, -170.73389),
(8881411, 8881436, 'AS', 'Maia', 1, 'maia', -14.21944, -169.42833),
(8881413, 8880873, 'AS', 'Malaeloa', 1, 'malaeloa', -14.34417, -170.76722),
(8881423, 8881219, 'AS', 'Malaloa', 1, 'malaloa', -14.28083, -170.6925),
(8881425, 8881436, 'AS', 'Lalomoana', 1, 'lalomoana', -14.17056, -169.62167),
(8881430, 8880873, 'AS', 'Maloata', 1, 'maloata', -14.30944, -170.81472),
(8881433, 8880873, 'AS', 'Mapusaga', 1, 'mapusaga', -14.33, -170.74389),
(8881442, 8880873, 'AS', 'Mapusagafou', 1, 'mapusagafou', -14.33056, -170.75278),
(8881444, 8881219, 'AS', 'Masefau', 1, 'masefau', -14.25917, -170.63056),
(8881446, 8881219, 'AS', 'Masausi', 1, 'masausi', -14.26472, -170.60417),
(8881482, 8881219, 'AS', 'Matu‘u', 1, 'matu-u', -14.30361, -170.68389),
(8881496, 8880873, 'AS', 'Mesepa', 1, 'mesepa', -14.33139, -170.74444),
(8881533, 8880873, 'AS', 'Nua', 1, 'nua', -14.33306, -170.80583),
(8881535, 8881219, 'AS', 'Nu‘uuli', 1, 'nu-uuli', -14.31583, -170.6975),
(8881544, 8881436, 'AS', 'Ofu', 1, 'ofu', -14.17528, -169.6775),
(8881565, 8881219, 'AS', 'Ogefao', 1, 'ogefao', -14.25389, -170.57778),
(8881567, 8881436, 'AS', 'Olosega', 1, 'olosega', -14.18167, -169.6225),
(8881576, 8881219, 'AS', 'Pago Pago', 1, 'pago-pago', -14.27806, -170.7025),
(8881577, 8881219, 'AS', 'Oneoneloa', 1, 'oneoneloa', -14.31278, -170.69444),
(8881583, 8881219, 'AS', 'Onenoa', 1, 'onenoa', -14.25667, -170.57972),
(8881587, 8880873, 'AS', 'Ottoville', 1, 'ottoville', -14.33472, -170.72972),
(8881590, 8881219, 'AS', 'Pagai', 1, 'pagai', -14.275, -170.60528),
(8881602, 8880873, 'AS', 'Futiga', 1, 'futiga', -14.35333, -170.75417),
(8881622, 8880873, 'AS', 'Poloa', 1, 'poloa', -14.32167, -170.83278),
(8881623, 8880873, 'AS', 'Pava‘ia‘i', 1, 'pava-ia-i', -14.34083, -170.75083),
(14695139, 10309441, 'AS', 'Motu o Manu', 1, 'motu-o-manu', -14.54313, -168.16592);