REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('LI', 'Liechtenstein', 'Liechtenstein', 'liechtenstein', '423', 'CHF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6042031, 'LI', 'Vaduz', 1, 'vaduz'),
(6042034, 'LI', 'Triesenberg', 1, 'triesenberg'),
(6042036, 'LI', 'Triesen', 1, 'triesen'),
(6042038, 'LI', 'Schellenberg', 1, 'schellenberg'),
(6042042, 'LI', 'Schaan', 1, 'schaan'),
(6042047, 'LI', 'Ruggell', 1, 'ruggell'),
(6042050, 'LI', 'Planken', 1, 'planken'),
(6042056, 'LI', 'Mauren', 1, 'mauren'),
(6042063, 'LI', 'Gamprin', 1, 'gamprin'),
(6042069, 'LI', 'Eschen', 1, 'eschen'),
(6042074, 'LI', 'Balzers', 1, 'balzers');

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 
(6042030, 6042031, 'LI', 'Vaduz', 1, 'vaduz', 47.14151, 9.52154),
(6042033, 6042034, 'LI', 'Triesenberg', 1, 'triesenberg', 47.11815, 9.54197),
(6042035, 6042036, 'LI', 'Triesen', 1, 'triesen', 47.10752, 9.52815),
(6042037, 6042038, 'LI', 'Schellenberg', 1, 'schellenberg', 47.23123, 9.54678),
(6042040, 6042056, 'LI', 'Schaanwald', 1, 'schaanwald', 47.21187, 9.5624),
(6042041, 6042042, 'LI', 'Schaan', 1, 'schaan', 47.16498, 9.50867),
(6042046, 6042047, 'LI', 'Ruggell', 1, 'ruggell', 47.23799, 9.5254),
(6042049, 6042050, 'LI', 'Planken', 1, 'planken', 47.18516, 9.54437),
(6042052, 6042069, 'LI', 'Nendeln', 1, 'nendeln', 47.19846, 9.543),
(6042055, 6042056, 'LI', 'Mauren', 1, 'mauren', 47.21805, 9.5442),
(6042062, 6042063, 'LI', 'Gamprin', 1, 'gamprin', 47.22038, 9.50935),
(6042068, 6042069, 'LI', 'Eschen', 1, 'eschen', 47.21071, 9.52223),
(6042072, 6042063, 'LI', 'Bendern', 1, 'bendern', 47.21199, 9.50678),
(6042073, 6042074, 'LI', 'Balzers', 1, 'balzers', 47.06665, 9.50251),
(6315349, 6042074, 'LI', 'Mäls', 1, 'mals', 47.06105, 9.49568),
(6315351, 6042034, 'LI', 'Wangerberg', 1, 'wangerberg', 47.10589, 9.54463),
(6315353, 6042034, 'LI', 'Rotenboden', 1, 'rotenboden', 47.12972, 9.53802),
(6315354, 6042034, 'LI', 'Silum', 1, 'silum', 47.13183, 9.55377),
(6315356, 6042034, 'LI', 'Masescha', 1, 'masescha', 47.13271, 9.54454),
(6315358, 6042031, 'LI', 'Möliholz', 1, 'moliholz', 47.15569, 9.51111),
(9545409, 6042034, 'LI', 'Malbun', 1, 'malbun', 47.10139, 9.60986),
(9545410, 6042034, 'LI', 'Steg', 1, 'steg', 47.11266, 9.57536),
(10670251, 6042034, 'LI', 'Lavadina', 1, 'lavadina', 47.11459, 9.55545),
(13347562, 6042038, 'LI', 'Loch', 1, 'loch', 47.22853, 9.53413),
(13347565, 6042056, 'LI', 'Betsche', 1, 'betsche', 47.22708, 9.54814),
(13347566, 6042063, 'LI', 'Lums', 1, 'lums', 47.22541, 9.52606),
(13347570, 6042063, 'LI', 'Breita', 1, 'breita', 47.22599, 9.51669),
(13347571, 6042063, 'LI', 'Badäl', 1, 'badal', 47.22944, 9.51906),
(13347583, 6042063, 'LI', 'Studaberg', 1, 'studaberg', 47.22179, 9.50841),
(13348589, 6042034, 'LI', 'Fromahus', 1, 'fromahus', 47.13249, 9.53282),
(13352413, 6042050, 'LI', 'Oberplanken', 1, 'oberplanken', 47.17811, 9.54585),
(13352414, 6042050, 'LI', 'Ober Ställ', 1, 'ober-stall', 47.177, 9.54612),
(13352424, 6042034, 'LI', 'Gnalp', 1, 'gnalp', 47.12286, 9.55352),
(13352426, 6042034, 'LI', 'Mitätsch', 1, 'mitatsch', 47.12501, 9.55327),
(13352439, 6042034, 'LI', 'Hof', 1, 'hof', 47.12665, 9.54664),
(13352444, 6042034, 'LI', 'Eggalti', 1, 'eggalti', 47.12464, 9.54349),
(13352545, 6042042, 'LI', 'Bim Stall', 1, 'bim-stall', 47.13981, 9.60064),
(13353264, 6042042, 'LI', 'Riethof', 1, 'riethof', 47.19224, 9.52347),
(13353678, 6042034, 'LI', 'Rüti', 1, 'ruti', 47.10799, 9.54498),
(13353681, 6042034, 'LI', 'Böda', 1, 'boda', 47.10618, 9.54324),
(13353699, 6042034, 'LI', 'Fura', 1, 'fura', 47.10468, 9.54552),
(13354583, 6042036, 'LI', 'Welda Bongert', 1, 'welda-bongert', 47.08632, 9.52791),
(13354590, 6042036, 'LI', 'Neugrütt', 1, 'neugrutt', 47.08782, 9.52337),
(13366929, 6042034, 'LI', 'Foppa', 1, 'foppa', 47.13485, 9.54322),
(13366934, 6042034, 'LI', 'Vorder Prufatscheng', 1, 'vorder-prufatscheng', 47.13774, 9.53921),
(13366936, 6042034, 'LI', 'Erbi', 1, 'erbi', 47.13887, 9.53363),
(13366943, 6042034, 'LI', 'Bärg', 1, 'barg', 47.13952, 9.54557),
(13366944, 6042034, 'LI', 'Allmeina', 1, 'allmeina', 47.12998, 9.53888),
(13366993, 6042034, 'LI', 'Alpelti', 1, 'alpelti', 47.12802, 9.55838),
(13367031, 6042069, 'LI', 'Berg', 1, 'berg', 47.22307, 9.53871);