CREATE TABLE IF NOT EXISTS `contacts` (
  `contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `last_name` varchar(30) NOT NULL,
  `first_name` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `gender` char(1) NOT NULL,
  `birthday` date NOT NULL,
  `profession` varchar(50) NOT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` char(2) NOT NULL,
  `status` varchar(40) NOT NULL,
  `interests` varchar(100) NOT NULL,
  `seeking` varchar(100) NOT NULL,
  PRIMARY KEY (`contact_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

INSERT INTO `contacts` (`contact_id`, `last_name`, `first_name`, `email`, `gender`, `birthday`, `profession`, `city`, `state`, `status`, `interests`, `seeking`) VALUES
(1, 'Anderson', 'Jillian', 'jill_anderson@ breakneckpizza.com', 'F', '1980-09-05', 'Technical Writer', 'Palo Alto', 'CA', 'single', 'kayaking, reptiles, relationship', ' friends'),
(2, 'Kenton', 'Leo', 'lkenton@starbuzzcoffee.com', 'M', '1974-01-10', 'Manager', 'San Francisco', 'CA', 'divorced', 'women', 'women to date'),
(3, 'McGavin', 'Darrin', ' captainlove@headfirsttheater.com', 'M', '1966-01-23', 'Cruise Ship Captain', 'San Diego', 'CA', 'single', 'sailing, fishing, yachting', 'women for casual relationships'),
(4, 'Franklin', 'Joe', 'joe_franklin@leapinlimos.com', 'M', '1977-04-28', 'Software Sales', 'Dallas', 'TX', 'married', 'fishing, drinking', 'new job'),
(5, 'Hamilton', 'Jamie', 'dontbother@starbuzzcoffee.com', 'F', '1964-09-10', 'System Administrator', 'Princeton', 'NJ', 'married', 'RPG', 'nothing'),
(6, 'Chevrolet', 'Maurice', 'bookman4u@objectville.net', 'M', '1962-07-01', 'Bookshop Owner', 'Mountain View', 'CA', 'married', 'collecting books,scuba diving', 'friends'),
(7, 'Kroger', 'Renee', 'poorrenee@mightygumball.net', 'F', '1976-12-03', 'Unemployed', 'San Francisco', 'CA', 'divorced', 'cooking', 'employment'),
(8, 'Mendoza', 'Angelina', 'angelina@starbuzzcoffee.com', 'F', '1979-08-19', 'UNIX Sysadmin', 'San Francisco', 'CA', 'married', 'new job', 'acting, dancing'),
(9, 'Murphy', 'Donald', 'padraic@tikibeanlounge.com', 'M', '1967-01-23', 'Computer Programmer', 'New York', 'NY', 'committed relationship', 'RPG, anime', 'friends'),
(10, 'Spatner', 'John', 'jpoet@objectville.net', 'M', '1963-04-18', 'Salesman', 'Woodstock', 'NY', 'married', 'poetry, screenwriting', ''),
(11, 'Toth', 'Anne', 'Anne_Toth@leapinlimos.com', 'F', '1969-11-18', 'Artist', 'San Francisco', 'CA', 'taken', 'sql, databases', 'employees'),
(12, 'Manson', 'Anne', 'am86@objectville.net', 'F', '1977-08-09', 'Baker', 'Seattle', 'WA', 'single', 'cooking, dancing', 'a boyfriend'),
(13, 'Hardy', 'Anne', 'anneh@b0tt0msup.com', 'F', '1963-04-18', 'Teacher', 'San Francisco', 'CA', 'taken', 'information technology recruitment', 'coworkers'),
(14, 'Parker', 'Anne', 'annep@starbuzzcoffee.com', 'F', '1983-01-10', 'Student', 'San Francisco', 'CA', 'single', 'horror movies, beatboxing', 'men'),
(15, 'Blunt', 'Anne', 'anneblunt@breakneckpizza.com', 'F', '1959-10-09', 'Web Designer', 'San Francisco', 'CA', 'single', 'smoking, partying, design, patterns', 'a party companion'),
(16, 'Jacobs', 'Anne', 'anne99@objectville.net', 'F', '1973-01-25', 'Computer Programmer', 'San Jose', 'CA', 'in an open relationship', 'women', ''),
(17, 'Reese', 'David', 'dresse@simuduck.com', 'M', '1975-08-19', 'Web Designer', 'Sunnyvale', 'CA', 'single', 'outdoor activities, reading, playing music, travel', 'friends'),
(18, 'Soukup', 'Alan', 'soukup@breakneckpizza.net', 'M', '1974-07-28', 'Aeronautical Engineer', 'San Antonio', 'TX', 'married', 'RPG programming', 'nothing'),
(19, 'Bailey', 'Sarah', 'sarabailey@simuduck.com', 'F', '1968-04-09', 'Advertising Engineer', 'San Antonio', 'TX', 'single', 'movies, exercise, cruises', 'men'),
(20, 'Fiore', 'Carla', 'cfiore@fioreanimalclinic.com', 'F', '1974-01-07', 'Veterinarian', 'Round Rock', 'TX', 'single', 'horseback riding, movies, animals', 'single men'),
(21, 'Prophet', 'Francine', 'prophet@breakneckpizza.net', 'F', '1969-02-06', 'Campaign Manager', 'Cambridge', 'MA', 'single', 'dogs, knitting, embroidery', 'friends'),
(22, 'Ferguson', 'Alexis', 'alexangel@yahoo.com', 'F', '1956-09-19', 'Artist', 'Pflugerville', 'MA', 'single', 'animals, dolls, hunting, taxidermy', 'single men'),
(23, 'Coleman', 'Chris', 'coleman@objectvillediner.com', 'M', '1960-08-13', 'Vintner', 'Napa', 'CA', 'single', 'wine, travel', 'men to date'),
(24, 'Moire', 'Roger', 'roger007@honey-doit.com', 'M', '1971-08-13', 'Snake Trainer', 'San Mateo', 'CA', 'divorced', 'reptiles, camping, kayaking', 'relationship'),
(25, 'McKinnon', 'Gilligan', 'gilligan@boards-r-us.com', 'M', '1980-06-10', 'Accountant', 'Key West', 'FL', 'single', 'pirates, pilates, travel', 'women to date'),
(26, 'Welby', 'Marca', 'doctormarca@yahoo.com', 'F', '1955-10-08', 'Doctor', 'Boston', 'MA', 'single', 'scrubs, house, Greys Anatomy', 'single women'),
(27, 'Chapman', 'Alexandra', 'alex@headfirstlabs.com', 'F', '1980-01-20', 'Technical Writer', 'Princeton', 'NJ', 'committed relationship', 'reading, creative writing, poetry', 'freelance work'),
(28, 'Gardner', 'Shannon', 'sgardner@breakneckpizza.net', 'M', '1974-08-02', 'Poet', 'New London', 'OH', 'single', 'creative writing, poetry, amateur theater', 'men'),
(29, 'Green', 'Robert', 'rob1212@objectville.net', 'M', '1976-08-24', 'Unemployed', 'Corpus Christie', 'TX', 'single', 'swimming', 'women, a job'),
(30, 'Davinci', 'Andrea', 'chef4you@objectville.net', 'F', '1979-10-20', 'Professional Chef', 'Princeton', 'NJ', 'single', 'cooking, art, opera', 'men to date'),
(31, 'Moore', 'Nigel', 'nigelmoore@rachersrule.com', 'M', '1975-08-28', 'Rancher', 'Austin', 'CA', 'single', 'animals, horseback riding, movies', 'single F'),
(32, 'Sullivan', 'Regis', 'me@kathieleeisaflake.com', 'M', '1955-03-20', 'Comedian', 'Cambridge', 'MA', 'single', 'animals, trading cards, geocaching', 'single F');
