#4er Version

# aus einen Land werden drei: GB, GB ohne Nordirland und Nordirland

# Länder 
UPDATE land SET LandArtID = 3, aLandname ='Großbritannien' WHERE aKrzZeichen = 'GB';

INSERT INTO `land` (`LandID`, `SprachID`, `aLandname`, `aVorwahl`, `aKrzZeichen`, `WaehrungID`, `LandArtID`, `LandRegionID`, `BundeslandBezeichnungID`, `VersionHash`, `BlobFlagge`, `aIntrastatKrzZeichen`) VALUES
(19,20,'Nordirland ','44','XI',159,1,1,7,0,NULL,'XI'),
(20,20,'Vereinigtes Königreich Großbritannien ohne Nordirland','44','XU',159,3,1,7,0,NULL,'XU');

UPDATE land SET aLandnameENG='Great Britain',aLandnameSPA='Gran Bretaña',aLandnameFRE='Grande-Bretagne' WHERE aKrzZeichen ='GB';
UPDATE land SET aLandnameENG='Northern Ireland',aLandnameSPA='Irlanda del Norte',aLandnameFRE='Irlande du Nord' WHERE aLandname='Nordirland';
UPDATE land SET aLandnameENG='United Kingdom of Great Britain without Northern Ireland',aLandnameSPA='Reino Unido de Gran Bretaña sin Irlanda del Norte',
aLandnameFRE='Royaume-Uni sans l\'irlande du nord' WHERE aLandname='Vereinigtes Königreich Großbritannien ohne Nordirland';

UPDATE land SET aISO3166_A3='GBR' WHERE aLandname LIKE "%Großbritannien%" OR aLandname LIKE "%Nordirland%";

UPDATE Land SET blobFlagge=0x47494638396160004000A20000FF0000000080808080C0C0C0FFFFFF0000000000000000002C00000000600040004008FE0009081C482080C18308132A5CC8502080871005329C487122C18B03206A04709160C58F0E374AFC48B1E3C08D10078CA4A8924046941C4D0E284900E5CA852D3BC204D07226C99F1605BEDC98F3A24D99307302A5B8B3A9D3A750A34A9DAA7169C59E49758AC498D5A5D5AF0A0508DD5994A080852135DE3C281669D7B340C776ED08F76BDA8805C1B6ED3894E8488D6507FA04DBB0E656C21303CB7DA870B15F937549DE7DB8B6E25EAE5D11B3750CD82481BA93636E768BB265E49F9E53AB5E6DF228EBD7B0090E984DBBB6EDDBB873EB2EADBBB7EFDFB3110B9E8B314068898A5DCED58C93335EBEA80DABCDFB313959A10C617A1ECCDCB874BCDD0FFE5A276E363CDAEF94A99B1FCDF7BA4CF3C7D56B4EDE17A2C1B6F5537A3E1DFDA8DEEDEEF197504BEE4107127AA25507A0765E31871579039DE75F63A43DC6DD7A09ED552046F1D1B7D3400262F8D3839D19B5956CA561B71E552CB6E8E28B30C628E38C50C566236CAEDDA8A349DD9178A256D3B5D6D585221686E043F421141F421E32285F8FCE21E959454BD2D4DE904B1108A18A712158D9550B1E75A1725B7EC65C95885D866256FABD27229AEB35199381451A046791E3CD595C91779A97678A3CAED7A76661A6B46179677AF9E4576A0E9754005A024AA75D8A2226E75617FAD8E6A4FD1D66D5A56D129961943C4DD9E9745D5E09688813E1772888F254564A51A3A49AD6DD49658AEADD840A81FA5C9D9A4AE9E64177FA5A6A83753249EA7676CAFA6789BA262B5EADA9E58819A0D14ABB90AB105A4BE6AAE60920EEB8E4966BEEB997DD06E47382D96616BAF0C64BEB8E3B7A4B6FBD34E6ABEFBEFCF6EBEFBF00E77BEFC0F1114CEF9B9C05E66D7D4A69FB5F68C29A18E49AAEB1EAF068F9452CE4C4AA3E6631B0D406BAABA7DE750CADC3C1A6C7E9C8A80EE8997BD98295729285F1DA6BA1A1269AF1B1741D683343F3EEDCD252DC4A7AD1C74ACA4A52D001B6BAACA9560D7AE0C61E4FFB6D892B2F25F588380B2B34B3B72A3D5FD76522ADB5D8DD316DB447756E9DE8950101003B WHERE LandID=19;
UPDATE Land SET blobFlagge=0x47494638396160004000A20000FF0000000080808080C0C0C0FFFFFF0000000000000000002C00000000600040004008FE0009081C482080C18308132A5CC8502080871005329C487122C18B03206A04709160C58F0E374AFC48B1E3C08D10078CA4A8924046941C4D0E284900E5CA852D3BC204D07226C99F1605BEDC98F3A24D99307302A5B8B3A9D3A750A34A9DAA7169C59E49758AC498D5A5D5AF0A0508DD5994A080852135DE3C281669D7B340C776ED08F76BDA8805C1B6ED3894E8488D6507FA04DBB0E656C21303CB7DA870B15F937549DE7DB8B6E25EAE5D11B3750CD82481BA93636E768BB265E49F9E53AB5E6DF228EBD7B0090E984DBBB6EDDBB873EB2EADBBB7EFDFB3110B9E8B314068898A5DCED58C93335EBEA80DABCDFB313959A10C617A1ECCDCB874BCDD0FFE5A276E363CDAEF94A99B1FCDF7BA4CF3C7D56B4EDE17A2C1B6F5537A3E1DFDA8DEEDEEF197504BEE4107127AA25507A0765E31871579039DE75F63A43DC6DD7A09ED552046F1D1B7D3400262F8D3839D19B5956CA561B71E552CB6E8E28B30C628E38C50C566236CAEDDA8A349DD9178A256D3B5D6D585221686E043F421141F421E32285F8FCE21E959454BD2D4DE904B1108A18A712158D9550B1E75A1725B7EC65C95885D866256FABD27229AEB35199381451A046791E3CD595C91779A97678A3CAED7A76661A6B46179677AF9E4576A0E9754005A024AA75D8A2226E75617FAD8E6A4FD1D66D5A56D129961943C4DD9E9745D5E09688813E1772888F254564A51A3A49AD6DD49658AEADD840A81FA5C9D9A4AE9E64177FA5A6A83753249EA7676CAFA6789BA262B5EADA9E58819A0D14ABB90AB105A4BE6AAE60920EEB8E4966BEEB997DD06E47382D96616BAF0C64BEB8E3B7A4B6FBD34E6ABEFBEFCF6EBEFBF00E77BEFC0F1114CEF9B9C05E66D7D4A69FB5F68C29A18E49AAEB1EAF068F9452CE4C4AA3E6631B0D406BAABA7DE750CADC3C1A6C7E9C8A80EE8997BD98295729285F1DA6BA1A1269AF1B1741D683343F3EEDCD252DC4A7AD1C74ACA4A52D001B6BAACA9560D7AE0C61E4FFB6D892B2F25F588380B2B34B3B72A3D5FD76522ADB5D8DD316DB447756E9DE8950101003B WHERE LandID=20;

#bundesländer

SET @LID:=(SELECT LandID FROM land WHERE aKrzZeichen='XU' LIMIT 1);

INSERT INTO bundesland (LandID, aBundName, aIntrastatKuerzel) VALUES

#Vereinigtes Königreich ohne Nordirland
(@LID,'England',NULL),
(@LID,'Wales',NULL),
(@LID,'Schottland',NULL);