Unnamed

CREATE TABLE `lines` (  `id` int(11) NOT NULL auto_increment,  `number` int(11) default NULL,  `direction` char(1) default NULL,  `street` varchar(128) default NULL,  PRIMARY KEY  (`id`),  UNIQUE KEY `uniqueness` (`number`,`direction`)) ENGINE=InnoDB DEFAULT CHARSET=latin1