Miscellany

CREATE TABLE `addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `address_type` varchar(7) NOT NULL,
  `address` varchar(255) NOT NULL,
  `unit` varchar(100) NOT NULL,
  `city` varchar(35) NOT NULL,
  `state` char(2) NOT NULL,
  `zipcode` int(10) unsigned zerofill NOT NULL,
  PRIMARY KEY (`id`,`lead_id`),
  UNIQUE KEY `id` (`id`),
  KEY `city` (`city`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1);


CREATE TABLE `GreatData` (
  `zip` int(5) unsigned zerofill NOT NULL,
  `State` char(2) NOT NULL,
  `city` varchar(35) NOT NULL,
  `county` varchar(45) NOT NULL,
  KEY `zip` (`zip`),
  KEY `city` (`city`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8);