CREATE TABLE `addresses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(20),
  `lastname` varchar(20),
  `street` varchar(40),
  `city` varchar(28),
  `state` varchar(2),
  `zip` varchar(10),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  AUTO_INCREMENT=5 ;

INSERT INTO `addresses` (`id`, `firstname`, `lastname`, `street`, `city`, `state`, `zip`) VALUES 
(1, 'John', 'Doe', '4321 Overland Dr', 'Seattle', 'WA', '98101'),
(2, 'Paul', 'Smith', '5432 Elm Street', 'Seattle', 'WA', '98101'),
(3, 'Sandra', 'Jones', '8521 Ridge Road', 'Seattle', 'WA', '98101-8521'),
(4, 'Sue', 'Thomas', '8877 First Ave, Apt 45', 'Seattle', 'WA', '98101');