-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 24, 2012 at 03:42 AM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

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: `oceanai3_oim`
--

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

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
  `CustID` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Customer Identification Number',
  `First` VARCHAR(20) NOT NULL COMMENT 'First Name',
  `Last` VARCHAR(20) NOT NULL COMMENT 'Last Name',
  `Addrln1` VARCHAR(50) NOT NULL COMMENT 'Address Line 1',
  `Addrln2` VARCHAR(20) DEFAULT NULL COMMENT 'Address Line 2',
  `Postcode` VARCHAR(15) NOT NULL COMMENT 'Postcode',
  `County` VARCHAR(20) NOT NULL COMMENT 'County',
  `Country` VARCHAR(20) NOT NULL COMMENT 'Country',
  `Phone` VARCHAR(20) NOT NULL COMMENT 'Telephone',
  `Email` VARCHAR(50) NOT NULL COMMENT 'E-Mail',
  PRIMARY KEY (`CustID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`CustID`, `First`, `Last`, `Addrln1`, `Addrln2`, `Postcode`, `County`, `Country`, `Phone`, `Email`) VALUES
(1, 'oliver', 'marriott', '71 trent blvd', '', 'ng2 5be', 'notts', 'uk', '07595756181', '[email protected]'),
(2, 'keith', 'marriott', '11 Galton Road', '', 'SS0 8LE', 'Essex', 'UK', '07595756181', '[email protected]');

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

--
-- Table structure for table `employee`
--

CREATE TABLE IF NOT EXISTS `employee` (
  `EmpID` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Employee ID',
  `EmpFirst` VARCHAR(20) NOT NULL COMMENT 'Co-ordinator',
  `EmpLast` VARCHAR(20) NOT NULL COMMENT 'Employee Last',
  `EmpEmail` VARCHAR(50) NOT NULL COMMENT 'Co-ordinator E-mail',
  `Username` VARCHAR(20) DEFAULT NULL,
  `Password` VARCHAR(20) DEFAULT NULL,
  PRIMARY KEY (`EmpID`),
  UNIQUE KEY `Ck_Un` (`Username`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`EmpID`, `EmpFirst`, `EmpLast`, `EmpEmail`, `Username`, `Password`) VALUES
(1, 'Keith', 'marriott', '[email protected]', 'ollie', 'baxter12'),
(2, 'test', 'test', 'tes', 'test', 'test'),
(3, 'Ollie', 'Marriott', 'ollie', 'oliver', 'baxter12');

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

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `CustID` INT(11) NOT NULL AUTO_INCREMENT,
  `Username` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'Username',
  `Password` VARCHAR(20) DEFAULT NULL COMMENT 'Password',
  PRIMARY KEY (`Username`),
  KEY `login_ibfk_2` (`CustID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`CustID`, `Username`, `Password`) VALUES
(2, 'keithmarriott', 'baxter12'),
(1, 'olliemarriott', 'baxter12');

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

--
-- Table structure for table `move`
--

CREATE TABLE IF NOT EXISTS `move` (
  `CustID` INT(11) NOT NULL AUTO_INCREMENT,
  `MoveID` INT(11) NOT NULL DEFAULT '0' COMMENT 'Reference',
  `CityOrig` VARCHAR(20) NOT NULL COMMENT 'Origin City',
  `CityDest` VARCHAR(20) NOT NULL COMMENT 'Destination City',
  `CountryOrig` VARCHAR(20) NOT NULL COMMENT 'Origin Country',
  `CountryDest` VARCHAR(20) NOT NULL COMMENT 'Destination Country',
  `EnquiryDate` DATE NOT NULL COMMENT 'Enquiry Date',
  `Surveydate` DATE DEFAULT NULL COMMENT 'Survey Date',
  `QuoteDate` DATE NOT NULL COMMENT 'Quote Date',
  `DepEst` DATE NOT NULL COMMENT 'Estimated Departure',
  `DepAct` DATE DEFAULT NULL COMMENT 'Actual Departure',
  `ArrEst` DATE NOT NULL COMMENT 'Estimated Arrival',
  `ArrAct` DATE DEFAULT NULL COMMENT 'Actual Arrival',
  `ClearEst` DATE NOT NULL COMMENT 'Estimated Clearance',
  `ClearAct` DATE DEFAULT NULL COMMENT 'Actual Clearance',
  `DelEst` DATE NOT NULL COMMENT 'Estimated Delivery',
  `DelAct` DATE DEFAULT NULL COMMENT 'Actual Delivery',
  `Port` VARCHAR(20) NOT NULL COMMENT 'Port of Exit',
  `Status` VARCHAR(1000) DEFAULT NULL COMMENT 'Notes',
  `Method` VARCHAR(50) NOT NULL COMMENT 'Method of Transport',
  `EmpID` INT(11) DEFAULT NULL,
  PRIMARY KEY (`MoveID`),
  KEY `FK_emp` (`EmpID`),
  KEY `move_ibfk_1` (`CustID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `move`
--

INSERT INTO `move` (`CustID`, `MoveID`, `CityOrig`, `CityDest`, `CountryOrig`, `CountryDest`, `EnquiryDate`, `Surveydate`, `QuoteDate`, `DepEst`, `DepAct`, `ArrEst`, `ArrAct`, `ClearEst`, `ClearAct`, `DelEst`, `DelAct`, `Port`, `Status`, `Method`, `EmpID`) VALUES
(1, 123123, 'nottingham', 'southend', 'uk', 'uk', '2012-05-01', '2012-05-01', '2012-05-01', '2012-05-01', NULL, '2012-05-01', NULL, '2012-05-01', NULL, '2012-05-01', NULL, 'N/A', 'this->no', 'Road', 1),
(2, 1231232, 'Southend', 'Orlando', 'United Kingdom', 'united states', '2012-04-12', '2012-04-12', '2012-04-12', '2012-04-12', NULL, '2012-04-12', NULL, '2012-04-12', NULL, '2012-04-12', NULL, 'N/A', 'Something happening soon!', 'Road', 1);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `login`
--
ALTER TABLE `login`
  ADD CONSTRAINT `login_ibfk_1` FOREIGN KEY (`CustID`) REFERENCES `customer` (`CustID`),
  ADD CONSTRAINT `login_ibfk_2` FOREIGN KEY (`CustID`) REFERENCES `customer` (`CustID`);

--
-- Constraints for table `move`
--
ALTER TABLE `move`
  ADD CONSTRAINT `FK_emp` FOREIGN KEY (`EmpID`) REFERENCES `employee` (`EmpID`),
  ADD CONSTRAINT `move_ibfk_1` FOREIGN KEY (`CustID`) REFERENCES `customer` (`CustID`),
  ADD CONSTRAINT `move_ibfk_2` FOREIGN KEY (`CustID`) REFERENCES `customer` (`CustID`);

/*!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 */;