REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('KM', 'Comoros', 'comoros', '269', 'Komori', 'KMF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002821, 'KM', 'Anjouan', 1, 'anjouan');

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 
(1065079, 1002821, 'KM', 'Adda-Douéni', 1, 'adda-doueni', -12.29250000, 44.49722000),
(1065080, 1002821, 'KM', 'Antsahé', 1, 'antsahe', -12.35639000, 44.52250000),
(1065081, 1002821, 'KM', 'Assimpao', 1, 'assimpao', -12.23306000, 44.31972000),
(1065084, 1002821, 'KM', 'Bambao', 1, 'bambao', -12.20325000, 44.51638000),
(1065085, 1002821, 'KM', 'Bandajou', 1, 'bandajou', -12.19167000, 44.28694000),
(1065086, 1002821, 'KM', 'Barakani', 1, 'barakani', -12.13861000, 44.43026000),
(1065087, 1002821, 'KM', 'Bimbini', 1, 'bimbini', -12.18833000, 44.23556000),
(1065088, 1002821, 'KM', 'Boungouéni', 1, 'boungoueni', -12.20556000, 44.29944000),
(1065090, 1002821, 'KM', 'Chandra', 1, 'chandra', -12.19500000, 44.46472000),
(1065093, 1002821, 'KM', 'Chironkamba', 1, 'chironkamba', -12.19111000, 44.35250000),
(1065094, 1002821, 'KM', 'Chitrouni', 1, 'chitrouni', -12.18583000, 44.33556000),
(1065096, 1002821, 'KM', 'Daji', 1, 'daji', -12.32583000, 44.48861000),
(1065099, 1002821, 'KM', 'Domoni', 1, 'domoni', -12.25694000, 44.53194000),
(1065102, 1002821, 'KM', 'Dziani', 1, 'dziani', -12.18333000, 44.48333000),
(1065105, 1002821, 'KM', 'Hajoho', 1, 'hajoho', -12.12434000, 44.48881000),
(1065107, 1002821, 'KM', 'Harembo', 1, 'harembo', -12.15108000, 44.49828000),
(1065113, 1002821, 'KM', 'Kangani', 1, 'kangani', -12.32102000, 44.47270000),
(1065114, 1002821, 'KM', 'Kavani', 1, 'kavani', -12.19194000, 44.26944000),
(1065115, 1002821, 'KM', 'Koki', 1, 'koki', -12.17139000, 44.44167000),
(1065116, 1002821, 'KM', 'Koni-Djodjo', 1, 'koni-djodjo', -12.22972000, 44.48167000),
(1065117, 1002821, 'KM', 'Koni-Ngani', 1, 'koni-ngani', -12.21583000, 44.48000000),
(1065119, 1002821, 'KM', 'Kyo', 1, 'kyo', -12.33222000, 44.51917000),
(1065120, 1002821, 'KM', 'Limbi', 1, 'limbi', -12.23944000, 44.50528000),
(1065121, 1002821, 'KM', 'Lingoni', 1, 'lingoni', -12.25583000, 44.41833000),
(1065123, 1002821, 'KM', 'Magnassini-Nindri', 1, 'magnassini-nindri', -12.27806000, 44.41583000),
(1065125, 1002821, 'KM', 'Maraharé', 1, 'marahare', -12.23083000, 44.31333000),
(1065128, 1002821, 'KM', 'Mirontsi', 1, 'mirontsi', -12.15667000, 44.40806000),
(1065131, 1002821, 'KM', 'Mjamaoué', 1, 'mjamaoue', -12.19361000, 44.31000000),
(1065132, 1002821, 'KM', 'Mjimandra', 1, 'mjimandra', -12.19167000, 44.37028000),
(1065136, 1002821, 'KM', 'Moutsamoudou', 1, 'moutsamoudou', -12.16672000, 44.39944000),
(1065137, 1002821, 'KM', 'Moya', 1, 'moya', -12.30967000, 44.43685000),
(1065138, 1002821, 'KM', 'Mramani', 1, 'mramani', -12.34639000, 44.52861000),
(1065139, 1002821, 'KM', 'Mrémani', 1, 'mremani', -12.30833000, 44.49861000),
(1065147, 1002821, 'KM', 'Ongoni', 1, 'ongoni', -12.17028000, 44.50694000),
(1065149, 1002821, 'KM', 'Ouani', 1, 'ouani', -12.13554000, 44.42493000),
(1065154, 1002821, 'KM', 'Ouzini', 1, 'ouzini', -12.26722000, 44.47972000),
(1065155, 1002821, 'KM', 'Pajé', 1, 'paje', -12.16972000, 44.38806000),
(1065156, 1002821, 'KM', 'Patsi', 1, 'patsi', -12.15556000, 44.43722000),
(1065158, 1002821, 'KM', 'Sima', 1, 'sima', -12.19556000, 44.27667000),
(1065162, 1002821, 'KM', 'Tsimbeo', 1, 'tsimbeo', -12.20583000, 44.46472000),
(1065165, 1002821, 'KM', 'Vouani', 1, 'vouani', -12.24417000, 44.37444000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002822, 'KM', 'Grande Comore', 1, 'grande-comore');

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 
(1065082, 1002822, 'KM', 'Bahani', 1, 'bahani', -11.63972000, 43.28417000),
(1065083, 1002822, 'KM', 'Bambadjani', 1, 'bambadjani', -11.47861000, 43.37722000),
(1065089, 1002822, 'KM', 'Bouni', 1, 'bouni', -11.48694000, 43.38833000),
(1065091, 1002822, 'KM', 'Chezani', 1, 'chezani', -11.43140000, 43.39625000),
(1065092, 1002822, 'KM', 'Chindini', 1, 'chindini', -11.92328000, 43.49109000),
(1065095, 1002822, 'KM', 'Chouani', 1, 'chouani', -11.82330000, 43.29429000),
(1065097, 1002822, 'KM', 'Dembéni', 1, 'dembeni', -11.87361000, 43.39778000),
(1065100, 1002822, 'KM', 'Douniani', 1, 'douniani', -11.42111000, 43.28889000),
(1065101, 1002822, 'KM', 'Dzahadjou', 1, 'dzahadjou', -11.85287000, 43.34987000),
(1065104, 1002822, 'KM', 'Foumbouni', 1, 'foumbouni', -11.86537000, 43.49529000),
(1065106, 1002822, 'KM', 'Hantsindzi', 1, 'hantsindzi', -11.43178000, 43.41102000),
(1065109, 1002822, 'KM', 'Héroumbili', 1, 'heroumbili', -11.54389000, 43.37972000),
(1065110, 1002822, 'KM', 'Itsandra', 1, 'itsandra', -11.67111000, 43.25472000),
(1065111, 1002822, 'KM', 'Itsandzéni', 1, 'itsandzeni', -11.47278000, 43.38444000),
(1065112, 1002822, 'KM', 'Ivouani', 1, 'ivouani', -11.39157000, 43.39454000),
(1065118, 1002822, 'KM', 'Koua', 1, 'koua', -11.42083000, 43.27639000),
(1065122, 1002822, 'KM', 'Madjeouéni', 1, 'madjeoueni', -11.82167000, 43.27806000),
(1065124, 1002822, 'KM', 'Mandza', 1, 'mandza', -11.41806000, 43.29528000),
(1065126, 1002822, 'KM', 'Mavingouni', 1, 'mavingouni', -11.71639000, 43.25250000),
(1065127, 1002822, 'KM', 'Mbéni', 1, 'mbeni', -11.50139000, 43.37750000),
(1065129, 1002822, 'KM', 'Mitsamiouli', 1, 'mitsamiouli', -11.38472000, 43.28444000),
(1065130, 1002822, 'KM', 'Mitsoudjé', 1, 'mitsoudje', -11.81209000, 43.28043000),
(1065133, 1002822, 'KM', 'Mnoungou', 1, 'mnoungou', -11.51778000, 43.37389000),
(1065134, 1002822, 'KM', 'Mohoro', 1, 'mohoro', -11.82701000, 43.45436000),
(1065135, 1002822, 'KM', 'Moroni', 1, 'moroni', -11.70216000, 43.25506000),
(1065141, 1002822, 'KM', 'Mtsamdou', 1, 'mtsamdou', -11.60694000, 43.38056000),
(1065142, 1002822, 'KM', 'Mvouni', 1, 'mvouni', -11.71611000, 43.26472000),
(1065144, 1002822, 'KM', 'Nioumamilima', 1, 'nioumamilima', -11.85461000, 43.44607000),
(1065145, 1002822, 'KM', 'Ntsaouéni', 1, 'ntsaoueni', -11.46583000, 43.26278000),
(1065146, 1002822, 'KM', 'Ntsoudjini', 1, 'ntsoudjini', -11.65972000, 43.26139000),
(1065150, 1002822, 'KM', 'Ouellah', 1, 'ouellah', -11.39028000, 43.33194000),
(1065151, 1002822, 'KM', 'Ouhozi', 1, 'ouhozi', -11.40500000, 43.28222000),
(1065152, 1002822, 'KM', 'Ourovéni', 1, 'ouroveni', -11.91375000, 43.49804000),
(1065153, 1002822, 'KM', 'Oussivo', 1, 'oussivo', -11.58500000, 43.26722000),
(1065157, 1002822, 'KM', 'Salimani', 1, 'salimani', -11.81150000, 43.26823000),
(1065160, 1002822, 'KM', 'Séléa', 1, 'selea', -11.78444000, 43.26083000),
(1065159, 1002822, 'KM', 'Singani', 1, 'singani', -11.84784000, 43.31731000),
(1065161, 1002822, 'KM', 'Tsidjé', 1, 'tsidje', -11.69806000, 43.26194000),
(1065163, 1002822, 'KM', 'Vanadjou', 1, 'vanadjou', -11.60750000, 43.27611000),
(1065164, 1002822, 'KM', 'Vanambouani', 1, 'vanambouani', -11.61139000, 43.25306000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002820, 'KM', 'Mohéli', 1, 'moheli');

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 
(1065098, 1002820, 'KM', 'Djoyézi', 1, 'djoyezi', -12.30587000, 43.77425000),
(1065103, 1002820, 'KM', 'Fomboni', 1, 'fomboni', -12.28759000, 43.74344000),
(1065108, 1002820, 'KM', 'Hoani', 1, 'hoani', -12.25083000, 43.67472000),
(1065140, 1002820, 'KM', 'Mtakoudja', 1, 'mtakoudja', -12.26111000, 43.70361000),
(1065143, 1002820, 'KM', 'Nioumachoua', 1, 'nioumachoua', -12.36139000, 43.71528000),
(1065148, 1002820, 'KM', 'Ouanani', 1, 'ouanani', -12.33750000, 43.79750000),
(1065166, 1002820, 'KM', 'Ziroudani', 1, 'ziroudani', -12.33250000, 43.77750000);

