SQL insert of continents incl. short codes

continents.sql

CREATE TABLE `common_continents` (
  `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_continents (code,name) values ('AF','Africa');
insert into common_continents (code,name) values ('AN','Antarctica');
insert into common_continents (code,name) values ('AS','Asien');
insert into common_continents (code,name) values ('EU','Europe');
insert into common_continents (code,name) values ('NA','North America');
insert into common_continents (code,name) values ('OC','Oceania');
insert into common_continents (code,name) values ('SA','South America');