--
-- Host: localhost    Database: du_DUform2
-- ------------------------------------------------------


--
-- Table structure for table `contact_information`
--

CREATE TABLE `contact_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `address` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_information`
--

INSERT INTO `contact_information` VALUES (1,'bookings@jowdy.net','800.349.9002','1945 Lockhill Selma Rd, Suite 202, San Antonio, TX  78213        ');

--
-- Table structure for table `event_planer`
--

CREATE TABLE `event_planer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `title` text,
  `email` text,
  `office` text,
  `mobile` text,
  `company` text,
  `address` text,
  `city` text,
  `state` text,
  `zip` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event_planer`
--

INSERT INTO `event_planer` VALUES (1,'Shane Graef','Support','shane@jowdy.com','(800) 349-9002 106','(972) 273-0437','Jowdy Photography, Inc.','17460 Interstate 35N Ste 430-327','San Antonio','TX','78154'),(4,'Lauren Bridges','Meeting & Event Services (MES)','labridges@deloitte.com','(682) 388-6142','(469) 496-8239','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(11,'Shayna Fears','Meeting & Event Services (MES)','sfears@deloitte.com','(682) 388-6194','(682) 213-1117','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(12,'Brittany Goodwin','Meeting & Event Services (MES)','brgoodwin@deloitte.com','-','(940) 465-3319','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(13,'Rachel Hamende','Meeting & Event Services (MES)','rhamende@deloitte.com','(682) 388-6091','(682) 238-8944','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(14,'Kelsey Hanna','DU Tester','kehanna@deloitte.com','(682) 388-6007','(214) 437-6667','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(16,'Joy Israel','Meeting & Event Services (MES)','jisrael@deloitte.com','(682) 388-6182','(940) 205-8471','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(17,'Tiffany Jones','Meeting & Event Services (MES)','tifjones@deloitte.com','(682) 216-5952','(682) 216-5952','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(20,'Megan Mack','Meeting & Event Services (MES)','memack@deloitte.com','(682) 388-6133','(817) 619-3198','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(21,'Shanna Marko','Meeting & Event Services (MES)','smarko@deloitte.com','(682) 388-6050','(682) 201-6079','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(23,'Hollie Matthews','Meeting & Event Services (MES)','hmatthews@deloitte.com','(682) 388-6130','(512) 468-6497','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(25,'Alea Meintser','Meeting & Event Services (MES)','ameintser@deloitte.com','(682) 388-6069','(817) 374-9716','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(28,'Brannon Smith','Meeting & Event Services (MES)','brannsmith@deloitte.com','-','(214) 998-0547','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(31,'Brooke Dority','Meeting & Event Services (MES)','bdority@deloitte.com','-','(214) 202-2043','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(32,'Christina Kirkbride','Meeting & Event Services (MES)','ckirkbride@deloitte.com','-','(703) 635-6698','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(33,'Maisy Glick','Meeting & Event Services (MES)','mglick@deloitte.com','-','-','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(35,'Sheila Campbell','Meeting & Event Services (MES)','shcampbell@deloitte.com','-','(817) 201-1490','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(36,'Mike Reisinger','Director of Human Resources','mreisinger@deloitte.com','(682) 388-6235','(469) 243-9241','Benchmark Hospitality','One Deloitte Way','Westlake','Texas','76262'),(37,'Lydia Irwin','Event Planner','lyirwin@deloitte.com','-','(214) 394-8738','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(38,'Whitney Oas ','Manager, National Planning','whoas@deloitte.com','0','(214) 897-0803','Deloitte Services LP','1 Deloitte Way','Westlake','Texas','76262'),(39,'Danielle Valudos ','Planner','dvaludos@deloitte.com','-','(469) 390-2902','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(40,'Jacqueline Parkhill ','Planner','jparkhill@deloitte.com','-','(214) 998-9536','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(41,'Kristal Whitaker','Planner','krwhitaker@deloitte.com','-','(214) 840-1480','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(42,'Aaron Daughtrey','Planner','adaughtrey@deloitte.com','-','(929)289-1044','Deloitte Services LP','501 Westlake Pkwy','Westlake','Texas','76262'),(43,'Ashleigh Willis','Planner','ashwillis@deloitte.com','-','-','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(44,'Nikole Rucker','Senior Event Planner - DU Greenhouse','nrucker@deloitte.com','(817) 217-8761','(817) 217-8761','Deloitte','One Deloitte Way','Westlake','TX','76262');

--
-- Table structure for table `photographer`
--

CREATE TABLE `photographer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `email` text,
  `phone` text,
  `location` text,
  `function` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `photographer`
--

INSERT INTO `photographer` VALUES (3,'Shane Graef','shane@jowdy.com','(972) 273-0437','DFW','Technology Support'),(4,'Jeff Jowdy','jeff@jowdy.com','(214) 642-2222','DFW','National Support'),(5,'Tom Abrahamson','tom@jowdy.net','(210) 643-0900','San Antonio','National Support'),(6,'Joe Perrin','joe@jowdy.com','(817) 808-2715','DFW','DFW Support'),(7,'Ryan Littlefield','ryan@jowdy.com','(210) 776-5219','San Antonio','Image Editor'),(8,'Matt Fenstermacher','matt@jowdy.net','(817) 726-4161','DFW','Photographer'),(9,'Amir Jianpanah','amir@jowdy.net','(972) 413-0130','DFW','Photographer'),(10,'Micah Templeton','micah@jowdy.net','(903) 754-2492','DFW','Photographer'),(11,'Don Weaver','don@jowdy.net','(972) 454-0528','DFW','Photographer'),(13,'Alex Chavez','alex@jowdy.net','(469) 773-1135','DFW','Photographer'),(14,'Dakota Sillyman','dakotasillyman@gmail.com','(423) 963-3793','Chicago','Photographer'),(15,'Joe Ubakke','joeuphoto@gmail.com','(312) 625-7005','Chicago','Photographer'),(16,'Jim Vondruska','jimvondruska@gmail.com','(708) 205-8804','Chicago','Photographer'),(18,'Kyle Hopkins','elano2000@hotmail.com','(555) 555-5556','123 Test Address','Webmaster'),(20,'Andre Cooper','andre@jowdy.net','(682) 438-4865','DFW','Photographer'),(21,'Lindsay Vaughn','lindsay@jowdy.net','(470) 577-1611','DFW','Photographer'),(22,'LaDarren Crenshaw','ldcrenshaw@jowdy.net','(903) 650-4363','DFW','Photographer'),(23,'Alyssa Hartley','alyssa@jowdy.net','(325) 261-0469','Abilene','Photographer'),(24,'Shane Graef Gmail','shanegraef@gmail.com','(972) 273-0437','DFW','Support'),(25,'Johnny Bradford (aka - JR)','JR@Jowdy.com','(945) 300-3158','1 ATT Way, Arlington, TX 76011','Photographer'),(26,'Jasper Buitenhuis','j.dbuitenhuis@gmail.com','(214) 680-6325','DFW','Photographer');

--
-- Table structure for table `photographer_attire`
--

CREATE TABLE `photographer_attire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `photographer_attire`
--

INSERT INTO `photographer_attire` VALUES (4,'Business Casual'),(5,'Suit & Tie');


