create database adressbuch 
CHARACTER SET = 'utf8'
COLLATE = 'utf8_general_ci';

CREATE TABLE `country` (
  `country_id` varchar(2) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `iso3` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;