-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 21, 2008 at 12:50 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

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

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

--
-- Table structure for table `boats`
--

CREATE TABLE IF NOT EXISTS `boats` (
  `bid` int(4) NOT NULL default '0',
  `bname` varchar(30) default NULL,
  `btype` varchar(30) default NULL,
  `bregno` varchar(10) default NULL,
  `color` enum('red','green','blue') default NULL,
  PRIMARY KEY  (`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `boats`
--

INSERT INTO `boats` (`bid`, `bname`, `btype`, `bregno`, `color`) VALUES
(101, 'Golden Bear', 'Research Vessel', 'CA123456', 'red'),
(103, 'Lollipop', 'Good Ship', 'CA987654', 'green');

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

--
-- Table structure for table `reserves`
--

CREATE TABLE IF NOT EXISTS `reserves` (
  `sid` decimal(9,0) NOT NULL default '0',
  `bid` int(4) NOT NULL default '0',
  `day` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`sid`,`bid`,`day`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reserves`
--

INSERT INTO `reserves` (`sid`, `bid`, `day`) VALUES
(22, 101, '0000-00-00'),
(27, 101, '1996-10-31'),
(27, 103, '2001-09-11'),
(58, 103, '0000-00-00');

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

--
-- Table structure for table `sailors`
--

CREATE TABLE IF NOT EXISTS `sailors` (
  `sid` decimal(9,0) NOT NULL default '0',
  `sname` varchar(30) default NULL,
  `rating` decimal(2,0) default NULL,
  `age` decimal(4,1) default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sailors`
--

INSERT INTO `sailors` (`sid`, `sname`, `rating`, `age`) VALUES
(22, 'dustin', 7, 45.0),
(29, 'brutus', 1, 33.0),
(31, 'lubber', 8, 55.5),
(58, 'rusty', 10, 35.0),
(64, 'horatio', 7, 35.0),
(71, 'zorba', 10, 16.0);