Hi René
hier die Ergänzung für GB. Quelle ist Wikipaedia. Vorher unbedingt eine Datensicherung der Tabelle ZONES in der Datenbank vornehmen.
1. Prüfen, ob GB die Nummer 222 hat
SELECT countries_id FROM countries WHERE countries_iso_code_2='GB';
Wenn Nein, die 222 im folgenden Abschnitt durch die angezeigte ID des vorherigen SQL-Statements ersetzen.
Wenn Ja, dann den folgenden Abschnitt ausführen:
DELETE FROM zones WHERE zone_country_id=222;
INSERT INTO zones VALUES (NULL,222,"BKM","England - Buckinghamshire");
INSERT INTO zones VALUES (NULL,222,"CAM","England - Cambridgeshire");
INSERT INTO zones VALUES (NULL,222,"CMA","England - Cumbria");
INSERT INTO zones VALUES (NULL,222,"DBY","England - Derbyshire");
INSERT INTO zones VALUES (NULL,222,"DEV","England - Devon");
INSERT INTO zones VALUES (NULL,222,"DOR","England - Dorset");
INSERT INTO zones VALUES (NULL,222,"ESX","England - East Sussex");
INSERT INTO zones VALUES (NULL,222,"ESS","England - Essex");
INSERT INTO zones VALUES (NULL,222,"GLS","England - Gloucestershire");
INSERT INTO zones VALUES (NULL,222,"HAM","England - Hampshire");
INSERT INTO zones VALUES (NULL,222,"HRT","England - Hertfordshire");
INSERT INTO zones VALUES (NULL,222,"KEN","England - Kent");
INSERT INTO zones VALUES (NULL,222,"LAN","England - Lancashire");
INSERT INTO zones VALUES (NULL,222,"LEC","England - Leicestershire");
INSERT INTO zones VALUES (NULL,222,"LIN","England - Lincolnshire");
INSERT INTO zones VALUES (NULL,222,"NFK","England - Norfolk");
INSERT INTO zones VALUES (NULL,222,"NYK","England - North Yorkshire");
INSERT INTO zones VALUES (NULL,222,"NTH","England - Northamptonshire");
INSERT INTO zones VALUES (NULL,222,"NTT","England - Nottinghamshire");
INSERT INTO zones VALUES (NULL,222,"OXF","England - Oxfordshire");
INSERT INTO zones VALUES (NULL,222,"SOM","England - Somerset");
INSERT INTO zones VALUES (NULL,222,"STS","England - Staffordshire");
INSERT INTO zones VALUES (NULL,222,"SFK","England - Suffolk");
INSERT INTO zones VALUES (NULL,222,"SRY","England - Surrey");
INSERT INTO zones VALUES (NULL,222,"WAR","England - Warwickshire");
INSERT INTO zones VALUES (NULL,222,"WSX","England - West Sussex");
INSERT INTO zones VALUES (NULL,222,"WOR","England - Worcestershire");
INSERT INTO zones VALUES (NULL,222,"BDG","England - Barking and Dagenham");
INSERT INTO zones VALUES (NULL,222,"BNE","England - Barnet");
INSERT INTO zones VALUES (NULL,222,"BEX","England - Bexley");
INSERT INTO zones VALUES (NULL,222,"BEN","England - Brent");
INSERT INTO zones VALUES (NULL,222,"BRY","England - Bromley");
INSERT INTO zones VALUES (NULL,222,"CMD","England - Camden");
INSERT INTO zones VALUES (NULL,222,"CRY","England - Croydon");
INSERT INTO zones VALUES (NULL,222,"EAL","England - Ealing");
INSERT INTO zones VALUES (NULL,222,"ENF","England - Enfield");
INSERT INTO zones VALUES (NULL,222,"GRE","England - Greenwich");
INSERT INTO zones VALUES (NULL,222,"HCK","England - Hackney");
INSERT INTO zones VALUES (NULL,222,"HMF","England - Hammersmith and Fulham");
INSERT INTO zones VALUES (NULL,222,"HRY","England - Haringey");
INSERT INTO zones VALUES (NULL,222,"HRW","England - Harrow");
INSERT INTO zones VALUES (NULL,222,"HAV","England - Havering");
INSERT INTO zones VALUES (NULL,222,"HIL","England - Hillingdon");
INSERT INTO zones VALUES (NULL,222,"HNS","England - Hounslow");
INSERT INTO zones VALUES (NULL,222,"ISL","England - Islington");
INSERT INTO zones VALUES (NULL,222,"KEC","England - Kensington and Chelsea");
INSERT INTO zones VALUES (NULL,222,"KTT","England - Kingston upon Thames");
INSERT INTO zones VALUES (NULL,222,"LBH","England - Lambeth");
INSERT INTO zones VALUES (NULL,222,"LEW","England - Lewisham");
INSERT INTO zones VALUES (NULL,222,"MRT","England - Merton");
INSERT INTO zones VALUES (NULL,222,"NWM","England - Newham");
INSERT INTO zones VALUES (NULL,222,"RDB","England - Redbridge");
INSERT INTO zones VALUES (NULL,222,"RIC","England - Richmond upon Thames");
INSERT INTO zones VALUES (NULL,222,"SWK","England - Southwark");
INSERT INTO zones VALUES (NULL,222,"STN","England - Sutton");
INSERT INTO zones VALUES (NULL,222,"TWH","England - Tower Hamlets");
INSERT INTO zones VALUES (NULL,222,"WFT","England - Waltham Forest");
INSERT INTO zones VALUES (NULL,222,"WND","England - Wandsworth");
INSERT INTO zones VALUES (NULL,222,"WSM","England - Westminster");
INSERT INTO zones VALUES (NULL,222,"BNS","England - Barnsley");
INSERT INTO zones VALUES (NULL,222,"BIR","England - Birmingham");
INSERT INTO zones VALUES (NULL,222,"BOL","England - Bolton");
INSERT INTO zones VALUES (NULL,222,"BRD","England - Bradford");
INSERT INTO zones VALUES (NULL,222,"BUR","England - Bury");
INSERT INTO zones VALUES (NULL,222,"CLD","England - Calderdale");
INSERT INTO zones VALUES (NULL,222,"COV","England - Coventry");
INSERT INTO zones VALUES (NULL,222,"DNC","England - Doncaster");
INSERT INTO zones VALUES (NULL,222,"DUD","England - Dudley");
INSERT INTO zones VALUES (NULL,222,"GAT","England - Gateshead");
INSERT INTO zones VALUES (NULL,222,"KIR","England - Kirklees");
INSERT INTO zones VALUES (NULL,222,"KWL","England - Knowsley");
INSERT INTO zones VALUES (NULL,222,"LDS","England - Leeds");
INSERT INTO zones VALUES (NULL,222,"LIV","England - Liverpool");
INSERT INTO zones VALUES (NULL,222,"MAN","England - Manchester");
INSERT INTO zones VALUES (NULL,222,"NET","England - Newcastle upon Tyne");
INSERT INTO zones VALUES (NULL,222,"NTY","England - North Tyneside");
INSERT INTO zones VALUES (NULL,222,"OLD","England - Oldham");
INSERT INTO zones VALUES (NULL,222,"RCH","England - Rochdale");
INSERT INTO zones VALUES (NULL,222,"ROT","England - Rotherham");
INSERT INTO zones VALUES (NULL,222,"SHN","England - St. Helens");
INSERT INTO zones VALUES (NULL,222,"SLF","England - Salford");
INSERT INTO zones VALUES (NULL,222,"SAW","England - Sandwell");
INSERT INTO zones VALUES (NULL,222,"SFT","England - Sefton");
INSERT INTO zones VALUES (NULL,222,"SHF","England - Sheffield");
INSERT INTO zones VALUES (NULL,222,"SOL","England - Solihull");
INSERT INTO zones VALUES (NULL,222,"STY","England - South Tyneside");
INSERT INTO zones VALUES (NULL,222,"SKP","England - Stockport");
INSERT INTO zones VALUES (NULL,222,"SND","England - Sunderland");
INSERT INTO zones VALUES (NULL,222,"TAM","England - Tameside");
INSERT INTO zones VALUES (NULL,222,"TRF","England - Trafford");
INSERT INTO zones VALUES (NULL,222,"WKF","England - Wakefield");
INSERT INTO zones VALUES (NULL,222,"WLL","England - Walsall");
INSERT INTO zones VALUES (NULL,222,"WGN","England - Wigan");
INSERT INTO zones VALUES (NULL,222,"WRL","England - Wirral");
INSERT INTO zones VALUES (NULL,222,"WLV","England - Wolverhampton");
INSERT INTO zones VALUES (NULL,222,"BAS","England - Bath and North East Somerset");
INSERT INTO zones VALUES (NULL,222,"BBD","England - Blackburn with Darwen");
INSERT INTO zones VALUES (NULL,222,"BDF","England - Bedford");
INSERT INTO zones VALUES (NULL,222,"BPL","England - Blackpool");
INSERT INTO zones VALUES (NULL,222,"BMH","England - Bournemouth");
INSERT INTO zones VALUES (NULL,222,"BRC","England - Bracknell Forest");
INSERT INTO zones VALUES (NULL,222,"BNH","England - Brighton and Hove");
INSERT INTO zones VALUES (NULL,222,"BST","England - Bristol, City of");
INSERT INTO zones VALUES (NULL,222,"CBF","England - Central Bedfordshire");
INSERT INTO zones VALUES (NULL,222,"CHE","England - Cheshire East");
INSERT INTO zones VALUES (NULL,222,"CHW","England - Cheshire West and Chester");
INSERT INTO zones VALUES (NULL,222,"CON","England - Cornwall");
INSERT INTO zones VALUES (NULL,222,"DAL","England - Darlington");
INSERT INTO zones VALUES (NULL,222,"DER","England - Derby");
INSERT INTO zones VALUES (NULL,222,"DUR","England - Durham, County");
INSERT INTO zones VALUES (NULL,222,"ERY","England - East Riding of Yorkshire");
INSERT INTO zones VALUES (NULL,222,"HAL","England - Halton");
INSERT INTO zones VALUES (NULL,222,"HPL","England - Hartlepool");
INSERT INTO zones VALUES (NULL,222,"HEF","England - Herefordshire");
INSERT INTO zones VALUES (NULL,222,"IOW","England - Isle of Wight");
INSERT INTO zones VALUES (NULL,222,"KHL","England - Kingston upon Hull");
INSERT INTO zones VALUES (NULL,222,"LCE","England - Leicester");
INSERT INTO zones VALUES (NULL,222,"LUT","England - Luton");
INSERT INTO zones VALUES (NULL,222,"MDW","England - Medway");
INSERT INTO zones VALUES (NULL,222,"MDB","England - Middlesbrough");
INSERT INTO zones VALUES (NULL,222,"MIK","England - Milton Keynes");
INSERT INTO zones VALUES (NULL,222,"NEL","England - North East Lincolnshire");
INSERT INTO zones VALUES (NULL,222,"NLN","England - North Lincolnshire");
INSERT INTO zones VALUES (NULL,222,"NSM","England - North Somerset");
INSERT INTO zones VALUES (NULL,222,"NBL","England - Northumberland");
INSERT INTO zones VALUES (NULL,222,"NGM","England - Nottingham");
INSERT INTO zones VALUES (NULL,222,"PTE","England - Peterborough");
INSERT INTO zones VALUES (NULL,222,"PLY","England - Plymouth");
INSERT INTO zones VALUES (NULL,222,"POL","England - Poole");
INSERT INTO zones VALUES (NULL,222,"POR","England - Portsmouth");
INSERT INTO zones VALUES (NULL,222,"RDG","England - Reading");
INSERT INTO zones VALUES (NULL,222,"RCC","England - Redcar and Cleveland");
INSERT INTO zones VALUES (NULL,222,"RUT","England - Rutland");
INSERT INTO zones VALUES (NULL,222,"SHR","England - Shropshire");
INSERT INTO zones VALUES (NULL,222,"SLG","England - Slough");
INSERT INTO zones VALUES (NULL,222,"SGC","England - South Gloucestershire");
INSERT INTO zones VALUES (NULL,222,"STH","England - Southampton");
INSERT INTO zones VALUES (NULL,222,"SOS","England - Southend-on-Sea");
INSERT INTO zones VALUES (NULL,222,"STT","England - Stockton-on-Tees");
INSERT INTO zones VALUES (NULL,222,"STE","England - Stoke-on-Trent");
INSERT INTO zones VALUES (NULL,222,"SWD","England - Swindon");
INSERT INTO zones VALUES (NULL,222,"TFW","England - Telford and Wrekin");
INSERT INTO zones VALUES (NULL,222,"THR","England - Thurrock");
INSERT INTO zones VALUES (NULL,222,"TOB","England - Torbay");
INSERT INTO zones VALUES (NULL,222,"WRT","England - Warrington");
INSERT INTO zones VALUES (NULL,222,"WBK","England - West Berkshire");
INSERT INTO zones VALUES (NULL,222,"WIL","England - Wiltshire");
INSERT INTO zones VALUES (NULL,222,"WNM","England - Windsor and Maidenhead");
INSERT INTO zones VALUES (NULL,222,"WOK","England - Wokingham");
INSERT INTO zones VALUES (NULL,222,"YOR","England - York");
INSERT INTO zones VALUES (NULL,222,"LND","England - London, City of");
INSERT INTO zones VALUES (NULL,222,"ANT","Northern Ireland - Antrim");
INSERT INTO zones VALUES (NULL,222,"ARD","Northern Ireland - Ards");
INSERT INTO zones VALUES (NULL,222,"ARM","Northern Ireland - Armagh");
INSERT INTO zones VALUES (NULL,222,"BLA","Northern Ireland - Ballymena");
INSERT INTO zones VALUES (NULL,222,"BLY","Northern Ireland - Ballymoney");
INSERT INTO zones VALUES (NULL,222,"BNB","Northern Ireland - Banbridge");
INSERT INTO zones VALUES (NULL,222,"BFS","Northern Ireland - Belfast");
INSERT INTO zones VALUES (NULL,222,"CKF","Northern Ireland - Carrickfergus");
INSERT INTO zones VALUES (NULL,222,"CSR","Northern Ireland - Castlereagh");
INSERT INTO zones VALUES (NULL,222,"CLR","Northern Ireland - Coleraine");
INSERT INTO zones VALUES (NULL,222,"CKT","Northern Ireland - Cookstown");
INSERT INTO zones VALUES (NULL,222,"CGV","Northern Ireland - Craigavon");
INSERT INTO zones VALUES (NULL,222,"DRY","Northern Ireland - Derry");
INSERT INTO zones VALUES (NULL,222,"DOW","Northern Ireland - Down");
INSERT INTO zones VALUES (NULL,222,"DGN","Northern Ireland - Dungannon and South Tyrone");
INSERT INTO zones VALUES (NULL,222,"FER","Northern Ireland - Fermanagh");
INSERT INTO zones VALUES (NULL,222,"LRN","Northern Ireland - Larne");
INSERT INTO zones VALUES (NULL,222,"LMV","Northern Ireland - Limavady");
INSERT INTO zones VALUES (NULL,222,"LSB","Northern Ireland - Lisburn");
INSERT INTO zones VALUES (NULL,222,"MFT","Northern Ireland - Magherafelt");
INSERT INTO zones VALUES (NULL,222,"MYL","Northern Ireland - Moyle");
INSERT INTO zones VALUES (NULL,222,"NYM","Northern Ireland - Newry and Mourne District");
INSERT INTO zones VALUES (NULL,222,"NTA","Northern Ireland - Newtownabbey");
INSERT INTO zones VALUES (NULL,222,"NDN","Northern Ireland - North Down");
INSERT INTO zones VALUES (NULL,222,"OMH","Northern Ireland - Omagh");
INSERT INTO zones VALUES (NULL,222,"STB","Northern Ireland - Strabane");
INSERT INTO zones VALUES (NULL,222,"ABE","Scotland - Aberdeen City");
INSERT INTO zones VALUES (NULL,222,"ABD","Scotland - Aberdeenshire");
INSERT INTO zones VALUES (NULL,222,"ANS","Scotland - Angus");
INSERT INTO zones VALUES (NULL,222,"AGB","Scotland - Argyll and Bute");
INSERT INTO zones VALUES (NULL,222,"CLK","Scotland - Clackmannanshire");
INSERT INTO zones VALUES (NULL,222,"DGY","Scotland - Dumfries and Galloway");
INSERT INTO zones VALUES (NULL,222,"DND","Scotland - Dundee City");
INSERT INTO zones VALUES (NULL,222,"EAY","Scotland - East Ayrshire");
INSERT INTO zones VALUES (NULL,222,"EDU","Scotland - East Dunbartonshire");
INSERT INTO zones VALUES (NULL,222,"ELN","Scotland - East Lothian");
INSERT INTO zones VALUES (NULL,222,"ERW","Scotland - East Renfrewshire");
INSERT INTO zones VALUES (NULL,222,"EDH","Scotland - Edinburgh, City of");
INSERT INTO zones VALUES (NULL,222,"ELS","Scotland - Eilean Siar");
INSERT INTO zones VALUES (NULL,222,"FAL","Scotland - Falkirk");
INSERT INTO zones VALUES (NULL,222,"FIF","Scotland - Fife");
INSERT INTO zones VALUES (NULL,222,"GLG","Scotland - Glasgow City");
INSERT INTO zones VALUES (NULL,222,"HLD","Scotland - Highland");
INSERT INTO zones VALUES (NULL,222,"IVC","Scotland - Inverclyde");
INSERT INTO zones VALUES (NULL,222,"MLN","Scotland - Midlothian");
INSERT INTO zones VALUES (NULL,222,"MRY","Scotland - Moray");
INSERT INTO zones VALUES (NULL,222,"NAY","Scotland - North Ayrshire");
INSERT INTO zones VALUES (NULL,222,"NLK","Scotland - North Lanarkshire");
INSERT INTO zones VALUES (NULL,222,"ORK","Scotland - Orkney Islands");
INSERT INTO zones VALUES (NULL,222,"PKN","Scotland - Perth and Kinross");
INSERT INTO zones VALUES (NULL,222,"RFW","Scotland - Renfrewshire");
INSERT INTO zones VALUES (NULL,222,"SCB","Scotland - Scottish Borders, The");
INSERT INTO zones VALUES (NULL,222,"ZET","Scotland - Shetland Islands");
INSERT INTO zones VALUES (NULL,222,"SAY","Scotland - South Ayrshire");
INSERT INTO zones VALUES (NULL,222,"SLK","Scotland - South Lanarkshire");
INSERT INTO zones VALUES (NULL,222,"STG","Scotland - Stirling");
INSERT INTO zones VALUES (NULL,222,"WDU","Scotland - West Dunbartonshire");
INSERT INTO zones VALUES (NULL,222,"WLN","Scotland - West Lothian");
INSERT INTO zones VALUES (NULL,222,"BGW","Wales - Blaenau Gwent");
INSERT INTO zones VALUES (NULL,222,"BGE","Wales - Bridgend [Pen-y-bont ar Ogwr GB-POG]");
INSERT INTO zones VALUES (NULL,222,"CAY","Wales - Caerphilly [Caerffili GB-CAF]");
INSERT INTO zones VALUES (NULL,222,"CRF","Wales - Cardiff [Caerdydd GB-CRD]");
INSERT INTO zones VALUES (NULL,222,"CMN","Wales - Carmarthenshire [Sir Gaerfyrddin GB-GFY]");
INSERT INTO zones VALUES (NULL,222,"CGN","Wales - Ceredigion [Sir Ceredigion]");
INSERT INTO zones VALUES (NULL,222,"CWY","Wales - Conwy");
INSERT INTO zones VALUES (NULL,222,"DEN","Wales - Denbighshire [Sir Ddinbych GB-DDB]");
INSERT INTO zones VALUES (NULL,222,"FLN","Wales - Flintshire [Sir y Fflint GB-FFL]");
INSERT INTO zones VALUES (NULL,222,"GWN","Wales - Gwynedd");
INSERT INTO zones VALUES (NULL,222,"AGY","Wales - Isle of Anglesey [Sir Ynys Môn GB-YNM]");
INSERT INTO zones VALUES (NULL,222,"MTY","Wales - Merthyr Tydfil [Merthyr Tudful GB-MTU]");
INSERT INTO zones VALUES (NULL,222,"MON","Wales - Monmouthshire [Sir Fynwy GB-FYN]");
INSERT INTO zones VALUES (NULL,222,"NTL","Wales - Neath Port Talbot [Castell-nedd Port Talbot GB-CTL]");
INSERT INTO zones VALUES (NULL,222,"NWP","Wales - Newport [Casnewydd GB-CNW]");
INSERT INTO zones VALUES (NULL,222,"PEM","Wales - Pembrokeshire [Sir Benfro GB-BNF]");
INSERT INTO zones VALUES (NULL,222,"POW","Wales - Powys");
INSERT INTO zones VALUES (NULL,222,"RCT","Wales - Rhondda, Cynon, Taff [Rhondda, Cynon, Taf]");
INSERT INTO zones VALUES (NULL,222,"SWA","Wales - Swansea [Abertawe GB-ATA]");
INSERT INTO zones VALUES (NULL,222,"TOF","Wales - Torfaen [Tor-faen]");
INSERT INTO zones VALUES (NULL,222,"VGL","Wales - Vale of Glamorgan, The [Bro Morgannwg GB-BMG]");
INSERT INTO zones VALUES (NULL,222,"WRX","Wales - Wrexham [Wrecsam GB-WRC]");
Gruß
billybob
PS: Vielleicht kann das in den nächsten Release aufgenommen werden.