REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('AD', 'Andorra', 'Andorra', 'andorra', '376', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6039162, 'AD', 'Sant Julià de Loria', 1, 'sant-julia-de-loria'),
(6039676, 'AD', 'Ordino', 1, 'ordino'),
(6040131, 'AD', 'La Massana', 1, 'la-massana'),
(6040684, 'AD', 'Encamp', 1, 'encamp'),
(6041203, 'AD', 'Canillo', 1, 'canillo'),
(6041566, 'AD', 'Andorra la Vella', 1, 'andorra-la-vella'),
(6338529, 'AD', 'Escaldes-Engordany', 1, 'escaldes-engordany');

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 
(6038816, 6040131, 'AD', 'Xixerella', 1, 'xixerella', 42.55327, 1.48736),
(6038832, 6040684, 'AD', 'Vila', 1, 'vila', 42.53176, 1.56654),
(6038987, 6039676, 'AD', 'Sornàs', 1, 'sornas', 42.56461, 1.52757),
(6038999, 6041203, 'AD', 'Soldeu', 1, 'soldeu', 42.57688, 1.66769),
(6039077, 6040131, 'AD', 'Sispony', 1, 'sispony', 42.53368, 1.51613),
(6039132, 6039676, 'AD', 'Segudet', 1, 'segudet', 42.55713, 1.53808),
(6039154, 6041203, 'AD', 'El Tarter', 1, 'el-tarter', 42.57952, 1.65362),
(6039163, 6039162, 'AD', 'Sant Julià de Lòria', 1, 'sant-julia-de-loria', 42.46372, 1.49129),
(6039166, 6041203, 'AD', 'Sant Joan de Caselles', 1, 'sant-joan-de-caselles', 42.57116, 1.60761),
(6039181, 6041566, 'AD', 'Santa Coloma', 1, 'santa-coloma', 42.49454, 1.49897),
(6039320, 6041203, 'AD', 'Ransol', 1, 'ransol', 42.58137, 1.63812),
(6039322, 6338529, 'AD', 'Ràmio', 1, 'ramio', 42.49734, 1.57401),
(6039386, 6041203, 'AD', 'Prats', 1, 'prats', 42.56003, 1.59396),
(6039604, 6040684, 'AD', 'Pas de la Casa', 1, 'pas-de-la-casa', 42.54277, 1.73361),
(6039634, 6040131, 'AD', 'Pal', 1, 'pal', 42.54592, 1.47524),
(6039678, 6039676, 'AD', 'Ordino', 1, 'ordino', 42.55623, 1.53319),
(6039757, 6039162, 'AD', 'Nagol', 1, 'nagol', 42.47142, 1.50231),
(6039819, 6041203, 'AD', 'Molleres', 1, 'molleres', 42.55093, 1.58985),
(6039862, 6041203, 'AD', 'Meritxell', 1, 'meritxell', 42.55403, 1.59087),
(6039896, 6040131, 'AD', 'Mas de Ribafeta', 1, 'mas-de-ribafeta', 42.56932, 1.48858),
(6039901, 6039162, 'AD', 'Mas d’Alins', 1, 'mas-d-alins', 42.44112, 1.45128),
(6039959, 6039162, 'AD', 'Llumeneres', 1, 'llumeneres', 42.47229, 1.51165),
(6039979, 6039676, 'AD', 'Llorts', 1, 'llorts', 42.59625, 1.52658),
(6040025, 6039676, 'AD', 'Les Subiranes', 1, 'les-subiranes', 42.62055, 1.54147),
(6040027, 6039676, 'AD', 'Les Salines', 1, 'les-salines', 42.60952, 1.53697),
(6040051, 6338529, 'AD', 'les Escaldes', 1, 'les-escaldes', 42.50729, 1.53414),
(6040067, 6040684, 'AD', 'Les Bons', 1, 'les-bons', 42.53873, 1.58649),
(6040132, 6040131, 'AD', 'la Massana', 1, 'la-massana', 42.54499, 1.51483),
(6040140, 6041203, 'AD', 'l\'Aldosa de canillo', 1, 'l-aldosa-de-canillo', 42.57895, 1.62902),
(6040141, 6040131, 'AD', 'l\'Aldosa', 1, 'l-aldosa', 42.54391, 1.52289),
(6040154, 6039676, 'AD', 'La Cortinada', 1, 'la-cortinada', 42.57423, 1.51845),
(6040200, 6039162, 'AD', 'Juberri', 1, 'juberri', 42.44, 1.49194),
(6040437, 6039162, 'AD', 'Fontaneda', 1, 'fontaneda', 42.45405, 1.46471),
(6040601, 6040131, 'AD', 'Escàs', 1, 'escas', 42.54643, 1.50895),
(6040609, 6040131, 'AD', 'Erts', 1, 'erts', 42.56218, 1.4968),
(6040648, 6338529, 'AD', 'Engordany', 1, 'engordany', 42.51115, 1.54118),
(6040686, 6040684, 'AD', 'Encamp', 1, 'encamp', 42.53474, 1.58014),
(6040694, 6041203, 'AD', 'El Vilar', 1, 'el-vilar', 42.57204, 1.608),
(6040709, 6041203, 'AD', 'Els Plans', 1, 'els-plans', 42.58143, 1.63273),
(6040737, 6039676, 'AD', 'El Serrat', 1, 'el-serrat', 42.6183, 1.53912),
(6041098, 6039162, 'AD', 'Certers', 1, 'certers', 42.47457, 1.50611),
(6041204, 6041203, 'AD', 'Canillo', 1, 'canillo', 42.5676, 1.59756),
(6041375, 6039162, 'AD', 'Bixessarri', 1, 'bixessarri', 42.48197, 1.46052),
(6041475, 6039162, 'AD', 'Aubinyà', 1, 'aubinya', 42.4531, 1.49247),
(6041519, 6040131, 'AD', 'Arinsal', 1, 'arinsal', 42.57205, 1.48453),
(6041541, 6039676, 'AD', 'Arans', 1, 'arans', 42.58226, 1.51844),
(6041543, 6040131, 'AD', 'Anyós', 1, 'anyos', 42.53465, 1.5251),
(6041546, 6039676, 'AD', 'Ansalonga', 1, 'ansalonga', 42.56881, 1.52198),
(6041563, 6041566, 'AD', 'Andorra la Vella', 1, 'andorra-la-vella', 42.50779, 1.52109),
(6041598, 6039162, 'AD', 'Aixovall', 1, 'aixovall', 42.4764, 1.48899),
(6041604, 6039162, 'AD', 'Aixirivall', 1, 'aixirivall', 42.46245, 1.50209),
(6041609, 6039162, 'AD', 'Aixàs', 1, 'aixas', 42.48647, 1.46838),
(10302102, 6041566, 'AD', 'La Margineda', 1, 'la-margineda', 42.48599, 1.49024),
(11260082, 6041203, 'AD', 'Incles', 1, 'incles', 42.58285, 1.66267),
(11260083, 6041203, 'AD', 'Bordes d\'Envalira', 1, 'bordes-d-envalira', 42.55962, 1.68576),
(11260095, 6338529, 'AD', 'Sant Miquel d\'Engolasters', 1, 'sant-miquel-d-engolasters', 42.51119, 1.55987),
(13630523, 6040131, 'AD', 'Puiol del Piu', 1, 'puiol-del-piu', 42.5652, 1.49159),
(14945497, 6338529, 'AD', 'Els Vilars', 1, 'els-vilars', 42.51636, 1.53356),
(14945537, 6041566, 'AD', 'La Comella', 1, 'la-comella', 42.50117, 1.52879);