REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('BH', 'Bahrain', '‏البحرين', 'bahrain', '973', 'BHD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(3290333, 'BH', 'Muharraq', 1, 'muharraq'),
(10090954, 'BH', 'Manama', 1, 'manama'),
(10090972, 'BH', 'Southern Governorate', 1, 'southern-governorate'),
(10090974, 'BH', 'Northern', 1, 'northern');

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 
(3290073, 10090954, 'BH', 'Wādiyān', 1, 'wadiyan', 26.15917, 50.61111),
(3290078, 10090972, 'BH', 'Umm Jidr', 1, 'umm-jidr', 26.01111, 50.52611),
(3290084, 3290333, 'BH', 'Umm ash Shajar', 1, 'umm-ash-shajar', 26.22833, 50.65583),
(3290091, 10090954, 'BH', 'Tūblī', 1, 'tubli', 26.18694, 50.54944),
(3290101, 10090954, 'BH', 'Sufālah', 1, 'sufalah', 26.16278, 50.62556),
(3290104, 10090954, 'BH', 'Sitrah', 1, 'sitrah', 26.15472, 50.62056),
(3290120, 10090954, 'BH', 'Sanad', 1, 'sanad', 26.15028, 50.58194),
(3290123, 3290333, 'BH', 'Samāhīj', 1, 'samahij', 26.28, 50.635),
(3290133, 10090972, 'BH', 'Şāfirah', 1, 'safirah', 26.105, 50.53861),
(3290142, 3290333, 'BH', 'Rayyā', 1, 'rayya', 26.28333, 50.63333),
(3290160, 3290333, 'BH', 'Qalālī', 1, 'qalali', 26.27333, 50.65028),
(3290176, 10090954, 'BH', 'Marqūbān', 1, 'marquban', 26.16417, 50.61833),
(3290179, 10090954, 'BH', 'Manī', 1, 'mani', 26.21667, 50.55),
(3290186, 10090954, 'BH', 'Mahazzah', 1, 'mahazzah', 26.16944, 50.62611),
(3290187, 10090972, 'BH', 'Madīnat ‘Īsá', 1, 'madinat-isa', 26.17361, 50.54778),
(3290198, 10090954, 'BH', 'Kawrah', 1, 'kawrah', 26.18333, 50.56667),
(3290204, 10090954, 'BH', 'Karbābād', 1, 'karbabad', 26.23028, 50.52944),
(3290210, 10090972, 'BH', 'Jusayrah', 1, 'jusayrah', 25.88333, 50.6),
(3290212, 10090954, 'BH', 'Jurdāb', 1, 'jurdab', 26.16944, 50.57528),
(3290215, 10090954, 'BH', 'Jidd Ḩafş', 1, 'jidd-hafs', 26.21861, 50.54778),
(3290217, 10090954, 'BH', 'Jidd ‘Alī', 1, 'jidd-ali', 26.17917, 50.56028),
(3290221, 10090972, 'BH', 'Jaww', 1, 'jaww', 25.99861, 50.61667),
(3290229, 10090954, 'BH', 'Jamālah', 1, 'jamalah', 26.2, 50.55),
(3290247, 10090974, 'BH', 'Madīnat Ḩamad', 1, 'madinat-hamad', 26.11528, 50.50694),
(3290249, 10090972, 'BH', 'Ḩālat Umm al Bayḑ', 1, 'halat-umm-al-bayd', 26.11667, 50.63333),
(3290250, 3290333, 'BH', 'Ḩālat as Sulţah', 1, 'halat-as-sultah', 26.24278, 50.63861),
(3290251, 3290333, 'BH', 'Ḩālat an Na‘īm', 1, 'halat-an-na-im', 26.23889, 50.63528),
(3290252, 3290333, 'BH', 'Ḩālat al Khulayfāt', 1, 'halat-al-khulayfat', 26.25, 50.63333),
(3290255, 10090954, 'BH', 'Ḩālah', 1, 'halah', 26.17333, 50.62139),
(3290269, 10090972, 'BH', 'Dār Kulayb', 1, 'dar-kulayb', 26.06861, 50.50389),
(3290287, 10090974, 'BH', 'Banī Jamrah', 1, 'bani-jamrah', 26.20972, 50.45972),
(3290295, 3290333, 'BH', 'Az Zimmah', 1, 'az-zimmah', 26.25528, 50.64694),
(3290296, 10090972, 'BH', 'Az Zallāq', 1, 'az-zallaq', 26.0475, 50.48639),
(3290299, 10090972, 'BH', '‘Awālī', 1, 'awali', 26.08444, 50.55056),
(3290303, 10090972, 'BH', 'Aş Şakhīr', 1, 'as-sakhir', 26.0625, 50.52722),
(3290304, 10090972, 'BH', '‘Askar', 1, 'askar', 26.05722, 50.61639),
(3290309, 10090972, 'BH', 'Ar Rumaythah', 1, 'ar-rumaythah', 25.92043, 50.55583),
(3290316, 3290333, 'BH', '‘Arād', 1, 'arad', 26.25611, 50.63222),
(3290319, 10090972, 'BH', 'An Nuwaydirāt', 1, 'an-nuwaydirat', 26.13472, 50.5975),
(3290322, 10090972, 'BH', 'Al Wasmīyah', 1, 'al-wasmiyah', 26.02111, 50.475),
(3290324, 10090954, 'BH', 'Al Qaryah', 1, 'al-qaryah', 26.18278, 50.58361),
(3290328, 10090954, 'BH', 'Al Muwaylighah', 1, 'al-muwaylighah', 26.20667, 50.55889),
(3290331, 10090954, 'BH', 'Magsha', 1, 'magsha', 26, 40),
(3290332, 3290333, 'BH', 'Al Muharraq', 1, 'al-muharraq', 26.25722, 50.61194),
(3290336, 10090974, 'BH', 'Al Markh', 1, 'al-markh', 26.21028, 50.47333),
(3290340, 10090954, 'BH', 'Manama', 1, 'manama', 26.22787, 50.58565),
(3290341, 10090972, 'BH', 'Al Mamţalah', 1, 'al-mamtalah', 25.92417, 50.51944),
(3290345, 10090972, 'BH', 'Al Ma‘āmīr', 1, 'al-ma-amir', 26.13333, 50.60861),
(3290346, 10090954, 'BH', 'Al Khārijīyah', 1, 'al-kharijiyah', 26.16361, 50.60472),
(3290348, 10090954, 'BH', 'Al Jubaylāt', 1, 'al-jubaylat', 26.18194, 50.55333),
(3290351, 10090974, 'BH', 'Al Jasrah', 1, 'al-jasrah', 26.16222, 50.44917),
(3290356, 10090954, 'BH', 'Al Hujayr', 1, 'al-hujayr', 26.18333, 50.55),
(3290363, 3290333, 'BH', 'Al Ḩadd', 1, 'al-hadd', 26.24556, 50.65417),
(3290366, 3290333, 'BH', 'Al Busaytīn', 1, 'al-busaytin', 26.26944, 50.60778),
(3290375, 10090972, 'BH', 'Al ‘Amar', 1, 'al-amar', 25.98813, 50.52791),
(3290376, 10090954, 'BH', 'Al ‘Akr', 1, 'al-akr', 26.14306, 50.61028),
(3290384, 10090972, 'BH', 'Ad Dūr', 1, 'ad-dur', 25.97889, 50.61499),
(3290386, 3290333, 'BH', 'Ad Dayr', 1, 'ad-dayr', 26.28417, 50.62361),
(3290395, 10090954, 'BH', 'Abū Bahām', 1, 'abu-baham', 26.2075, 50.54417),
(3385038, 10090972, 'BH', 'Ar Rifā‘', 1, 'ar-rifa', 26.13, 50.555),
(3385042, 10090972, 'BH', 'Al Qal‘ah', 1, 'al-qal-ah', 25.98083, 50.53056),
(11643013, 10090954, 'BH', 'Seef', 1, 'seef', 26.23967, 50.53685);