-- MySQL dump 9.11
--
-- Host: richese    Database: brazile
-- ------------------------------------------------------
-- Server version	5.0.51a-24+lenny1-log

--
-- Table structure for table `Customer`
--

DROP TABLE IF EXISTS `Customer`;
CREATE TABLE `Customer` (
  `custID` int(11) NOT NULL auto_increment,
  `custName` varchar(30) default NULL,
  `custDOB` date default NULL,
  `custDL` varchar(15) default NULL,
  `custDLST` char(2) default NULL,
  `custCC` varchar(16) default NULL,
  PRIMARY KEY  (`custID`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Customer`
--

INSERT INTO `Customer` VALUES (1,'john smith','1984-10-03','123456','TX','2020938983');
INSERT INTO `Customer` VALUES (2,'joe smith','1984-10-03','123456','TX','3020938983');
INSERT INTO `Customer` VALUES (3,'sam smith','1985-10-03','113456','TX','4020938983');
INSERT INTO `Customer` VALUES (4,'joe jones','1986-10-03','133456','TX','3320938983');
INSERT INTO `Customer` VALUES (5,'mary smith','1987-10-03','423456','TX','2020938983');
INSERT INTO `Customer` VALUES (6,'joe brown','1989-10-03','153456','TX','2330938983');
INSERT INTO `Customer` VALUES (7,'tom green','1974-10-03','163456','TX','2550938983');
INSERT INTO `Customer` VALUES (8,'joe johnson','1975-10-03','623456','TX','20200998983');
INSERT INTO `Customer` VALUES (9,'betty smith','1964-10-03','223456','TX','2020222983');
INSERT INTO `Customer` VALUES (10,'clint eastwood','1984-12-03','125456','TX','2090938983');
INSERT INTO `Customer` VALUES (11,'john wayne','1984-10-22','123436','TX','2020977783');
INSERT INTO `Customer` VALUES (12,'jane fonda','1984-10-19','123496','TX','2020931283');
INSERT INTO `Customer` VALUES (13,'bill clinton','1984-04-03','129456','TX','2023458983');
INSERT INTO `Customer` VALUES (14,'george bush','1984-09-03','123956','TX','2024444983');
INSERT INTO `Customer` VALUES (15,'bruce willis','1974-03-03','122456','TX','2055558983');
INSERT INTO `Customer` VALUES (16,'rachel weiss','1984-05-03','125456','TX','2066668983');
INSERT INTO `Customer` VALUES (17,'james bond','1984-06-03','123406','TX','2020890783');

--
-- Table structure for table `Vehicle`
--

DROP TABLE IF EXISTS `Vehicle`;
CREATE TABLE `Vehicle` (
  `vehID` int(11) NOT NULL default '0',
  `vehType` char(8) default NULL,
  `vehYR` date default NULL,
  `vehMilage` int(11) default NULL,
  `vehInsurance` int(11) default NULL,
  `vehEqpt` int(11) default NULL,
  `vehRepair` int(11) default NULL,
  `vehFuel` int(11) default NULL,
  `vehClean` int(11) default NULL,
  `vehEngine` float default NULL,
  `vehCost` decimal(5,2) default NULL,
  `vehTrans` int(11) default NULL,
  PRIMARY KEY  (`vehID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Vehicle`
--

INSERT INTO `Vehicle` VALUES (12345,'estate','2007-01-01',23001,1,1,1,1,1,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (123465,'estate','2005-08-10',53001,1,1,1,1,1,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12347,'estate','2005-08-10',53001,0,1,1,1,1,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12348,'estate','2005-08-10',53001,1,0,1,1,1,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12349,'estate','2005-08-10',53001,1,1,0,1,1,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12340,'estate','2005-08-10',53001,1,1,1,0,1,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12350,'estate','2005-08-10',53001,1,1,1,1,0,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12351,'estate','2006-08-10',3001,1,1,1,1,0,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12352,'estate','2007-08-10',3001,1,1,1,1,0,2,'25.50',1);
INSERT INTO `Vehicle` VALUES (12353,'estate','2008-08-10',3001,1,1,1,1,0,2,'25.50',1);

--
-- Table structure for table `Rental`
--

DROP TABLE IF EXISTS `Rental`;
CREATE TABLE `Rental` (
  `rentID` int(11) NOT NULL auto_increment,
  `cust` int(11) default NULL,
  `veh` int(11) default NULL,
  `rentStartDate` date default NULL,
  `rentEndDate` date default NULL,
  `rentPayment` decimal(7,2) default NULL,
  `rentFuel` decimal(3,2) default NULL,
  `rentStartMilage` int(11) default NULL,
  `rentEndMilage` int(11) default NULL,
  PRIMARY KEY  (`rentID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Rental`
--

INSERT INTO `Rental` VALUES (1,1,12345,'2009-10-10','2009-10-12','0.00','0.00',23001,23099);
INSERT INTO `Rental` VALUES (default,2,12346,'2009-10-10','2009-10-12','0.00','0.00',23001,23099);
INSERT INTO `Rental` VALUES (default,3,12347,'2009-10-10','2009-10-12','0.00','0.00',23001,23099);
INSERT INTO `Rental` VALUES (default,4,12348,'2009-10-10','2009-10-12','0.00','0.00',23001,23099);
INSERT INTO `Rental` VALUES (default,5,12349,'2009-10-10','2009-10-12','0.00','0.00',23001,23099);