REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('NR', 'Nauru', 'Nauru', 'nauru', '674', 'AUD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5110418, 'NR', 'Yaren', 1, 'yaren'),
(5110420, 'NR', 'Uaboe', 1, 'uaboe'),
(5110423, 'NR', 'Nibok', 1, 'nibok'),
(5110431, 'NR', 'Meneng', 1, 'meneng'),
(5110432, 'NR', 'Ijuw', 1, 'ijuw'),
(5110435, 'NR', 'Ewa', 1, 'ewa'),
(5110437, 'NR', 'Denigomodu', 1, 'denigomodu'),
(5110440, 'NR', 'Buada', 1, 'buada'),
(5110441, 'NR', 'Boe', 1, 'boe'),
(5110442, 'NR', 'Baiti', 1, 'baiti'),
(5110445, 'NR', 'Anibare', 1, 'anibare'),
(5110448, 'NR', 'Anetan', 1, 'anetan'),
(5110449, 'NR', 'Anabar', 1, 'anabar'),
(5110451, 'NR', 'Aiwo', 1, 'aiwo');

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 
(5110421, 5110420, 'NR', 'Uaboe', 1, 'uaboe', -0.51393, 166.92384),
(5110422, 5110448, 'NR', 'Ronave', 1, 'ronave', -0.50352, 166.9433),
(5110427, 5110442, 'NR', 'Baiti', 1, 'baiti', -0.50803, 166.92945),
(5110433, 5110432, 'NR', 'Ijuw', 1, 'ijuw', -0.521, 166.95813),
(5110444, 5110435, 'NR', 'Arubo', 1, 'arubo', -0.50489, 166.9323),
(5110450, 5110449, 'NR', 'Anabar', 1, 'anabar', -0.50845, 166.95326),
(10626461, 5110418, 'NR', 'Yaren', 1, 'yaren', -0.55085, 166.9252),
(10626485, 5110451, 'NR', 'Arijejen', 1, 'arijejen', -0.52545, 166.91247),
(10626489, 5110440, 'NR', 'Arenibek', 1, 'arenibek', -0.53307, 166.92378),
(14695309, 5110441, 'NR', 'Boe', 1, 'boe', -0.54098, 166.91305),
(14695310, 5110431, 'NR', 'Menen', 1, 'menen', -0.54539, 166.94871),
(14695311, 5110423, 'NR', 'Nibok', 1, 'nibok', -0.51757, 166.92056),
(15129637, 5110437, 'NR', 'Denigomodu', 1, 'denigomodu', -0.52574, 166.91259);