-- http://www.phpmyadmin.net
--




--
-- Database: `tmiva_subway`
--

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(30) DEFAULT NULL,
  `last_name` varchar(30) DEFAULT NULL,
  `category` enum('SDC Employee','Franchisee','Real Estate','Vendor','Subway','Other') NOT NULL DEFAULT 'Other',
  `email` varchar(40) DEFAULT NULL,
  `phone1` varchar(12) DEFAULT NULL,
  `phone2` varchar(12) DEFAULT NULL,
  `mobile_phone` varchar(12) DEFAULT NULL,
  `fax` varchar(12) DEFAULT NULL,
  `business_address` varchar(100) DEFAULT NULL,
  `business_city` varchar(70) DEFAULT NULL,
  `business_state` char(2) DEFAULT NULL,
  `business_zip` varchar(5) DEFAULT NULL,
  `notes` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `first_name`, `last_name`, `category`, `email`, `phone1`, `phone2`, `mobile_phone`, `fax`, `business_address`, `business_city`, `business_state`, `business_zip`, `notes`) VALUES
(2, 'Josh', 'West', 'Other', 'josh@tmiva.com', '703 567 4864', '', '703 505 4049', '703 567 6871', '4502 7th Street North', 'Arlington', 'VA', '22203', 'TMI Senior Web Developer'),
(3, 'First', 'Last', 'Franchisee', 'Email@email.com', 'Phone One', 'Phone Two', 'Mobile Phone', 'Fax Number', 'Address', 'City', 'VA', 'Zip', 'Notes'),
(4, 'John', 'Smith', 'SDC Employee', 'someone@subway.com', '', '', '', '', '', '', 'VA', '', ''),
(10, 'Charles', 'Woods', 'Other', 'charles@tmiva.com', '703.505.7993', '', '', '', '4502 7th Street North', 'Arlington', 'VA', '', 'TMI Web Guy  //  Design Guru  //  Champion of the Internet  //'),
(12, 'John', 'Doe', 'Franchisee', '123@123.com', '123.456.7890', '', '', '', '', '', 'VA', '', '');

