REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('BT', 'Bhutan', 'ʼbrug-yul', 'bhutan', '975', 'BTN');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(4337278, 'BT', 'Bumthang', 1, 'bumthang'),
(4337279, 'BT', 'Chukha', 1, 'chukha'),
(4337280, 'BT', 'Dagana', 1, 'dagana'),
(4337281, 'BT', 'Chirang', 1, 'chirang'),
(4337282, 'BT', 'Geylegphug', 1, 'geylegphug'),
(4337283, 'BT', 'Haa', 1, 'haa'),
(4337284, 'BT', 'Lhuntse', 1, 'lhuntse'),
(4337285, 'BT', 'Mongar', 1, 'mongar'),
(4337286, 'BT', 'Paro', 1, 'paro'),
(4337287, 'BT', 'Pemagatshel', 1, 'pemagatshel'),
(4337288, 'BT', 'Punakha', 1, 'punakha'),
(4337289, 'BT', 'Samchi', 1, 'samchi'),
(4337290, 'BT', 'Samdrup Jongkhar', 1, 'samdrup-jongkhar'),
(4337291, 'BT', 'Shemgang', 1, 'shemgang'),
(4337292, 'BT', 'Tashigang', 1, 'tashigang'),
(4337293, 'BT', 'Thimphu', 1, 'thimphu'),
(4337294, 'BT', 'Tongsa', 1, 'tongsa'),
(4337295, 'BT', 'Wangdi Phodrang', 1, 'wangdi-phodrang'),
(10303651, 'BT', 'Gasa', 1, 'gasa'),
(10303653, 'BT', 'Trashi Yangste', 1, 'trashi-yangste');

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 
(4252395, 4337295, 'BT', 'Wangdue Phodrang', 1, 'wangdue-phodrang', 27.48615, 89.89915),
(4252401, 4337278, 'BT', 'Ura', 1, 'ura', 27.41667, 90.91667),
(4252407, 4337284, 'BT', 'Tormoshangsa', 1, 'tormoshangsa', 27.48333, 91.1),
(4252408, 4337294, 'BT', 'Trongsa', 1, 'trongsa', 27.5026, 90.50716),
(4252411, 4337284, 'BT', 'Tobrang', 1, 'tobrang', 27.71667, 91.5),
(4252413, 4337284, 'BT', 'Khenpa Dzong', 1, 'khenpa-dzong', 27.81667, 91.08333),
(4252416, 4337293, 'BT', 'Thimphu', 1, 'thimphu', 27.46609, 89.64191),
(4252422, 10303653, 'BT', 'Trashi Yangtse', 1, 'trashi-yangtse', 27.6116, 91.498),
(4252423, 4337292, 'BT', 'Trashigang', 1, 'trashigang', 27.3331, 91.55424),
(4252433, 4337280, 'BT', 'Daga', 1, 'daga', 27.07529, 89.87688),
(4252436, 4337283, 'BT', 'Sangbay', 1, 'sangbay', 27.16667, 89.08333),
(4252439, 4337284, 'BT', 'Singye Dzong', 1, 'singye-dzong', 27.91667, 91.35),
(4252443, 4337285, 'BT', 'Shongar Dzong', 1, 'shongar-dzong', 27.25, 91.08333),
(4252445, 4337283, 'BT', 'Shiuji', 1, 'shiuji', 27.17681, 89.02529),
(4252451, 4337291, 'BT', 'Shemgang', 1, 'shemgang', 27.21689, 90.65793),
(4252460, 4337282, 'BT', 'Sarpang', 1, 'sarpang', 26.86395, 90.26745),
(4252466, 4337294, 'BT', 'Samdrup Choling', 1, 'samdrup-choling', 27.4, 90.5),
(4252468, 4337292, 'BT', 'Sakteng', 1, 'sakteng', 27.38333, 91.86667),
(4252479, 4337288, 'BT', 'Punākha', 1, 'punakha', 27.59137, 89.87743),
(4252484, 4337279, 'BT', 'Phuntsholing', 1, 'phuntsholing', 26.85164, 89.38837),
(4252487, 4337282, 'BT', 'Pinkhua', 1, 'pinkhua', 26.71667, 90.05),
(4252490, 4337286, 'BT', 'Paro', 1, 'paro', 27.4305, 89.41334),
(4252492, 4337291, 'BT', 'Pangkha', 1, 'pangkha', 26.95, 90.81667),
(4252495, 4337288, 'BT', 'Pajo', 1, 'pajo', 27.53333, 89.88333),
(4252514, 4337285, 'BT', 'Mongar', 1, 'mongar', 27.27471, 91.23963),
(4252526, 4337284, 'BT', 'Lhuentse', 1, 'lhuentse', 27.66787, 91.18393),
(4252528, 4337278, 'BT', 'Lhedang', 1, 'lhedang', 27.95001, 90.69214),
(4252535, 4337279, 'BT', 'Chapchha', 1, 'chapchha', 27.2, 89.55),
(4252560, 4337282, 'BT', 'Geylegphug', 1, 'geylegphug', 26.86833, 90.48778),
(4252563, 4337283, 'BT', 'Ha', 1, 'ha', 27.38747, 89.28074),
(4252578, 10303651, 'BT', 'Gasa', 1, 'gasa', 27.90372, 89.72689),
(4252582, 4337289, 'BT', 'Dzongsa Dzong', 1, 'dzongsa-dzong', 27.1, 88.88333),
(4252583, 4337279, 'BT', 'Dungna', 1, 'dungna', 27.03333, 89.4),
(4252597, 4337290, 'BT', 'Dewāngiri', 1, 'dewangiri', 26.86667, 91.46667),
(4252600, 4337285, 'BT', 'Dametsi', 1, 'dametsi', 27.3, 91.45),
(4252601, 4337279, 'BT', 'Daphu', 1, 'daphu', 26.96667, 89.38333),
(4252608, 4337281, 'BT', 'Tsirang', 1, 'tsirang', 27.0219, 90.12291),
(4252610, 4337279, 'BT', 'Tsimasham', 1, 'tsimasham', 27.0989, 89.53604),
(4252617, 4337282, 'BT', 'Changchukha Dzong', 1, 'changchukha-dzong', 27.13333, 90.35),
(4252622, 4337278, 'BT', 'Byakar Dzong', 1, 'byakar-dzong', 27.55, 90.71667),
(4337299, 4337293, 'BT', 'Lingshi', 1, 'lingshi', 27.91667, 89.43333),
(4337301, 4337278, 'BT', 'Jakar', 1, 'jakar', 27.54918, 90.7525),
(4337302, 4337278, 'BT', 'Kurjey', 1, 'kurjey', 27.61667, 90.7),
(4337303, 4337278, 'BT', 'Nangnang', 1, 'nangnang', 27.6, 90.88333),
(4337304, 4337295, 'BT', 'Gangtey Gonpa', 1, 'gangtey-gonpa', 27.5, 90.16667),
(4337354, 4337282, 'BT', 'Lalai', 1, 'lalai', 26.78333, 90.51667),
(4337356, 4337291, 'BT', 'Panbang', 1, 'panbang', 26.86667, 90.98333),
(4337357, 4337290, 'BT', 'Nganglam', 1, 'nganglam', 26.78333, 91.25),
(4337359, 4337282, 'BT', 'Kalikhola', 1, 'kalikhola', 26.71667, 90.85),
(4337360, 4337289, 'BT', 'Samtse', 1, 'samtse', 26.89903, 89.09951),
(4337361, 4337289, 'BT', 'Chengmari', 1, 'chengmari', 26.91667, 89.03333),
(4337362, 4337289, 'BT', 'Dorokha', 1, 'dorokha', 27.01667, 89.21667),
(4337363, 4337280, 'BT', 'Sibsu', 1, 'sibsu', 26.99722, 88.9),
(4337372, 4337281, 'BT', 'Damphu', 1, 'damphu', 27.01667, 90.1),
(4337373, 4337281, 'BT', 'Lamidangra', 1, 'lamidangra', 26.96667, 90.1),
(4337374, 4337281, 'BT', 'Dagapela', 1, 'dagapela', 26.93333, 89.95),
(4337375, 4337292, 'BT', 'Radi', 1, 'radi', 27.36667, 91.68333),
(4337376, 4337285, 'BT', 'Gyepozhing', 1, 'gyepozhing', 27.18333, 91.16667),
(4337377, 4337292, 'BT', 'Thrimshing', 1, 'thrimshing', 27.13333, 91.61667),
(4337378, 4337292, 'BT', 'Wamrong', 1, 'wamrong', 27.06667, 91.56667),
(4337379, 4337287, 'BT', 'Pemagatshel', 1, 'pemagatshel', 27.03795, 91.40305),
(4337380, 4337295, 'BT', 'Tseshinang', 1, 'tseshinang', 27.75, 90.06667),
(4337381, 4337288, 'BT', 'Dawakha', 1, 'dawakha', 27.66667, 89.91667),
(4337382, 4337286, 'BT', 'Drugyel Dzong', 1, 'drugyel-dzong', 27.5, 89.33333),
(4337383, 4337283, 'BT', 'Damthang', 1, 'damthang', 27.41667, 89.35),
(4337384, 4337286, 'BT', 'Tshalunang', 1, 'tshalunang', 27.46883, 89.52257),
(4337385, 4337286, 'BT', 'Atsho Chhubar', 1, 'atsho-chhubar', 27.48333, 89.4),
(4337386, 4337290, 'BT', 'Daifam', 1, 'daifam', 26.9, 92.1),
(4337387, 4337290, 'BT', 'Bhangtar', 1, 'bhangtar', 26.81667, 91.71667),
(4337388, 4337290, 'BT', 'Samdrup Jongkhar', 1, 'samdrup-jongkhar', 26.80069, 91.50519),
(4337389, 10303651, 'BT', 'Laya', 1, 'laya', 28.0613, 89.6826),
(4337390, 4337288, 'BT', 'Lunana', 1, 'lunana', 28.29989, 90.23229),
(10646290, 4337295, 'BT', 'Pele La', 1, 'pele-la', 27.55, 90.21667),
(10647496, 4337292, 'BT', 'Kanglung', 1, 'kanglung', 27.29, 91.54),
(10701319, 4337284, 'BT', 'Autsho', 1, 'autsho', 27.44309, 91.17485),
(10701322, 4337283, 'BT', 'Shari', 1, 'shari', 27.26173, 89.34271),
(10701325, 4337293, 'BT', 'Lobeysa', 1, 'lobeysa', 27.52273, 89.8855),
(10701327, 4337279, 'BT', 'Phuentsholing', 1, 'phuentsholing', 26.85892, 89.39048),
(10910396, 4337286, 'BT', 'Paro populated 1', 1, 'paro-populated-1', 27.38893, 89.43135),
(10910397, 4337286, 'BT', 'Paro Populated2', 1, 'paro-populated2', 27.38619, 89.42736),
(10910398, 4337286, 'BT', 'Paro Populated3', 1, 'paro-populated3', 27.39071, 89.42521),
(10910399, 4337286, 'BT', 'Paro Populated4', 1, 'paro-populated4', 27.38899, 89.43397),
(11429852, 4337289, 'BT', 'Dūmte', 1, 'dumte', 27.04553, 89.18275),
(11429853, 4337283, 'BT', 'Hingslo', 1, 'hingslo', 27.17937, 89.15256),
(11429854, 4337283, 'BT', 'Bumtaka', 1, 'bumtaka', 27.6568, 89.86962),
(11431133, 10303653, 'BT', 'Drakhāng', 1, 'drakhang', 27.73228, 91.70901),
(11431173, 4337292, 'BT', 'Māgo', 1, 'mago', 27.69284, 92.21599),
(11431190, 4337292, 'BT', 'Ānkāling', 1, 'ankaling', 27.03785, 92.15262),
(11740320, 4337290, 'BT', 'Nganglam New', 1, 'nganglam-new', 26.81771, 91.24836),
(11740340, 4337279, 'BT', 'Tsimalakha', 1, 'tsimalakha', 27.08602, 89.54151),
(11740926, 4337279, 'BT', 'Tshimalakha', 1, 'tshimalakha', 27.08602, 89.54151),
(12072792, 4337279, 'BT', 'Dala', 1, 'dala', 26.85, 89.54972),
(13173480, 4337290, 'BT', 'Deothang', 1, 'deothang', 26.89, 91.5),
(14072155, 4337293, 'BT', 'Babesa', 1, 'babesa', 27.43277, 89.65024),
(14101512, 4337291, 'BT', 'Tingtibi', 1, 'tingtibi', 27.15, 90.68),
(14496360, 4337292, 'BT', 'Gomkora', 1, 'gomkora', 27.4257, 91.56496),
(14670039, 4337294, 'BT', 'Kungarapten', 1, 'kungarapten', 27.41071, 90.51586);