list of european countries 2013, taken from http://en.wikipedia.org/wiki/List_of_sovereign_states_and_dependent_territories_in_Europe written in sql, ready to insert

eu_countries.sql

CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;

INSERT INTO `countries` (`id`, `name`) VALUES
(1, 'Albania'),
(2, 'Andorra'),
(3, 'Armenia'),
(4, 'Austria'),
(5, 'Azerbaijan'),
(6, 'Belarus'),
(7, 'Belgium'),
(8, 'Bosnia and Herzegovina'),
(9, 'Bulgaria'),
(10, 'Croatia'),
(11, 'Cyprus'),
(12, 'Czech Republic'),
(13, 'Denmark'),
(14, 'Estonia'),
(15, 'Finland'),
(16, 'France'),
(17, 'Georgia'),
(18, 'Germany'),
(19, 'Greece'),
(20, 'Hungary'),
(21, 'Iceland'),
(22, 'Ireland'),
(23, 'Italy'),
(24, 'Kazakhstan'),
(25, 'Latvia'),
(26, 'Liechtenstein'),
(27, 'Lithuania'),
(28, 'Luxembourg'),
(29, 'Macedonia'),
(30, 'Malta'),
(31, 'Moldova, Republic of'),
(32, 'Monaco'),
(33, 'Montenegro'),
(34, 'Netherlands'),
(35, 'Norway'),
(36, 'Poland'),
(37, 'Portugal'),
(38, 'Romania'),
(39, 'Russia'),
(40, 'San Marino'),
(41, 'Serbia'),
(42, 'Slovakia'),
(43, 'Slovenia'),
(44, 'Spain'),
(45, 'Sweden'),
(46, 'Switzerland'),
(47, 'Turkey'),
(48, 'Ukraine'),
(49, 'United Kingdom'),
(50, 'Vatican City');