-- Update countries
UPDATE `llx_c_pays` SET 'active = '0';
UPDATE `llx_c_pays` SET 'active = '1' WHERE code = 'GB';

-- Add Countries to regions

INSERT INTO `llx_c_regions` (`code_region`, `fk_pays`, `cheflieu`, `tncc`, `nom`, `active`) VALUES
(8001, 7, NULL, NULL, 'England', 1),
(8002, 7, NULL, NULL, 'Wales', 1),
(8003, 7, NULL, NULL, 'Scotland', 1),
(8004, 7, NULL, NULL, 'Northern Ireland', 1);


-- Add counties to departements
INSERT INTO `llx_c_departements` (`code_departement`, `fk_region`, `cheflieu`, `tncc`, `ncc`, `nom`, `active`) VALUES
('8001', 8001, NULL, 0,NULL, 'Bedfordshire', 1),
('8002', 8001, NULL, 0,NULL, 'Berkshire', 1),
('8003', 8001, NULL, 0,NULL, 'Bristol, City of', 1),
('8004', 8001, NULL, 0,NULL, 'Buckinghamshire', 1),
('8005', 8001, NULL, 0,NULL, 'Cambridgeshire', 1),
('8006', 8001, NULL, 0,NULL, 'Cheshire', 1),
('8007', 8001, NULL, 0,NULL, 'Cleveland', 1),
('8008', 8001, NULL, 0,NULL, 'Cornwall', 1),
('8009', 8001, NULL, 0,NULL, 'Cumberland', 1),
('8010', 8001, NULL, 0,NULL, 'Cumbria', 1),
('8011', 8001, NULL, 0,NULL, 'Derbyshire', 1),
('8012', 8001, NULL, 0,NULL, 'Devon', 1),
('8013', 8001, NULL, 0,NULL, 'Dorset', 1),
('8014', 8001, NULL, 0,NULL, 'Co. Durham', 1),
('8015', 8001, NULL, 0,NULL, 'East Riding of Yorkshire', 1),
('8016', 8001, NULL, 0,NULL, 'East Sussex', 1),
('8017', 8001, NULL, 0,NULL, 'Essex', 1),
('8018', 8001, NULL, 0,NULL, 'Gloucestershire', 1),
('8019', 8001, NULL, 0,NULL, 'Greater Manchester', 1),
('8020', 8001, NULL, 0,NULL, 'Hampshire', 1),
('8021', 8001, NULL, 0,NULL, 'Hertfordshire', 1),
('8022', 8001, NULL, 0,NULL, 'Hereford and Worcester', 1),
('8023', 8001, NULL, 0,NULL, 'Herefordshire', 1),
('8024', 8001, NULL, 0,NULL, 'Huntingdonshire', 1),
('8025', 8001, NULL, 0,NULL, 'Isle of Man', 1),
('8026', 8001, NULL, 0,NULL, 'Isle of Wight', 1),
('8027', 8001, NULL, 0,NULL, 'Jersey', 1),
('8028', 8001, NULL, 0,NULL, 'Kent', 1),
('8029', 8001, NULL, 0,NULL, 'Lancashire', 1),
('8030', 8001, NULL, 0,NULL, 'Leicestershire', 1),
('8031', 8001, NULL, 0,NULL, 'Lincolnshire', 1),
('8032', 8001, NULL, 0,NULL, 'London - City of London', 1),
('8033', 8001, NULL, 0,NULL, 'Merseyside', 1),
('8034', 8001, NULL, 0,NULL, 'Middlesex', 1),
('8035', 8001, NULL, 0,NULL, 'Norfolk', 1),
('8036', 8001, NULL, 0,NULL, 'North Yorkshire', 1),
('8037', 8001, NULL, 0,NULL, 'North Riding of Yorkshire', 1),
('8038', 8001, NULL, 0,NULL, 'Northamptonshire', 1),
('8039', 8001, NULL, 0,NULL, 'Northumberland', 1),
('8040', 8001, NULL, 0,NULL, 'Nottinghamshire', 1),
('8041', 8001, NULL, 0,NULL, 'Oxfordshire', 1),
('8042', 8001, NULL, 0,NULL, 'Rutland', 1),
('8043', 8001, NULL, 0,NULL, 'Shropshire', 1),
('8044', 8001, NULL, 0,NULL, 'Somerset', 1),
('8045', 8001, NULL, 0,NULL, 'Staffordshire', 1),
('8046', 8001, NULL, 0,NULL, 'Suffolk', 1),
('8047', 8001, NULL, 0,NULL, 'Surrey', 1),
('8048', 8001, NULL, 0,NULL, 'Sussex', 1),
('8049', 8001, NULL, 0,NULL, 'Tyne and Wear', 1),
('8050', 8001, NULL, 0,NULL, 'Warwickshire', 1),
('8051', 8001, NULL, 0,NULL, 'West Midlands', 1),
('8052', 8001, NULL, 0,NULL, 'West Sussex', 1),
('8053', 8001, NULL, 0,NULL, 'West Yorkshire', 1),
('8054', 8001, NULL, 0,NULL, 'West Riding of Yorkshire', 1),
('8055', 8001, NULL, 0,NULL, 'Wiltshire', 1),
('8056', 8001, NULL, 0,NULL, 'Worcestershire', 1),
('8057', 8001, NULL, 0,NULL, 'Yorkshire', 1);


-- Wales
INSERT INTO `llx_c_departements` (`code_departement`, `fk_region`, `cheflieu`, `tncc`, `ncc`, `nom`, `active`) VALUES
('8058', 8002, NULL, 0,NULL, 'Anglesey', 1),
('8059', 8002, NULL, 0,NULL, 'Breconshire', 1),
('8060', 8002, NULL, 0,NULL, 'Caernarvonshire', 1),
('8061', 8002, NULL, 0,NULL, 'Cardiganshire', 1),
('8062', 8002, NULL, 0,NULL, 'Carmarthenshire', 1),
('8063', 8002, NULL, 0,NULL, 'Ceredigion', 1),
('8064', 8002, NULL, 0,NULL, 'Denbighshire', 1),
('8065', 8002, NULL, 0,NULL, 'Flintshire', 1),
('8066', 8002, NULL, 0,NULL, 'Glamorgan', 1),
('8067', 8002, NULL, 0,NULL, 'Gwent', 1),
('8068', 8002, NULL, 0,NULL, 'Gwynedd', 1),
('8069', 8002, NULL, 0,NULL, 'Merionethshire', 1),
('8070', 8002, NULL, 0,NULL, 'Monmouthshire', 1),
('8071', 8002, NULL, 0,NULL, 'Mid Glamorgan', 1),
('8072', 8002, NULL, 0,NULL, 'Montgomeryshire', 1),
('8073', 8002, NULL, 0,NULL, 'Pembrokeshire', 1),
('8074', 8002, NULL, 0,NULL, 'Powys', 1),
('8075', 8002, NULL, 0,NULL, 'Radnorshire', 1),
('8076', 8002, NULL, 0,NULL, 'South Glamorgan', 1);

-- Scotland
INSERT INTO `llx_c_departements` (`code_departement`, `fk_region`, `cheflieu`, `tncc`, `ncc`, `nom`, `active`) VALUES
('8077', 8003, NULL, 0,NULL, 'Aberdeen, City of', 1),
('8078', 8003, NULL, 0,NULL, 'Angus', 1),
('8079', 8003, NULL, 0,NULL, 'Argyll', 1),
('8080', 8003, NULL, 0,NULL, 'Ayrshire', 1),
('8081', 8003, NULL, 0,NULL, 'Banffshire', 1),
('8082', 8003, NULL, 0,NULL, 'Berwickshire', 1),
('8083', 8003, NULL, 0,NULL, 'Bute', 1),
('8084', 8003, NULL, 0,NULL, 'Caithness', 1),
('8085', 8003, NULL, 0,NULL, 'Clackmannanshire', 1),
('8086', 8003, NULL, 0,NULL, 'Dumfriesshire', 1),
('8087', 8003, NULL, 0,NULL, 'Dumbartonshire', 1),
('8088', 8003, NULL, 0,NULL, 'Dundee, City of', 1),
('8089', 8003, NULL, 0,NULL, 'East Lothian', 1),
('8090', 8003, NULL, 0,NULL, 'Fife', 1),
('8091', 8003, NULL, 0,NULL, 'Inverness', 1),
('8092', 8003, NULL, 0,NULL, 'Kincardineshire', 1),
('8093', 8003, NULL, 0,NULL, 'Kinross-shire', 1),
('8094', 8003, NULL, 0,NULL, 'Kirkcudbrightshire', 1),
('8095', 8003, NULL, 0,NULL, 'Lanarkshire', 1),
('8096', 8003, NULL, 0,NULL, 'Midlothian', 1),
('8097', 8003, NULL, 0,NULL, 'Morayshire', 1),
('8098', 8003, NULL, 0,NULL, 'Nairnshire', 1),
('8099', 8003, NULL, 0,NULL, 'Orkney', 1),
('8100', 8003, NULL, 0,NULL, 'Peebleshire', 1),
('8101', 8003, NULL, 0,NULL, 'Perthshire', 1),
('8102', 8003, NULL, 0,NULL, 'Renfrewshire', 1),
('8103', 8003, NULL, 0,NULL, 'Ross & Cromarty', 1),
('8104', 8003, NULL, 0,NULL, 'Roxburghshire', 1),
('8105', 8003, NULL, 0,NULL, 'Selkirkshire', 1),
('8106', 8003, NULL, 0,NULL, 'Shetland', 1),
('8107', 8003, NULL, 0,NULL, 'Stirlingshire', 1),
('8108', 8003, NULL, 0,NULL, 'Sutherland', 1),
('8109', 8003, NULL, 0,NULL, 'West Lothian', 1),
('8110', 8003, NULL, 0,NULL, 'Wigtownshire', 1);



-- Northern Ireland
INSERT INTO `llx_c_departements` (`code_departement`, `fk_region`, `cheflieu`, `tncc`, `ncc`, `nom`, `active`) VALUES
('8111', 8004, NULL, 0,NULL, 'Antrim', 1),
('8112', 8004, NULL, 0,NULL, 'Armagh', 1),
('8113', 8004, NULL, 0,NULL, 'Co. Down', 1),
('8114', 8004, NULL, 0,NULL, 'Co. Fermanagh', 1),
('8115', 8004, NULL, 0,NULL, 'Co. Londonderry', 1);