REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('IM', 'Isle of Man', 'Isle of Man', 'isle-of-man', '+44-1624', 'GBP');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(12782164, 'IM', 'Andreas', 1, 'andreas'),
(12782165, 'IM', 'Arbory', 1, 'arbory'),
(12782166, 'IM', 'Ballaugh', 1, 'ballaugh'),
(12782167, 'IM', 'Braddan', 1, 'braddan'),
(12782168, 'IM', 'Bride', 1, 'bride'),
(12782169, 'IM', 'Castletown', 1, 'castletown'),
(12782170, 'IM', 'Douglas', 1, 'douglas'),
(12782171, 'IM', 'German', 1, 'german'),
(12782172, 'IM', 'Jurby', 1, 'jurby'),
(12782173, 'IM', 'Laxey', 1, 'laxey'),
(12782176, 'IM', 'Lezayre', 1, 'lezayre'),
(12782180, 'IM', 'Lonan', 1, 'lonan'),
(12782182, 'IM', 'Malew', 1, 'malew'),
(12782183, 'IM', 'Marown', 1, 'marown'),
(12782184, 'IM', 'Maughold', 1, 'maughold'),
(12782185, 'IM', 'Michael', 1, 'michael'),
(12782186, 'IM', 'Onchan', 1, 'onchan'),
(12782187, 'IM', 'Patrick', 1, 'patrick'),
(12782188, 'IM', 'Peel', 1, 'peel'),
(12782189, 'IM', 'Port Erin', 1, 'port-erin'),
(12782190, 'IM', 'Port St Mary', 1, 'port-st-mary'),
(12782191, 'IM', 'Ramsey', 1, 'ramsey'),
(12782192, 'IM', 'Rushen', 1, 'rushen'),
(12782193, 'IM', 'Santon', 1, 'santon');

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 
(6042170, 12782167, 'IM', 'Union Mills', 1, 'union-mills', 54.16957, -4.52019),
(6042174, 12782176, 'IM', 'Sulby', 1, 'sulby', 54.32283, -4.47968),
(6042185, 12782182, 'IM', 'Saint Marks', 1, 'saint-marks', 54.13333, -4.6),
(6042186, 12782171, 'IM', 'Saint Johns', 1, 'saint-johns', 54.2, -4.63333),
(6042189, 12782182, 'IM', 'Ronaldsway', 1, 'ronaldsway', 54.08333, -4.61667),
(6042192, 12782191, 'IM', 'Ramsey', 1, 'ramsey', 54.32273, -4.38526),
(6042193, 12782167, 'IM', 'Port Soderick', 1, 'port-soderick', 54.12865, -4.54113),
(6042196, 12782189, 'IM', 'Port Erin', 1, 'port-erin', 54.08487, -4.75099),
(6042198, 12782188, 'IM', 'Peel', 1, 'peel', 54.22209, -4.69099),
(6042217, 12782173, 'IM', 'Laxey', 1, 'laxey', 54.23017, -4.39985),
(6042229, 12782187, 'IM', 'Glen Maye', 1, 'glen-maye', 54.18333, -4.7),
(6042231, 12782182, 'IM', 'Foxdale', 1, 'foxdale', 54.16667, -4.61667),
(6042237, 12782170, 'IM', 'Douglas', 1, 'douglas', 54.15, -4.48333),
(6042238, 12782176, 'IM', 'Dog Mills', 1, 'dog-mills', 54.35, -4.38333),
(6042241, 12782182, 'IM', 'Derbyhaven', 1, 'derbyhaven', 54.07646, -4.62353),
(6042244, 12782187, 'IM', 'Dalby', 1, 'dalby', 54.16879, -4.72923),
(6042246, 12782192, 'IM', 'Cregneish', 1, 'cregneish', 54.06961, -4.76841),
(6042247, 12782168, 'IM', 'Cranstal', 1, 'cranstal', 54.3956, -4.36947),
(6042251, 12782165, 'IM', 'Colby', 1, 'colby', 54.09665, -4.70592),
(6042255, 12782169, 'IM', 'Castletown', 1, 'castletown', 54.07445, -4.65365),
(6042265, 12782166, 'IM', 'Ballakinnag', 1, 'ballakinnag', 54.33333, -4.55),
(11504401, 12782180, 'IM', 'Ballacannell', 1, 'ballacannell', 54.2173, -4.40496),
(14550882, 12782185, 'IM', 'Barregarrow', 1, 'barregarrow', 54.26252, -4.58272),
(14550883, 12782185, 'IM', 'Little London', 1, 'little-london', 54.24406, -4.57984),
(14550884, 12782185, 'IM', 'Shoughlaige-e-Caine', 1, 'shoughlaige-e-caine', 54.25309, -4.58662),
(14550885, 12782185, 'IM', 'Orrisdale', 1, 'orrisdale', 54.30481, -4.5752),
(14550888, 12782185, 'IM', 'Ballacarnane Beg', 1, 'ballacarnane-beg', 54.26227, -4.61512),
(14591723, 12782171, 'IM', 'Cronk-y-Voddy', 1, 'cronk-y-voddy', 54.24093, -4.60894);