REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('BN', 'Brunei', 'Negara Brunei Darussalam', 'brunei', '673', 'BND');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(4820068, 'BN', 'Tutong', 1, 'tutong'),
(4820106, 'BN', 'Temburong', 1, 'temburong'),
(4820818, 'BN', 'Brunei-Muara District', 1, 'brunei-muara-district'),
(4820869, 'BN', 'Belait', 1, 'belait');

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 
(4820071, 4820068, 'BN', 'Tutong', 1, 'tutong', 4.80278, 114.64917),
(4820159, 4820869, 'BN', 'Sukang', 1, 'sukang', 4.31667, 114.61667),
(4820187, 4820869, 'BN', 'Seria', 1, 'seria', 4.60637, 114.32476),
(4820386, 4820869, 'BN', 'Melilas', 1, 'melilas', 4.23333, 114.66667),
(4820474, 4820869, 'BN', 'Labi', 1, 'labi', 4.38333, 114.43333),
(4820491, 4820869, 'BN', 'Kuala Belait', 1, 'kuala-belait', 4.58361, 114.2312),
(4820492, 4820869, 'BN', 'Kuala Balai', 1, 'kuala-balai', 4.45, 114.31667),
(4820538, 4820068, 'BN', 'Kampong Ukong', 1, 'kampong-ukong', 4.66667, 114.63333),
(4820545, 4820068, 'BN', 'Kampong Telisai', 1, 'kampong-telisai', 4.73558, 114.56324),
(4820551, 4820068, 'BN', 'Kampong Tanjong Maya', 1, 'kampong-tanjong-maya', 4.75, 114.66667),
(4820557, 4820869, 'BN', 'Sungai Liang', 1, 'sungai-liang', 4.67747, 114.49587),
(4820560, 4820818, 'BN', 'Sungai Hanching', 1, 'sungai-hanching', 4.96806, 114.97753),
(4820566, 4820818, 'BN', 'Subok', 1, 'subok', 4.89311, 114.96588),
(4820574, 4820818, 'BN', 'Serasa', 1, 'serasa', 5.01761, 115.05798),
(4820582, 4820818, 'BN', 'Salambigar', 1, 'salambigar', 4.97877, 114.9878),
(4820590, 4820068, 'BN', 'Rambai', 1, 'rambai', 4.63882, 114.65148),
(4820627, 4820068, 'BN', 'Pad Nunok', 1, 'pad-nunok', 4.71749, 114.72825),
(4820635, 4820818, 'BN', 'Mentiri', 1, 'mentiri', 4.97058, 115.02078),
(4820640, 4820818, 'BN', 'Kampong Lupak Luas', 1, 'kampong-lupak-luas', 4.86972, 114.94047),
(4820644, 4820068, 'BN', 'Lubok Pulau', 1, 'lubok-pulau', 4.76403, 114.66356),
(4820645, 4820068, 'BN', 'Kampong Luagan Dudok', 1, 'kampong-luagan-dudok', 4.81734, 114.72979),
(4820651, 4820068, 'BN', 'Layong', 1, 'layong', 4.68895, 114.67753),
(4820652, 4820068, 'BN', 'Lamunin', 1, 'lamunin', 4.6816, 114.71537),
(4820653, 4820818, 'BN', 'Kampong Lambak A', 1, 'kampong-lambak-a', 4.96611, 114.94296),
(4820657, 4820068, 'BN', 'Kampong Kuala Tutong', 1, 'kampong-kuala-tutong', 4.78333, 114.6),
(4820658, 4820068, 'BN', 'Kuala Abang', 1, 'kuala-abang', 4.70108, 114.67683),
(4820661, 4820818, 'BN', 'Kiulap', 1, 'kiulap', 4.89707, 114.92692),
(4820662, 4820068, 'BN', 'Kampong Kiudang', 1, 'kampong-kiudang', 4.75, 114.73333),
(4820663, 4820818, 'BN', 'Kiarong', 1, 'kiarong', 4.89462, 114.91855),
(4820665, 4820068, 'BN', 'Kampong Keriam', 1, 'kampong-keriam', 4.81603, 114.6941),
(4820676, 4820818, 'BN', 'Kapok', 1, 'kapok', 5.02447, 115.04664),
(4820679, 4820818, 'BN', 'Junjongan', 1, 'junjongan', 4.81032, 114.85343),
(4820680, 4820818, 'BN', 'Kampong Jerudong', 1, 'kampong-jerudong', 4.95, 114.85),
(4820684, 4820818, 'BN', 'Kampong Gadong', 1, 'kampong-gadong', 4.91667, 114.91667),
(4820687, 4820068, 'BN', 'Kampong Danau', 1, 'kampong-danau', 4.76667, 114.58333),
(4820693, 4820068, 'BN', 'Bukit Sulang', 1, 'bukit-sulang', 4.65826, 114.73664),
(4820694, 4820068, 'BN', 'Bukit Panggal', 1, 'bukit-panggal', 4.82774, 114.72628),
(4820710, 4820818, 'BN', 'Kampong Berakas', 1, 'kampong-berakas', 4.94794, 114.93583),
(4820720, 4820818, 'BN', 'Batong', 1, 'batong', 4.81992, 114.81663),
(4820721, 4820106, 'BN', 'Kampong Batang Duri', 1, 'kampong-batang-duri', 4.56667, 115.13333),
(4820730, 4820106, 'BN', 'Kampong Amo', 1, 'kampong-amo', 4.61667, 115.1),
(4820892, 4820106, 'BN', 'Batu Apoi', 1, 'batu-apoi', 4.7, 115.1),
(4820903, 4820106, 'BN', 'Bangar', 1, 'bangar', 4.70861, 115.07167),
(4820906, 4820818, 'BN', 'Bandar Seri Begawan', 1, 'bandar-seri-begawan', 4.89035, 114.94006),
(14791883, 4820818, 'BN', 'Masin', 1, 'masin', 4.8375, 114.84472),
(14807073, 4820818, 'BN', 'Kulapis', 1, 'kulapis', 4.85045, 114.82322);