REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('DJ', 'Djibouti', 'Djibouti', 'djibouti', '253', 'DJF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(3220781, 'DJ', 'Tadjourah', 1, 'tadjourah'),
(3221525, 'DJ', 'Obock', 1, 'obock'),
(3223818, 'DJ', 'Djibouti', 1, 'djibouti'),
(3223889, 'DJ', 'Dikhil', 1, 'dikhil'),
(3225282, 'DJ', 'Ali Sabieh', 1, 'ali-sabieh'),
(3449265, 'DJ', 'Arta', 1, 'arta');

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 
(3220552, 3223889, 'DJ', 'Yoboki', 1, 'yoboki', 11.51139, 42.10639),
(3220604, 3223818, 'DJ', 'Ouê‘a', 1, 'oue-a', 11.50306, 42.85528),
(3220750, 3223889, 'DJ', 'Tew‘o', 1, 'tew-o', 11.43833, 42.05722),
(3220782, 3220781, 'DJ', 'Tadjourah', 1, 'tadjourah', 11.78778, 42.88222),
(3220931, 3221525, 'DJ', 'Sêdorre', 1, 'sedorre', 12.36216, 43.18898),
(3221103, 3220781, 'DJ', 'Randa', 1, 'randa', 11.84694, 42.66056),
(3221527, 3221525, 'DJ', 'Obock', 1, 'obock', 11.96693, 43.28835),
(3221629, 3220781, 'DJ', 'Moudo', 1, 'moudo', 12.3, 42.43333),
(3221708, 3221525, 'DJ', 'Médého', 1, 'medeho', 11.97306, 43.02611),
(3221915, 3223818, 'DJ', 'Loyada', 1, 'loyada', 11.46111, 43.25278),
(3222171, 3221525, 'DJ', 'Khôr Angar', 1, 'khor-angar', 12.38725, 43.3347),
(3222570, 3223818, 'DJ', 'Ambouli', 1, 'ambouli', 11.56944, 43.13667),
(3222596, 3225282, 'DJ', 'Holhol', 1, 'holhol', 11.31028, 42.92944),
(3223011, 3225282, 'DJ', 'Goubéto', 1, 'goubeto', 11.41667, 42.98333),
(3223773, 3220781, 'DJ', 'Dorra', 1, 'dorra', 12.15028, 42.47624),
(3223817, 3223818, 'DJ', 'Djibouti', 1, 'djibouti', 11.58901, 43.14503),
(3223890, 3223889, 'DJ', 'Dikhil', 1, 'dikhil', 11.10454, 42.36971),
(3224152, 3225282, 'DJ', 'Ḏânan', 1, 'danan', 11.18333, 42.93333),
(3224319, 3221525, 'DJ', 'Dadda’to', 1, 'dadda-to', 12.37933, 42.71048),
(3224643, 3220781, 'DJ', 'Bankoualé', 1, 'bankouale', 11.82278, 42.67361),
(3224660, 3220781, 'DJ', 'Balho', 1, 'balho', 12.05786, 42.19547),
(3224906, 3223889, 'DJ', '‘As ‘Êla', 1, 'as-ela', 11.00361, 42.1025),
(3225037, 3449265, 'DJ', 'Arta', 1, 'arta', 11.52639, 42.85194),
(3225284, 3225282, 'DJ', '\'Ali Sabieh', 1, 'ali-sabieh', 11.15583, 42.7125),
(3225310, 3225282, 'DJ', '‘Ali ‘Addé', 1, 'ali-adde', 11.13333, 42.88583),
(3225398, 3220781, 'DJ', 'Airolaf', 1, 'airolaf', 11.77028, 42.65194),
(3398086, 3220781, 'DJ', 'Ouê‘a', 1, 'oue-a', 11.69056, 42.68667),
(3398121, 3220781, 'DJ', 'Ambabbo', 1, 'ambabbo', 11.75111, 42.81444),
(3398991, 3221525, 'DJ', 'Bissîdiro', 1, 'bissidiro', 12.645, 42.97333),
(3400462, 3221525, 'DJ', 'Alaïli Ḏaḏḏa‘', 1, 'alaili-dadda', 12.42167, 42.89556),
(3404197, 3223818, 'DJ', 'Damêrdjôg', 1, 'damerdjog', 11.48556, 43.18722),
(3404235, 3225282, 'DJ', 'Goubétto', 1, 'goubetto', 11.42389, 43.00028),
(3408698, 3223889, 'DJ', 'Gâlâfi', 1, 'galafi', 11.71583, 41.83611),
(3409763, 3225282, 'DJ', 'Ḏigri', 1, 'digri', 11.2975, 42.85333),
(3443309, 3221525, 'DJ', 'Gaherré', 1, 'gaherre', 12.28694, 43.35556),
(3448209, 3221525, 'DJ', 'Moulhoulé', 1, 'moulhoule', 12.59167, 43.2),
(3448210, 3223889, 'DJ', 'Koûta Boûyya', 1, 'kouta-bouyya', 11.01611, 41.96194),
(10648070, 3223818, 'DJ', 'Balbala', 1, 'balbala', 11.56194, 43.10666),
(10828770, 3221525, 'DJ', 'Waddi', 1, 'waddi', 12.35444, 42.92639),
(10828775, 3223889, 'DJ', 'Gorabous', 1, 'gorabous', 11.30434, 42.21703),
(11346841, 3225282, 'DJ', 'Vasama', 1, 'vasama', 10.98914, 42.84125),
(11692932, 3223889, 'DJ', 'Mouloud', 1, 'mouloud', 11.16667, 42.5),
(15036312, 3225282, 'DJ', 'Chabelley', 1, 'chabelley', 11.4895, 43.07528),
(15041421, 3220781, 'DJ', 'Adailou', 1, 'adailou', 11.95186, 42.90535),
(15041422, 3225282, 'DJ', 'Ali Oune', 1, 'ali-oune', 11.39153, 43.1415),
(15041423, 3221525, 'DJ', 'Andali', 1, 'andali', 12.48402, 42.98668),
(15041424, 3220781, 'DJ', 'Adoyla', 1, 'adoyla', 11.9584, 42.64788),
(15041425, 3225282, 'DJ', 'Anaba', 1, 'anaba', 11.35271, 42.94184),
(15041426, 3225282, 'DJ', 'Assa Hougoud', 1, 'assa-hougoud', 11.38526, 42.82796),
(15041428, 3220781, 'DJ', 'Bouyya', 1, 'bouyya', 12.36799, 42.36343),
(15041429, 3223889, 'DJ', 'Koussour Koussour', 1, 'koussour-koussour', 11.52287, 42.40627),
(15041431, 3220781, 'DJ', 'Guirrari', 1, 'guirrari', 12.04898, 42.78536),
(15041433, 3221525, 'DJ', 'Fagal', 1, 'fagal', 12.45346, 43.30217),
(15041434, 3221525, 'DJ', 'Egahlou', 1, 'egahlou', 12.12484, 42.93739),
(15041435, 3223889, 'DJ', 'Doudoub Bolole', 1, 'doudoub-bolole', 11.21393, 42.65822),
(15041436, 3223889, 'DJ', 'Debne', 1, 'debne', 11.57356, 42.4021),
(15041437, 3225282, 'DJ', 'Dasbiyo', 1, 'dasbiyo', 11.25271, 42.79879),
(15041438, 3223889, 'DJ', 'Daoudaouga', 1, 'daoudaouga', 11.75829, 42.15362),
(15041439, 3223889, 'DJ', 'Dagguirou', 1, 'dagguirou', 11.54492, 42.11576),
(15041440, 3221525, 'DJ', 'La`assa', 1, 'la-assa', 12.36506, 43.14336),
(15041441, 3220781, 'DJ', 'Madgoul', 1, 'madgoul', 12.35495, 42.47629),
(15041442, 3220781, 'DJ', 'Malaho', 1, 'malaho', 12.09889, 42.20977),
(15041443, 3220781, 'DJ', 'Oued Ouea', 1, 'oued-ouea', 11.68004, 42.68989),
(15041444, 3221525, 'DJ', 'Ribta', 1, 'ribta', 12.45751, 42.84784);