-- phpMyAdmin SQL Dump
-- version 3.4.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 04, 2014 at 10:39 AM
-- Server version: 5.5.13
-- PHP Version: 5.3.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `beatty2`
--

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

--
-- Table structure for table `tbldeps`
--

CREATE TABLE IF NOT EXISTS `tbldeps` (
  `fldDep_id` int(11) NOT NULL AUTO_INCREMENT,
  `fldName` varchar(50) NOT NULL,
  PRIMARY KEY (`fldDep_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbldeps`
--

INSERT INTO `tbldeps` (`fldDep_id`, `fldName`) VALUES
(1, 'Management'),
(2, 'Operations'),
(3, 'External relations'),
(4, 'Finance'),
(5, 'International');

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

--
-- Table structure for table `tblemps`
--

CREATE TABLE IF NOT EXISTS `tblemps` (
  `fldEmp_id` int(11) NOT NULL,
  `fldName` varchar(50) NOT NULL,
  `fldTitle` varchar(50) NOT NULL,
  `fldEmail` varchar(50) NOT NULL,
  `fldWork_phone` varchar(30) NOT NULL,
  `fldCell_phone` varchar(30) NOT NULL,
  `fldDep_id` int(11) NOT NULL,
  `fldPicture` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tblemps`
--

INSERT INTO `tblemps` (`fldEmp_id`, `fldName`, `fldTitle`, `fldEmail`, `fldWork_phone`, `fldCell_phone`, `fldDep_id`, `fldPicture`) VALUES
(1, 'Melissa Kelly', 'Chief of operations', 'melissa@lsu.com', '(364) 123-4567', '(960) 123-4567', 2, 'melissa.gif'),
(2, 'Keneel Augustin', 'Chief executive', 'keneel@lsu.com', '(364) 111-1111', '(215) 123-4567', 1, 'keneel.gif'),
(3, 'Jacob Erdy', 'Chief of finance', 'jacob@lsu.com', '(364) 178-2906', '(215) 444-7777', 4, 'jacob.gif'),
(4, 'Keala Evans', 'General counsel', 'keala@lsu.com', '(364) 568-2351', '(215) 333-7777', 3, 'keala.gif'),
(5, 'Joseph Fischer', 'Community relations', 'joseph@lsu.com', '(364) 444-8765', '(215) 555-8899', 3, 'joseph.gif');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
