CREATE TABLE `orte` (
  `ortsname` varchar(50) NOT NULL default '',
  KEY `ortsname` (`ortsname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `orte` VALUES ('Aachen');
INSERT INTO `orte` VALUES ('Berlin');
INSERT INTO `orte` VALUES ('Frankfurt');
INSERT INTO `orte` VALUES ('Hamburg');
INSERT INTO `orte` VALUES ('Hanover');
INSERT INTO `orte` VALUES ('Köln');
INSERT INTO `orte` VALUES ('München');
INSERT INTO `orte` VALUES ('Nürnberg');
INSERT INTO `orte` VALUES ('Stuttgart');
INSERT INTO `orte` VALUES ('Zwickau');