REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('MV', 'Maldives', 'Maldives', 'maldives', '960', 'MVR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(4281843, 'MV', 'Vaavu Atholhu', 1, 'vaavu-atholhu'),
(4281881, 'MV', 'Thaa Atholhu', 1, 'thaa-atholhu'),
(4281892, 'MV', 'Shaviyani Atholhu', 1, 'shaviyani-atholhu'),
(4281893, 'MV', 'Seenu', 1, 'seenu'),
(4281918, 'MV', 'Raa Atoll', 1, 'raa-atoll'),
(4281937, 'MV', 'Noonu Atoll', 1, 'noonu-atoll'),
(4281945, 'MV', 'Gnyaviyani Atoll', 1, 'gnyaviyani-atoll'),
(4281985, 'MV', 'Meemu Atholhu', 1, 'meemu-atholhu'),
(4282096, 'MV', 'Lhaviyani Atholhu', 1, 'lhaviyani-atholhu'),
(4282101, 'MV', 'Laamu', 1, 'laamu'),
(4282208, 'MV', 'Kaafu Atoll', 1, 'kaafu-atoll'),
(4282293, 'MV', 'Haa Dhaalu Atholhu', 1, 'haa-dhaalu-atholhu'),
(4282294, 'MV', 'Haa Alifu Atholhu', 1, 'haa-alifu-atholhu'),
(4282328, 'MV', 'Gaafu Dhaalu Atoll', 1, 'gaafu-dhaalu-atoll'),
(4282329, 'MV', 'Gaafu Alif Atoll', 1, 'gaafu-alif-atoll'),
(4282393, 'MV', 'Faafu Atholhu', 1, 'faafu-atholhu'),
(4282447, 'MV', 'Dhaalu Atholhu', 1, 'dhaalu-atholhu'),
(4282478, 'MV', 'Baa Atholhu', 1, 'baa-atholhu'),
(4282497, 'MV', 'Northern Ari Atoll', 1, 'northern-ari-atoll'),
(4337624, 'MV', 'Male', 1, 'male'),
(13346475, 'MV', 'Southern Ari Atoll', 1, 'southern-ari-atoll');

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 
(4281980, 4281893, 'MV', 'Meedhoo', 1, 'meedhoo', -0.58333, 73.23333),
(4282027, 4282208, 'MV', 'Male', 1, 'male', 4.17521, 73.50916),
(4282256, 4281893, 'MV', 'Hithadhoo', 1, 'hithadhoo', -0.6, 73.08333),
(4282286, 4282293, 'MV', 'Hanimaadhoo', 1, 'hanimaadhoo', 6.76485, 73.17564),
(4282315, 4281893, 'MV', 'Gan', 1, 'gan', -0.7, 73.15),
(4337605, 13346475, 'MV', 'Mahibadhoo', 1, 'mahibadhoo', 3.75713, 72.96893),
(4337606, 4282478, 'MV', 'Eydhafushi', 1, 'eydhafushi', 5.10327, 73.07078),
(4337607, 4282447, 'MV', 'Kudahuvadhoo', 1, 'kudahuvadhoo', 2.67075, 72.89437),
(4337608, 4282393, 'MV', 'Magoodhoo', 1, 'magoodhoo', 3.07922, 72.96488),
(4337609, 4282329, 'MV', 'Viligili', 1, 'viligili', 0.75906, 73.43296),
(4337610, 4282328, 'MV', 'Thinadhoo', 1, 'thinadhoo', 0.5306, 72.99969),
(4337611, 4281945, 'MV', 'Fuvahmulah', 1, 'fuvahmulah', -0.29878, 73.42403),
(4337612, 4282294, 'MV', 'Dhidhdhoo', 1, 'dhidhdhoo', 6.88744, 73.11402),
(4337613, 4282293, 'MV', 'Kulhudhuffushi', 1, 'kulhudhuffushi', 6.62207, 73.06998),
(4337615, 4282101, 'MV', 'Hithadhoo', 1, 'hithadhoo', 1.79666, 73.38824),
(4337616, 4282096, 'MV', 'Naifaru', 1, 'naifaru', 5.44438, 73.36571),
(4337617, 4281985, 'MV', 'Muli', 1, 'muli', 2.91667, 73.56667),
(4337618, 4281937, 'MV', 'Manadhoo', 1, 'manadhoo', 5.76687, 73.4136),
(4337619, 4281918, 'MV', 'Ugoofaaru', 1, 'ugoofaaru', 5.66812, 73.03017),
(4337620, 4281892, 'MV', 'Funadhoo', 1, 'funadhoo', 6.15091, 73.29013),
(4337622, 4281881, 'MV', 'Veymandoo', 1, 'veymandoo', 2.18772, 73.09556),
(4337623, 4281843, 'MV', 'Felidhoo', 1, 'felidhoo', 3.47182, 73.54699),
(9692723, 13346475, 'MV', 'Nalaguraidhu', 1, 'nalaguraidhu', 3.48412, 72.79635),
(9692727, 4282393, 'MV', 'Filitheyo Island', 1, 'filitheyo-island', 3.21375, 73.03662),
(9930996, 4282208, 'MV', 'Hulhumale', 1, 'hulhumale', 4.21169, 73.54008),
(10648558, 4282101, 'MV', 'Gan', 1, 'gan', 1.92322, 73.54468),
(10874640, 4282101, 'MV', 'Kalhaidhoo', 1, 'kalhaidhoo', 1.98731, 73.53694),
(10874641, 4282101, 'MV', 'Fonadhoo', 1, 'fonadhoo', 1.83243, 73.50257),
(10874647, 4282101, 'MV', 'Kunahandhoo', 1, 'kunahandhoo', 1.78276, 73.36739),
(10874669, 4282101, 'MV', 'Maavah', 1, 'maavah', 1.8854, 73.24396),
(10909870, 4281893, 'MV', 'Hulhudhoo', 1, 'hulhudhoo', -0.59278, 73.22787),
(10910005, 4282478, 'MV', 'Dharavandhoo', 1, 'dharavandhoo', 5.15825, 73.13256),
(10910627, 4282447, 'MV', 'Buruni', 1, 'buruni', 2.55905, 73.10749),
(11199135, 4282208, 'MV', 'Nord Malé Atoll', 1, 'nord-male-atoll', 4.41667, 73.50013),
(11199141, 4282208, 'MV', 'South Malé Atoll', 1, 'south-male-atoll', 4, 73.41667),
(11516199, 4281893, 'MV', 'Hulumido', 1, 'hulumido', -0.59474, 73.2274),
(12179518, 4282497, 'MV', 'Rasdhoo', 1, 'rasdhoo', 4.26249, 72.99209),
(12886386, 4282478, 'MV', 'Goidhoo', 1, 'goidhoo', 4.87307, 72.99746),
(14103189, 4282497, 'MV', 'Dhigurah', 1, 'dhigurah', 3.53514, 72.92896),
(14103468, 4282208, 'MV', 'Guraidhoo', 1, 'guraidhoo', 3.90045, 73.46623),
(14550509, 4282294, 'MV', 'Hoarafushi', 1, 'hoarafushi', 6.98249, 72.89585),
(14694900, 13346475, 'MV', 'Maamigili', 1, 'maamigili', 3.6513, 72.81961),
(14694901, 4282393, 'MV', 'Bileiydhoo', 1, 'bileiydhoo', 3.11682, 72.98518),
(14694902, 4282393, 'MV', 'Feeali', 1, 'feeali', 3.26949, 73.00295),
(14694904, 4282393, 'MV', 'Dharanboodhoo', 1, 'dharanboodhoo', 3.0615, 72.92544),
(14777962, 4282208, 'MV', 'Maafushi', 1, 'maafushi', 3.94231, 73.4907),
(15088818, 4281937, 'MV', 'Maafaru', 1, 'maafaru', 5.83078, 73.47944),
(15196228, 4282328, 'MV', 'Vaadhoo', 1, 'vaadhoo', 0.22668, 73.27262);