REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('SM', 'San Marino', 'San Marino', 'san-marino', '378', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6166650, 'SM', 'Serravalle', 1, 'serravalle'),
(6178807, 'SM', 'Chiesanuova', 1, 'chiesanuova'),
(6345302, 'SM', 'San Marino', 1, 'san-marino'),
(6345303, 'SM', 'Acquaviva', 1, 'acquaviva'),
(6345304, 'SM', 'Borgo Maggiore', 1, 'borgo-maggiore'),
(6345305, 'SM', 'Domagnano', 1, 'domagnano'),
(6345306, 'SM', 'Faetano', 1, 'faetano'),
(6345307, 'SM', 'Fiorentino', 1, 'fiorentino'),
(6345308, 'SM', 'Montegiardino', 1, 'montegiardino');

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 
(6166645, 6166650, 'SM', 'Serravalle', 1, 'serravalle', 43.96897, 12.48167),
(6168070, 6345302, 'SM', 'San Marino', 1, 'san-marino', 43.93667, 12.44639),
(6170472, 6178807, 'SM', 'Poggio di Chiesanuova', 1, 'poggio-di-chiesanuova', 43.90451, 12.42142),
(6172906, 6345308, 'SM', 'Monte Giardino', 1, 'monte-giardino', 43.90878, 12.48201),
(6176966, 6345307, 'SM', 'Fiorentino', 1, 'fiorentino', 43.91001, 12.45738),
(6177260, 6166650, 'SM', 'Falciano', 1, 'falciano', 43.98333, 12.5),
(6177299, 6345306, 'SM', 'Faetano', 1, 'faetano', 43.92831, 12.49798),
(6177542, 6345305, 'SM', 'Domagnano', 1, 'domagnano', 43.94961, 12.46828),
(6177564, 6166650, 'SM', 'Dogana', 1, 'dogana', 43.98034, 12.49051),
(6181793, 6345304, 'SM', 'Borgo Maggiore', 1, 'borgo-maggiore', 43.94193, 12.44738),
(6183500, 6345303, 'SM', 'Acquaviva', 1, 'acquaviva', 43.94593, 12.4185),
(9941147, 6166650, 'SM', 'Fiorina', 1, 'fiorina', 43.95798, 12.47686),
(10302185, 6345303, 'SM', 'Gualdicciolo', 1, 'gualdicciolo', 43.94982, 12.40726),
(10302190, 6345302, 'SM', 'Murata', 1, 'murata', 43.92015, 12.45146),
(11199069, 6345302, 'SM', 'Santa Mustiola', 1, 'santa-mustiola', 43.93388, 12.43858),
(11199070, 6345308, 'SM', 'Cerbaiola', 1, 'cerbaiola', 43.90346, 12.47683),
(11199072, 6345302, 'SM', 'Casole', 1, 'casole', 43.91697, 12.44442),
(11199073, 6345304, 'SM', 'Cà Rigo', 1, 'ca-rigo', 43.94278, 12.44548),
(14205481, 6345305, 'SM', 'Piandivello', 1, 'piandivello', 43.95003, 12.48669);