REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('MH', 'Marshall Islands', 'M̧ajeļ', 'marshall-islands', '692', 'USD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(10303491, 'MH', 'Ailinginae Atoll', 1, 'ailinginae-atoll'),
(10303492, 'MH', 'Ailinglaplap Atoll', 1, 'ailinglaplap-atoll'),
(10303493, 'MH', 'Ailuk Atoll', 1, 'ailuk-atoll'),
(10303494, 'MH', 'Arno Atoll', 1, 'arno-atoll'),
(10303495, 'MH', 'Aur Atoll', 1, 'aur-atoll'),
(10303496, 'MH', 'Bikar Atoll', 1, 'bikar-atoll'),
(10303497, 'MH', 'Bikini Atoll', 1, 'bikini-atoll'),
(10303498, 'MH', 'Ebon Atoll', 1, 'ebon-atoll'),
(10303499, 'MH', 'Enewetak Atoll', 1, 'enewetak-atoll'),
(10303500, 'MH', 'Erikub Atoll', 1, 'erikub-atoll'),
(10303501, 'MH', 'Jaluit Atoll', 1, 'jaluit-atoll'),
(10303502, 'MH', 'Kwajalein Atoll', 1, 'kwajalein-atoll'),
(10303503, 'MH', 'Lae Atoll', 1, 'lae-atoll'),
(10303504, 'MH', 'Likiep Atoll', 1, 'likiep-atoll'),
(10303505, 'MH', 'Majuro Atoll', 1, 'majuro-atoll'),
(10303506, 'MH', 'Maloelap Atoll', 1, 'maloelap-atoll'),
(10303507, 'MH', 'Mili Atoll', 1, 'mili-atoll'),
(10303508, 'MH', 'Namdrik Atoll', 1, 'namdrik-atoll'),
(10303509, 'MH', 'Namu Atoll', 1, 'namu-atoll'),
(10303510, 'MH', 'Rongelap Atoll', 1, 'rongelap-atoll'),
(10303511, 'MH', 'Rongrik Atoll', 1, 'rongrik-atoll'),
(10303512, 'MH', 'Taka Atoll', 1, 'taka-atoll'),
(10303513, 'MH', 'Bokak Atoll', 1, 'bokak-atoll'),
(10303514, 'MH', 'Ujae Atoll', 1, 'ujae-atoll'),
(10303515, 'MH', 'Ujelang', 1, 'ujelang'),
(10303516, 'MH', 'Utrik Atoll', 1, 'utrik-atoll'),
(10303517, 'MH', 'Wotho Atoll', 1, 'wotho-atoll'),
(10303518, 'MH', 'Wotje Atoll', 1, 'wotje-atoll'),
(10303519, 'MH', 'Jabat Island', 1, 'jabat-island'),
(10303520, 'MH', 'Jemo Island', 1, 'jemo-island'),
(10303521, 'MH', 'Kili Island', 1, 'kili-island'),
(10303522, 'MH', 'Lib Island', 1, 'lib-island'),
(10303523, 'MH', 'Mejit Island', 1, 'mejit-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 
(5079864, 10303494, 'MH', 'Warwir', 1, 'warwir', 7.00342, 171.59522),
(5079970, 10303494, 'MH', 'Lukwoj', 1, 'lukwoj', 7.01814, 171.58486),
(5080016, 10303505, 'MH', 'Rairik', 1, 'rairik', 7.07185, 171.31132),
(5080115, 10303504, 'MH', 'Likiep', 1, 'likiep', 9.82511, 169.31065),
(5080161, 10303494, 'MH', 'Langor', 1, 'langor', 7.11827, 171.9326),
(5080208, 10303505, 'MH', 'Woja', 1, 'woja', 7.10051, 171.09811),
(5080296, 10303494, 'MH', 'Kolalen', 1, 'kolalen', 7.0418, 171.78478),
(5080402, 10303492, 'MH', 'Jabwan', 1, 'jabwan', 7.27785, 168.79789),
(5080404, 10303498, 'MH', 'Japejiroi', 1, 'japejiroi', 4.60414, 168.76257),
(5080422, 10303501, 'MH', 'Jabor', 1, 'jabor', 5.92098, 169.64335),
(5080435, 10303494, 'MH', 'Ine', 1, 'ine', 6.98333, 171.7),
(5080486, 10303492, 'MH', 'Woja', 1, 'woja', 7.43896, 168.54954),
(5080498, 10303492, 'MH', 'Enuebing', 1, 'enuebing', 7.27912, 168.76966),
(5080555, 10303517, 'MH', 'Wotho', 1, 'wotho', 10.16715, 166.00913),
(5080556, 10303503, 'MH', 'Enerein', 1, 'enerein', 8.92128, 166.25698),
(5080636, 10303492, 'MH', 'Jeh', 1, 'jeh', 7.48784, 168.939),
(5080644, 10303507, 'MH', 'Lukunwod', 1, 'lukunwod', 6.01193, 172.06427),
(5080646, 10303498, 'MH', 'Chittoin', 1, 'chittoin', 4.57762, 168.70185),
(5080647, 10303498, 'MH', 'Chittakain', 1, 'chittakain', 4.58267, 168.73189),
(5080663, 10303506, 'MH', 'Wolot', 1, 'wolot', 8.76735, 171.17527),
(5080695, 10303507, 'MH', 'Kinnatkan', 1, 'kinnatkan', 6.07006, 171.89694),
(5080758, 10303492, 'MH', 'Medyil', 1, 'medyil', 7.52749, 168.94046),
(5080767, 10303503, 'MH', 'Boklulu', 1, 'boklulu', 8.92148, 166.21966),
(5080838, 10303507, 'MH', 'Enewa', 1, 'enewa', 6.02875, 172.02925),
(5080846, 10303507, 'MH', 'Bikoniing', 1, 'bikoniing', 6.22708, 171.80128),
(5080871, 10303495, 'MH', 'Bigen', 1, 'bigen', 8.35894, 171.04465),
(5080879, 10303495, 'MH', 'Tabal', 1, 'tabal', 8.3062, 171.15811),
(5080914, 10303507, 'MH', 'Jelbon', 1, 'jelbon', 5.97122, 172.11439),
(5080970, 10303493, 'MH', 'Ailuk', 1, 'ailuk', 10.21972, 169.97967),
(5080973, 10303507, 'MH', 'Kearkan', 1, 'kearkan', 6.07006, 171.87585),
(5081013, 10303507, 'MH', 'Enajet', 1, 'enajet', 6.03882, 171.94359),
(5081032, 10303507, 'MH', 'Anemaro', 1, 'anemaro', 6.06229, 172.10469),
(5113779, 10303505, 'MH', 'Majuro', 1, 'majuro', 7.08971, 171.38027),
(7038866, 10303492, 'MH', 'Airok', 1, 'airok', 7.27861, 168.82167),
(7038884, 10303505, 'MH', 'Ajeltake', 1, 'ajeltake', 7.07466, 171.17137),
(7039072, 10303506, 'MH', 'Jang', 1, 'jang', 8.8605, 171.06359),
(7039438, 10303492, 'MH', 'Buoj', 1, 'buoj', 7.28333, 168.75),
(7039813, 10303518, 'MH', 'Wodmej', 1, 'wodmej', 9.55124, 170.14938),
(7040079, 10303504, 'MH', 'Jebal', 1, 'jebal', 9.88997, 169.27241),
(7040199, 10303504, 'MH', 'Melang', 1, 'melang', 9.89631, 169.26009),
(7040607, 10303503, 'MH', 'Lae', 1, 'lae', 8.92488, 166.2655),
(7040698, 10303506, 'MH', 'Kaven', 1, 'kaven', 8.88829, 170.84092),
(7040744, 10303501, 'MH', 'Mejatto', 1, 'mejatto', 6.11177, 169.58416),
(9806225, 10303502, 'MH', 'Ebeye', 1, 'ebeye', 8.77889, 167.73806),
(10303892, 10303495, 'MH', 'Aur', 1, 'aur', 8.14897, 171.1699),
(10303925, 10303498, 'MH', 'Toka', 1, 'toka', 4.63623, 168.65237),
(10303926, 10303498, 'MH', 'Enekoion', 1, 'enekoion', 4.66835, 168.66818),
(10303933, 10303508, 'MH', 'Namdrik', 1, 'namdrik', 5.59561, 168.10666),
(10303978, 10303509, 'MH', 'Majkin', 1, 'majkin', 8.16073, 168.17858),
(10303979, 10303509, 'MH', 'Loen', 1, 'loen', 7.76296, 168.22731),
(10303980, 10303509, 'MH', 'Mae', 1, 'mae', 7.82588, 168.30471),
(10303996, 10303514, 'MH', 'Ujae', 1, 'ujae', 8.93338, 165.75723),
(10304002, 10303510, 'MH', 'New Rongelap', 1, 'new-rongelap', 11.1612, 166.89189),
(10304005, 10303516, 'MH', 'Utrik', 1, 'utrik', 11.22509, 169.84662),
(10304029, 10303492, 'MH', 'Jih', 1, 'jih', 7.59386, 168.96166),
(10304030, 10303494, 'MH', 'Bikarej', 1, 'bikarej', 7.23868, 171.63859),
(10304031, 10303494, 'MH', 'Ulien', 1, 'ulien', 7.12159, 171.56816),
(10304032, 10303494, 'MH', 'Arno', 1, 'arno', 7.06112, 171.55555),
(10304033, 10303494, 'MH', 'Malel', 1, 'malel', 7.07611, 171.85853),
(10304034, 10303494, 'MH', 'Kilange', 1, 'kilange', 7.08518, 171.87964),
(10304035, 10303494, 'MH', 'Tinak', 1, 'tinak', 7.08922, 171.90526),
(10304036, 10303498, 'MH', 'Enilok', 1, 'enilok', 4.61069, 168.66855),
(10304037, 10303498, 'MH', 'Meidj', 1, 'meidj', 4.6059, 168.68021),
(10304038, 10303519, 'MH', 'Jabat', 1, 'jabat', 7.75207, 168.97483),
(10304040, 10303522, 'MH', 'Lib', 1, 'lib', 8.31461, 167.37499),
(10304102, 10303507, 'MH', 'Likej', 1, 'likej', 6.01607, 172.05491),
(10304103, 10303507, 'MH', 'Wau', 1, 'wau', 6.09165, 172.10873),
(10304119, 10303501, 'MH', 'Inroj', 1, 'inroj', 6.0716, 169.60934),
(10304120, 10303501, 'MH', 'Ajejen', 1, 'ajejen', 6.0564, 169.67131),
(10304121, 10303501, 'MH', 'Imiej', 1, 'imiej', 6.01236, 169.72057),
(10304123, 10303501, 'MH', 'Jaluit', 1, 'jaluit', 5.79431, 169.59174),
(10304124, 10303501, 'MH', 'Ewo', 1, 'ewo', 5.83086, 169.54574),
(10304125, 10303501, 'MH', 'Menge', 1, 'menge', 5.84751, 169.52797),
(10304126, 10303501, 'MH', 'Mejrirok', 1, 'mejrirok', 5.86348, 169.52402),
(10304127, 10303501, 'MH', 'Pinglep', 1, 'pinglep', 5.95073, 169.43167),
(10304214, 10303506, 'MH', 'Airuk', 1, 'airuk', 8.49873, 171.18927),
(10304295, 10303505, 'MH', 'Jelter', 1, 'jelter', 7.21897, 171.06133),
(10304298, 10303505, 'MH', 'Laura', 1, 'laura', 7.14654, 171.03704),
(10304318, 10303505, 'MH', 'Rita', 1, 'rita', 7.12442, 171.35739),
(10304319, 10303505, 'MH', 'Arrak', 1, 'arrak', 7.12253, 171.05215),
(10304330, 10303505, 'MH', 'Ejit - relocation of Bikini inhabitants', 1, 'ejit-relocation-of-bikini-inhabitants', 7.12361, 171.34988),
(10304391, 10303499, 'MH', 'Enewetak', 1, 'enewetak', 11.3509, 162.34104),
(10304465, 10303502, 'MH', 'Mejatto', 1, 'mejatto', 9.31283, 166.87388),
(10304466, 10303502, 'MH', 'Ebadon', 1, 'ebadon', 9.3245, 166.83118),
(10304467, 10303502, 'MH', 'Ebaye', 1, 'ebaye', 8.77479, 167.73919),
(10304473, 10303502, 'MH', 'Enubuj', 1, 'enubuj', 8.7484, 167.68505),
(10304559, 10303502, 'MH', 'Ennylabegan local village', 1, 'ennylabegan-local-village', 8.79649, 167.62064),
(10304571, 10303502, 'MH', 'Loi', 1, 'loi', 8.80739, 167.73348),
(10306509, 10303521, 'MH', 'Kili', 1, 'kili', 5.64323, 169.12345),
(10306512, 10303498, 'MH', 'Ebon', 1, 'ebon', 4.58199, 168.69636),
(10306516, 10303507, 'MH', 'Mili', 1, 'mili', 6.0815, 171.73502),
(10306520, 10303510, 'MH', 'Rongelap', 1, 'rongelap', 11.16351, 166.89408),
(10306523, 10303523, 'MH', 'Mejit', 1, 'mejit', 10.27531, 170.86461),
(10306528, 10303518, 'MH', 'Wotje', 1, 'wotje', 9.45429, 170.23674);