CREATE TABLE `neumann_addresses` (
	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	`street` varchar(64) COLLATE utf8_czech_ci NOT NULL,
	`no` int(11) NOT NULL,
	`city` varchar(64) COLLATE utf8_czech_ci NOT NULL,
	`zip` varchar(5) COLLATE utf8_czech_ci NOT NULL,
	PRIMARY KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;

INSERT INTO `neumann_addresses` (`id`, `street`, `no`, `city`, `zip`) VALUES
(1, 'Univerzitní', 8, 'Plzeň', '30614'),
(2, 'Klatovská', 16, 'Plzeň', '32123'),
(3, 'Tylova', 40, 'Plzeň', '33341'),
(4, 'Žlutická', 1, 'Plzeň', '32300'),
(5, 'Žitná', 5, 'Praha', '12345'),
(6, 'Ječná', 8, 'Praha', '12345');
