-- phpMyAdmin SQL Dump
-- version 3.3.9.2
-- http://www.phpmyadmin.net
--
-- Host: studdb-mysql.fos.auckland.ac.nz
-- Generation Time: Mar 06, 2011 at 05:43 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6-1+lenny9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `stu_spat251_COMPSCI_280_C_S1_2011`
--

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

--
-- Table structure for table `Employee`
--

CREATE TABLE IF NOT EXISTS `Employee` (
  `EmpID` int(11) NOT NULL auto_increment,
  `First Name` varchar(50) NOT NULL,
  `Last Name` varchar(50) default NULL,
  `DOB` varchar(10) default NULL,
  `Salary` float(6,2) NOT NULL,
  `Shift Number` enum('1','2','3','4') NOT NULL default '1',
  PRIMARY KEY  (`EmpID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `Employee`
--

INSERT INTO `Employee` (`EmpID`, `First Name`, `Last Name`, `DOB`, `Salary`, `Shift Number`) VALUES(1, 'Sam', 'Ligget', '1980-02-02', 23.34, '1');
INSERT INTO `Employee` (`EmpID`, `First Name`, `Last Name`, `DOB`, `Salary`, `Shift Number`) VALUES(2, 'John', 'Smith', '1984-09-15', 26.34, '2');
INSERT INTO `Employee` (`EmpID`, `First Name`, `Last Name`, `DOB`, `Salary`, `Shift Number`) VALUES(3, 'Bob', 'Murray', '1983-05-19', 30.00, '3');
INSERT INTO `Employee` (`EmpID`, `First Name`, `Last Name`, `DOB`, `Salary`, `Shift Number`) VALUES(4, 'Bryan', 'Adam', '1985-02-28', 27.59, '4');