CREATE DATABASE `mapsomestuff` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `mapsomestuff`;

CREATE TABLE `items` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `description` varchar(150) NOT NULL,
  `street` varchar(50) NOT NULL,
  `nr` varchar(15) NOT NULL,
  `zip` varchar(15) NOT NULL,
  `town` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `items` VALUES (1, 'Basel SBB', 'Railwaystation Basel SBB', 'Centralbahnplatz', '1', '4051', 'Basel', 'Switzerland');