REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('SB', 'Solomon Islands', 'Solomon Islands', 'solomon-islands', '677', 'SBD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5101556, 'SB', 'Western Province', 1, 'western-province'),
(5106552, 'SB', 'Malaita', 1, 'malaita'),
(5108262, 'SB', 'Isabel', 1, 'isabel'),
(5108831, 'SB', 'Guadalcanal', 1, 'guadalcanal'),
(5109495, 'SB', 'Central Province', 1, 'central-province'),
(5178472, 'SB', 'Temotu', 1, 'temotu'),
(5178730, 'SB', 'Makira', 1, 'makira'),
(10280292, 'SB', 'Choiseul', 1, 'choiseul'),
(10280293, 'SB', 'Rennell and Bellona', 1, 'rennell-and-bellona'),
(12259067, 'SB', 'Honiara', 1, 'honiara');

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 
(5102047, 5108831, 'SB', 'Vatukulau', 1, 'vatukulau', -9.81611, 160.12149),
(5102126, 10280292, 'SB', 'Vanggoso', 1, 'vanggoso', -7.06667, 156.83333),
(5102175, 5108831, 'SB', 'Valasi', 1, 'valasi', -9.65799, 160.53575),
(5102384, 5109495, 'SB', 'Tulagi', 1, 'tulagi', -9.10306, 160.15056),
(5102779, 10280292, 'SB', 'Taro’a', 1, 'taro-a', -9.22389, 161.2013),
(5103003, 5108831, 'SB', 'Talise', 1, 'talise', -8.47022, 159.62724),
(5103434, 5178730, 'SB', 'Sioduru', 1, 'sioduru', -9.77783, 161.9759),
(5103640, 10280292, 'SB', 'Sarelata', 1, 'sarelata', -7.08424, 157.01665),
(5104463, 5108831, 'SB', 'Paripao', 1, 'paripao', -9.54223, 160.3666),
(5104863, 5101556, 'SB', 'Noro', 1, 'noro', -8.22274, 157.19978),
(5105631, 5108831, 'SB', 'Moli', 1, 'moli', -9.72746, 161.98976),
(5105807, 5109495, 'SB', 'Mboromole', 1, 'mboromole', -9.06644, 160.29907),
(5106033, 10280292, 'SB', 'Mbatongo', 1, 'mbatongo', -6.99001, 157.07196),
(5106543, 5108831, 'SB', 'Malango', 1, 'malango', -9.69523, 159.71734),
(5106750, 5108831, 'SB', 'Longgu', 1, 'longgu', -9.66091, 160.65768),
(5106878, 5108831, 'SB', 'Lenggakiki', 1, 'lenggakiki', -9.436, 159.94661),
(5107599, 5108831, 'SB', 'Kolokarako', 1, 'kolokarako', -9.63333, 160.38333),
(5108502, 12259067, 'SB', 'Honiara', 1, 'honiara', -9.43333, 159.95),
(5108684, 5109495, 'SB', 'Hanuvaivine', 1, 'hanuvaivine', -9.09491, 160.30949),
(5108857, 5101556, 'SB', 'Gizo', 1, 'gizo', -8.10303, 156.84186),
(5108984, 5109495, 'SB', 'Ghairavu', 1, 'ghairavu', -9.10817, 160.285),
(5109528, 5108262, 'SB', 'Buala', 1, 'buala', -8.14497, 159.59212),
(5109676, 5108831, 'SB', 'Avuavu', 1, 'avuavu', -9.84389, 160.37998),
(5109701, 5106552, 'SB', 'Auki', 1, 'auki', -8.76778, 160.69778),
(5109807, 5108831, 'SB', 'Aola', 1, 'aola', -9.53487, 160.48788),
(5109972, 5106552, 'SB', 'Afutara', 1, 'afutara', -9.19216, 160.95018),
(5178448, 10280293, 'SB', '’Uvea', 1, 'uvea', -11.53333, 159.96667),
(5178451, 5178730, 'SB', 'Umara Village', 1, 'umara-village', -10.24812, 161.70658),
(5178456, 10280293, 'SB', 'Tuhungganggo', 1, 'tuhungganggo', -11.74841, 160.41109),
(5178500, 5178730, 'SB', 'Su’ena', 1, 'su-ena', -10.2205, 161.733),
(5178585, 10280293, 'SB', 'Niupani', 1, 'niupani', -11.72301, 160.41973),
(5178692, 10280293, 'SB', 'Manupisu', 1, 'manupisu', -11.67246, 160.40812),
(5178693, 5178472, 'SB', 'Manuopo', 1, 'manuopo', -10.28333, 166.25),
(5178747, 10280293, 'SB', 'Lavanggu', 1, 'lavanggu', -11.65602, 160.28016),
(5178750, 5178472, 'SB', 'Lata', 1, 'lata', -10.725, 165.79722),
(5178753, 5178730, 'SB', 'Kirakira', 1, 'kirakira', -10.45442, 161.92045),
(5178758, 10280293, 'SB', 'Kanggava', 1, 'kanggava', -11.68535, 160.31868),
(5178760, 10280293, 'SB', 'Kanava’eha', 1, 'kanava-eha', -11.62481, 160.16219),
(5178794, 10280293, 'SB', 'Tigoa', 1, 'tigoa', -11.5521, 160.06514),
(5178883, 5178730, 'SB', 'Ahi’a', 1, 'ahi-a', -10.22307, 161.70901),
(5178885, 10280293, 'SB', 'Ahanga', 1, 'ahanga', -11.83381, 160.65594),
(5206972, 5178730, 'SB', 'Di’una', 1, 'di-una', -10.34536, 161.31585),
(5206976, 5178730, 'SB', 'Mwamwako', 1, 'mwamwako', -10.88333, 162.45),
(11425456, 5101556, 'SB', 'Motusuata', 1, 'motusuata', -8.298, 156.532),
(11440207, 10280293, 'SB', 'Te’Nggano', 1, 'te-nggano', -11.7677, 160.41825),
(12781024, 5101556, 'SB', 'Mengge', 1, 'mengge', -8.27618, 156.5323),
(12781025, 5101556, 'SB', 'Ove', 1, 'ove', -8.30403, 156.53282),
(12794241, 5178730, 'SB', 'Pore Village', 1, 'pore-village', -10.24182, 161.70721),
(13227007, 5178730, 'SB', 'Moli Village', 1, 'moli-village', -9.72767, 161.98774),
(14669525, 5101556, 'SB', 'Ringgi Cove', 1, 'ringgi-cove', -8.1137, 157.12904),
(14874061, 5178472, 'SB', 'Banie', 1, 'banie', -11.64987, 166.90006);