SQL insert of german states aka Bundesländer incl. short codes

de-bundeslaender.sql

CREATE TABLE `common_de_bundeslaender` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` char(2) NOT NULL DEFAULT '',
  `name` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into common_de_bundeslaender (code,name) values ('BW','Baden-Württemberg');
insert into common_de_bundeslaender (code,name) values ('BY','Bayern');
insert into common_de_bundeslaender (code,name) values ('BE','Berlin');
insert into common_de_bundeslaender (code,name) values ('BB','Brandenburg');
insert into common_de_bundeslaender (code,name) values ('HB','Bremen');
insert into common_de_bundeslaender (code,name) values ('HH','Hamburg');
insert into common_de_bundeslaender (code,name) values ('HE','Hessen');
insert into common_de_bundeslaender (code,name) values ('MV','Mecklenburg-Vorpommern');
insert into common_de_bundeslaender (code,name) values ('NI','Niedersachsen');
insert into common_de_bundeslaender (code,name) values ('NW','Nordrhein-Westfalen');
insert into common_de_bundeslaender (code,name) values ('RP','Rheinland-Pfalz');
insert into common_de_bundeslaender (code,name) values ('SL','Saarland');
insert into common_de_bundeslaender (code,name) values ('SN','Sachsen');
insert into common_de_bundeslaender (code,name) values ('ST','Sachsen-Anhalt');
insert into common_de_bundeslaender (code,name) values ('SH','Schleswig-Holstein');
insert into common_de_bundeslaender (code,name) values ('TH','Thüringen');