REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('GG', 'Guernsey', 'Guernsey', 'guernsey', '+44-1481', 'GBP');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(9417213, 'GG', 'St Pierre du Bois', 1, 'st-pierre-du-bois'),
(9417214, 'GG', 'Torteval', 1, 'torteval'),
(9417215, 'GG', 'Saint Saviour', 1, 'saint-saviour'),
(9417223, 'GG', 'Forest', 1, 'forest'),
(9417224, 'GG', 'St Martin', 1, 'st-martin'),
(9417226, 'GG', 'Saint Andrew', 1, 'saint-andrew'),
(9417228, 'GG', 'St Peter Port', 1, 'st-peter-port'),
(9417229, 'GG', 'Castel', 1, 'castel'),
(9417230, 'GG', 'Vale', 1, 'vale'),
(9417233, 'GG', 'St Sampson', 1, 'st-sampson'),
(11989934, 'GG', 'Alderney', 1, 'alderney');

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 
(6042281, 9417229, 'GG', 'Saumarez', 1, 'saumarez', 49.46667, -2.6),
(6042287, 9417228, 'GG', 'Saint Peter Port', 1, 'saint-peter-port', 49.45981, -2.53527),
(9417282, 9417214, 'GG', 'Pleinmont', 1, 'pleinmont', 49.43194, -2.66722),
(9420097, 9417214, 'GG', 'Les Fontaines', 1, 'les-fontaines', 49.43083, -2.65806),
(9420119, 9417214, 'GG', 'Les Galliennes', 1, 'les-galliennes', 49.43139, -2.65111),
(9420129, 9417214, 'GG', 'Les Jehans', 1, 'les-jehans', 49.43028, -2.63389),
(9420130, 9417214, 'GG', 'Les Falles', 1, 'les-falles', 49.43278, -2.63111),
(9420135, 9417213, 'GG', 'Les Laurens', 1, 'les-laurens', 49.42528, -2.62528),
(9420138, 9417223, 'GG', 'Les Bruliaux', 1, 'les-bruliaux', 49.425, -2.61611),
(9420199, 9417223, 'GG', 'La Vrangue', 1, 'la-vrangue', 49.42472, -2.60056),
(9420200, 9417223, 'GG', 'Les Villets', 1, 'les-villets', 49.42472, -2.59667),
(9420202, 9417223, 'GG', 'Le Bigard', 1, 'le-bigard', 49.42472, -2.60528),
(9420204, 9417223, 'GG', 'Le Landes', 1, 'le-landes', 49.42972, -2.59861),
(9420210, 9417223, 'GG', 'Mont Plaisir', 1, 'mont-plaisir', 49.43028, -2.60361),
(9420219, 9417223, 'GG', 'Le Roussel', 1, 'le-roussel', 49.43611, -2.58556),
(9420224, 9417224, 'GG', 'Les Pieces', 1, 'les-pieces', 49.43333, -2.58306),
(9420234, 9417223, 'GG', 'Les Fontenelles', 1, 'les-fontenelles', 49.42361, -2.59139),
(9420356, 9417224, 'GG', 'Jerbourg', 1, 'jerbourg', 49.42472, -2.53361),
(9420451, 9417230, 'GG', 'Fontenelle', 1, 'fontenelle', 49.50167, -2.515),
(9420452, 9417230, 'GG', 'La Moye', 1, 'la-moye', 49.49972, -2.51389),
(9420453, 9417230, 'GG', 'La Rochelle', 1, 'la-rochelle', 49.49944, -2.50889),
(9420460, 9417230, 'GG', 'La Lande', 1, 'la-lande', 49.50306, -2.50833),
(9420635, 9417230, 'GG', 'Maresquet', 1, 'maresquet', 49.48694, -2.51528),
(9420668, 9417233, 'GG', 'Braye du Valle', 1, 'braye-du-valle', 49.48722, -2.53528),
(9420675, 9417233, 'GG', 'La Tonelle', 1, 'la-tonelle', 49.47417, -2.53056),
(9420687, 9417228, 'GG', 'Bouet', 1, 'bouet', 49.46806, -2.54111),
(9420689, 9417228, 'GG', 'Saint Johns', 1, 'saint-johns', 49.465, -2.54),
(9421846, 9417233, 'GG', 'Rousse', 1, 'rousse', 49.49694, -2.555),
(9421847, 9417233, 'GG', 'Le Vaugrat', 1, 'le-vaugrat', 49.49056, -2.56111),
(9421930, 9417229, 'GG', 'Saint Germain', 1, 'saint-germain', 49.4675, -2.59583),
(9422027, 9417226, 'GG', 'La Chaumière', 1, 'la-chaumiere', 49.45722, -2.57306),
(9422036, 9417229, 'GG', 'Mont Plaisant', 1, 'mont-plaisant', 49.4675, -2.58917),
(9424109, 9417213, 'GG', 'L’Erée', 1, 'l-eree', 49.45417, -2.65167),
(9424153, 9417213, 'GG', 'Les Adams', 1, 'les-adams', 49.45361, -2.64611),
(9424175, 9417214, 'GG', 'Les Martins', 1, 'les-martins', 49.42972, -2.62667),
(9424176, 9417213, 'GG', 'Le Pont', 1, 'le-pont', 49.43333, -2.62639),
(9424210, 9417226, 'GG', 'Camptréhard', 1, 'camptrehard', 49.44889, -2.58),
(9424211, 9417226, 'GG', 'Les Niaux', 1, 'les-niaux', 49.45111, -2.58194);