CREATE TABLE `contact` (
  `id` int(11) NOT NULL   PRIMARY KEY  AUTO_INCREMENT,
  `firstname` varchar(50) default NULL,
  `lastname` varchar(50) default NULL,
  `address` varchar(50) default NULL,
  `city` varchar(50) default NULL,
  `state` varchar(2) default NULL,
  `country` varchar(50) default NULL,
  `zipcode` varchar(12) default NULL,
  `homephone` varchar(15) default NULL,
  `workphone` varchar(15) default NULL,
  `mobilephone` varchar(15) default NULL,
  `email` varchar(255) NOT NULL,
  `comment` text NULL,
  `add` tinyint NOT NULL default 0,
  `contact` tinyint NOT NULL default 0,
  `send` tinyint NOT NULL default 0,
  `created` timestamp NOT NULL default NOW(),
  `completed` timestamp NULL,
  `notes` text NULL
); 

CREATE INDEX `email` ON `contact`(`email`);

