REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('JE', 'Jersey', 'Jersey', 'jersey', '+44-1534', 'GBP');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6237072, 'JE', 'St Clement', 1, 'st-clement'),
(6237073, 'JE', 'St Saviour', 1, 'st-saviour'),
(6237200, 'JE', 'St. Brelade', 1, 'st-brelade'),
(6237203, 'JE', 'Grouville', 1, 'grouville'),
(6237212, 'JE', 'St Mary', 1, 'st-mary'),
(6237214, 'JE', 'St Lawrence', 1, 'st-lawrence'),
(6237221, 'JE', 'St Peter', 1, 'st-peter'),
(6237229, 'JE', 'St Ouen', 1, 'st-ouen'),
(6237497, 'JE', 'St John', 1, 'st-john'),
(6237530, 'JE', 'Trinity', 1, 'trinity'),
(6237716, 'JE', 'St Martîn', 1, 'st-martin'),
(6237864, 'JE', 'St Helier', 1, 'st-helier');

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 
(6042089, 6237497, 'JE', 'Saint John', 1, 'saint-john', 49.24556, -2.13861),
(6042091, 6237864, 'JE', 'Saint Helier', 1, 'saint-helier', 49.18804, -2.10491),
(6042096, 6237200, 'JE', 'Saint Aubin', 1, 'saint-aubin', 49.1875, -2.17056),
(9641106, 6237200, 'JE', 'La Moye', 1, 'la-moye', 49.1847, -2.22031),
(11181789, 6237716, 'JE', 'Fliquet', 1, 'fliquet', 49.2278, -2.02869),
(11181790, 6237229, 'JE', 'La Grève de Lecq', 1, 'la-greve-de-lecq', 49.24542, -2.20287),
(11199130, 6237716, 'JE', 'St Martin', 1, 'st-martin', 49.22006, -2.05127),
(12538861, 6237221, 'JE', 'St Peters Village', 1, 'st-peters-village', 49.21294, -2.18353),
(12538862, 6237221, 'JE', 'La Presse', 1, 'la-presse', 49.21423, -2.19422),
(12538865, 6237229, 'JE', 'St Ouen\'s Manor', 1, 'st-ouen-s-manor', 49.22499, -2.20014),
(12538866, 6237221, 'JE', 'St. Peters Arsenal', 1, 'st-peters-arsenal', 49.20204, -2.1822);