--
-- Table structure for table `dog_license2011`
--
CREATE TABLE IF NOT EXISTS `dog_license2011` (
`firstname` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`lastname` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`streetnumber` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`street` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`pobox` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`city` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`zip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`year` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
KEY `Index` (`firstname`,`lastname`,`streetnumber`,`street`,`city`,`zip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;