SQL insert of swiss states aka Kantone incl. short codes

ch-kantone.sql

CREATE TABLE `common_ch_kantone` (
  `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_ch_kantone (code,name) values ('AG','Aargau');
insert into common_ch_kantone (code,name) values ('AR','Appenzell Ausserrhoden');
insert into common_ch_kantone (code,name) values ('AI','Appenzell Innerrhoden');
insert into common_ch_kantone (code,name) values ('BL','Basel-Landschaft');
insert into common_ch_kantone (code,name) values ('BS','Basel-Stadt');
insert into common_ch_kantone (code,name) values ('BE','Bern');
insert into common_ch_kantone (code,name) values ('FR','Freiburg');
insert into common_ch_kantone (code,name) values ('GE','Genf');
insert into common_ch_kantone (code,name) values ('GL','Glarus');
insert into common_ch_kantone (code,name) values ('GR','Graubünden');
insert into common_ch_kantone (code,name) values ('JU','Jura');
insert into common_ch_kantone (code,name) values ('Lu','Luzern');
insert into common_ch_kantone (code,name) values ('Ne','Neuenburg');
insert into common_ch_kantone (code,name) values ('Nw','Nidwalden');
insert into common_ch_kantone (code,name) values ('OW','Obwalden');
insert into common_ch_kantone (code,name) values ('SH','Schaffhausen');
insert into common_ch_kantone (code,name) values ('SZ','Schwyz');
insert into common_ch_kantone (code,name) values ('SO','Solothurn');
insert into common_ch_kantone (code,name) values ('SG','St. Gallen');
insert into common_ch_kantone (code,name) values ('TI','Tessin');
insert into common_ch_kantone (code,name) values ('TG','Thurgau');
insert into common_ch_kantone (code,name) values ('UR','Uri');
insert into common_ch_kantone (code,name) values ('VD','Waadt');
insert into common_ch_kantone (code,name) values ('VS','Wallis');
insert into common_ch_kantone (code,name) values ('ZG','Zug');
insert into common_ch_kantone (code,name) values ('ZH','Zürich');