REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('TV', 'Tuvalu', 'Tuvalu', 'tuvalu', '688', 'AUD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5110341, 'TV', 'Nui', 1, 'nui'),
(5110345, 'TV', 'Nanumea', 1, 'nanumea'),
(5110384, 'TV', 'Funafuti', 1, 'funafuti'),
(10601979, 'TV', 'Niutao', 1, 'niutao'),
(10601980, 'TV', 'Nanumanga', 1, 'nanumanga'),
(10601981, 'TV', 'Vaitupu', 1, 'vaitupu'),
(10601982, 'TV', 'Nukufetau', 1, 'nukufetau'),
(10601983, 'TV', 'Nukulaelae', 1, 'nukulaelae');

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 
(5110292, 10601981, 'TV', 'Tumaseu Village', 1, 'tumaseu-village', -7.48784, 178.67942),
(5110302, 10601980, 'TV', 'Toga Village', 1, 'toga-village', -6.28764, 176.31472),
(5110322, 5110341, 'TV', 'Tanrake Village', 1, 'tanrake-village', -7.24562, 177.14511),
(5110349, 10601981, 'TV', 'Temotu Village', 1, 'temotu-village', -7.46168, 178.66748),
(5110368, 5110384, 'TV', 'Funafala Village', 1, 'funafala-village', -8.62975, 179.10066),
(5110377, 10601979, 'TV', 'Kulia Village', 1, 'kulia-village', -6.10819, 177.33393),
(5110380, 5110384, 'TV', 'Amatuku Village', 1, 'amatuku-village', -8.4379, 179.17031),
(5110394, 5110384, 'TV', 'Funafuti', 1, 'funafuti', -8.52425, 179.19417),
(5110396, 5110384, 'TV', 'Tekavatoetoe Village', 1, 'tekavatoetoe-village', -8.53493, 179.18554),
(5110415, 10601981, 'TV', 'Asau Village', 1, 'asau-village', -7.49026, 178.68016),
(10601977, 5110384, 'TV', 'Vaiaku Village', 1, 'vaiaku-village', -8.52544, 179.1941),
(10602047, 10601979, 'TV', 'Niulakita', 1, 'niulakita', -10.791, 179.4667),
(10602153, 10601983, 'TV', 'Nukualofa Village', 1, 'nukualofa-village', -9.37058, 179.80785),
(10602154, 10601983, 'TV', 'Pepesala Village', 1, 'pepesala-village', -9.37322, 179.80917),
(10602166, 5110345, 'TV', 'Lolua Village', 1, 'lolua-village', -5.67398, 176.11515),
(10602179, 5110345, 'TV', 'Hauma Village', 1, 'hauma-village', -5.67586, 176.11693),
(10602180, 10601980, 'TV', 'Tokelau Village', 1, 'tokelau-village', -6.28536, 176.31534),
(10602201, 10601979, 'TV', 'Teava Village', 1, 'teava-village', -6.11005, 177.33524),
(10602220, 5110341, 'TV', 'Meang Village', 1, 'meang-village', -7.20592, 177.15025),
(10602271, 10601981, 'TV', 'Motufoua School', 1, 'motufoua-school', -7.48996, 178.69256),
(10602373, 10601982, 'TV', 'Savave Village', 1, 'savave-village', -8.02731, 178.31351),
(10602506, 5110384, 'TV', 'Alapi Village', 1, 'alapi-village', -8.52074, 179.1968),
(10602507, 5110384, 'TV', 'Senala Village', 1, 'senala-village', -8.5174, 179.19829),
(10602508, 5110384, 'TV', 'Fakaifou Village', 1, 'fakaifou-village', -8.51758, 179.20094),
(10602533, 5110384, 'TV', 'Lofeagai Village', 1, 'lofeagai-village', -8.48103, 179.19233),
(10602537, 5110384, 'TV', 'Teone Village', 1, 'teone-village', -8.49922, 179.19502);