-- MySQL dump 9.07
--
-- Host: localhost    Database: BooksSale
---------------------------------------------------------
-- Server version	4.0.11a-gamma

--
-- Current Database: BooksSale
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ BooksSale;

USE BooksSale;

--
-- Table structure for table 'AuthorBooks'
--

CREATE TABLE AuthorBooks (
  BookID INTEGER NOT NULL auto_increment,
  BookName VARCHAR(50) NOT NULL,
  DatePublished DATE DEFAULT '1900-01-01',
  Price DECIMAL(5,2) DEFAULT NULL,
  LastName VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY  (BookID)
) TYPE=MyISAM;

--
-- Dumping data for table 'AuthorBooks'
--

INSERT INTO AuthorBooks VALUES (1,'Year of the Spanish','2003-11-24',25.00,'Myers');
INSERT INTO AuthorBooks VALUES (2,'Stories from yesterday','2003-12-20',34.00,'Piaf');
INSERT INTO AuthorBooks VALUES (3,'Football Stories','2003-09-16',14.00,'Le Bouff');
INSERT INTO AuthorBooks VALUES (4,'Telling the Truth','2003-04-26',13.00,'Green');
INSERT INTO AuthorBooks VALUES (5,'Cooking Receipes','2003-10-10',17.00,'Tardelli');

--
-- Table structure for table 'Customers'
--

CREATE TABLE Customers (
  CustomerID INTEGER NOT NULL auto_increment,
  FirstName varchar(50) DEFAULT NULL,
  LastName varchar(50) DEFAULT NULL,
  BookID INTEGER DEFAULT NULL,
  CustomerBudget DECIMAL(10,2) DEFAULT NULL,
  PRIMARY KEY  (CustomerID)
) TYPE=MyISAM;

--
-- Dumping data for table 'Customers'
--

INSERT INTO Customers VALUES (1,'Frank','Mason',2,43.00);
INSERT INTO Customers VALUES (2,'Julie','Temple',2,21.00);
INSERT INTO Customers VALUES (3,'Freda','Heinz',3,65.00);
INSERT INTO Customers VALUES (4,'Mario','Monti',3,43.00);
INSERT INTO Customers VALUES (5,'Isabel','De Soza',4,76.00);
INSERT INTO Customers VALUES (6,'Leo','Bekenheimer',4,43.00);
INSERT INTO Customers VALUES (7,'Freda','Quirke',5,34.00);
INSERT INTO Customers VALUES (8,'Pedro','Garcia',3,34.00);
INSERT INTO Customers VALUES (9,'Manuel','Fiouri',3,56.00);
INSERT INTO Customers VALUES (10,'Susan','Jones',3,77.00);
INSERT INTO Customers VALUES (11,'Pamela','Montes',2,13.00);
INSERT INTO Customers VALUES (12,'Karl','Bulheim',3,876.00);
INSERT INTO Customers VALUES (13,'Anna','Steinberg',4,23.00);
INSERT INTO Customers VALUES (14,'Bernard','Simpson',3,77.00);
INSERT INTO Customers VALUES (15,'Fabio','Fernadez',4,4.00);
INSERT INTO Customers VALUES (16,'Remi','Gutenberg',4,58.00);
INSERT INTO Customers VALUES (17,'Jane','Francis',5,45.00);
INSERT INTO Customers VALUES (18,'Marina','Lumez',4,64.00);
INSERT INTO Customers VALUES (19,'Ken','Cohen',4,98.00);
INSERT INTO Customers VALUES (20,'Philip','Rose',3,43.00);
INSERT INTO Customers VALUES (21,'Gerry','Fumentes',3,23.00);
INSERT INTO Customers VALUES (22,'Liam','O\'Brien',3,456.00);
INSERT INTO Customers VALUES (23,'Frank','Hennesy',3,54.00);
INSERT INTO Customers VALUES (24,'Nelly','Fulman',4,189.00);
INSERT INTO Customers VALUES (25,'Helmut','Nuthall',4,100.00);
INSERT INTO Customers VALUES (26,'Fernando','Bingham',5,19.00);
INSERT INTO Customers VALUES (27,'Furia','Rodriguez',5,87.00);
INSERT INTO Customers VALUES (28,'Karl','Eduardo',5,76.00);
INSERT INTO Customers VALUES (29,'Godos','Freyre',5,55.00);
INSERT INTO Customers VALUES (30,'André','Fonseca',4,345.00);
INSERT INTO Customers VALUES (31,'Howard','Snyder',2,21.00);
INSERT INTO Customers VALUES (32,'Carlos','Pereira',3,25.00);
INSERT INTO Customers VALUES (33,'Hanari','Pontes',3,56.00);
INSERT INTO Customers VALUES (34,'Ken','Docherty',1,245.00);
INSERT INTO Customers VALUES (35,'Yoshi','Latimer',1,456.00);
INSERT INTO Customers VALUES (36,'Patricia','McKenna',1,24.00);
INSERT INTO Customers VALUES (37,'Philip','Kramer',2,54.00);
INSERT INTO Customers VALUES (38,'Königlich','Essen',2,32.00);
INSERT INTO Customers VALUES (39,'Lilly','Tonini',2,467.00);
INSERT INTO Customers VALUES (40,'Annette','Roulet',2,654.00);
INSERT INTO Customers VALUES (41,'Francis','Detouri',5,34.00);
INSERT INTO Customers VALUES (42,'John','Steel',5,43.00);
INSERT INTO Customers VALUES (43,'Jamie','Messner',5,33.00);
INSERT INTO Customers VALUES (44,'James','Taylor',5,14.00);
INSERT INTO Customers VALUES (45,'Carlos','González',1,567.00);
INSERT INTO Customers VALUES (46,'Fran','Izquierdo',1,75.00);
INSERT INTO Customers VALUES (47,'Frank','O\'Sullivan',1,43.00);
INSERT INTO Customers VALUES (48,'Derek','Tierny',2,28.00);
INSERT INTO Customers VALUES (49,'Catherine','Dewey',2,91.00);
INSERT INTO Customers VALUES (50,'Simon','Crowther',2,23.00);
INSERT INTO Customers VALUES (51,'Morgan','Freeman',1,544.00);
INSERT INTO Customers VALUES (52,'Billy','Hutchinson',1,11.00);
INSERT INTO Customers VALUES (53,'Simon','Glvin',1,23.00);
INSERT INTO Customers VALUES (54,'Garry','Smith',4,21.00);
INSERT INTO Customers VALUES (55,'Michael','Jones',4,35.00);
INSERT INTO Customers VALUES (56,'Mary','Burke',4,78.00);
INSERT INTO Customers VALUES (57,'Darren','Murphy',4,62.00);
INSERT INTO Customers VALUES (58,'Michael','Cooney',4,16.00);
INSERT INTO Customers VALUES (59,'John','McDonald',3,79.00);
INSERT INTO Customers VALUES (60,'Derek','Lally',3,65.00);
INSERT INTO Customers VALUES (61,'Horst','Kloss',3,67.00);
INSERT INTO Customers VALUES (62,'Reggina','Grande',3,7.00);
INSERT INTO Customers VALUES (63,'Sergio','Gutiérrez',3,61.00);
INSERT INTO Customers VALUES (64,'Paula','Wilson',4,63.00);
INSERT INTO Customers VALUES (65,'Janet','Brown',4,33.00);
INSERT INTO Customers VALUES (66,'Liz','Murphy',4,23.00);
INSERT INTO Customers VALUES (67,'Michael','Holz',5,44.00);
INSERT INTO Customers VALUES (68,'Stephen','Nuthall',5,54.00);
INSERT INTO Customers VALUES (69,'Neven','Nagy',5,555.00);
INSERT INTO Customers VALUES (70,'Jose','Pavarotti',5,32.00);
INSERT INTO Customers VALUES (71,'Mary','Jones',2,45.00);
INSERT INTO Customers VALUES (72,'Gerry','O\'Brien',2,42.00);
INSERT INTO Customers VALUES (73,'Paul','Rattigan',1,28.00);
INSERT INTO Customers VALUES (74,'Paul','Herman',2,18.00);
INSERT INTO Customers VALUES (75,'Liu','Wong',2,63.00);
INSERT INTO Customers VALUES (76,'Susan','Byers',2,78.00);
INSERT INTO Customers VALUES (77,'Garry','Jones',2,98.00);
INSERT INTO Customers VALUES (78,'Karla','Wiman',3,2.00);
INSERT INTO Customers VALUES (79,'Sarah','Hughes',3,33.00);
INSERT INTO Customers VALUES (80,'Matti','Kartunen',3,45.00);
INSERT INTO Customers VALUES (81,'Eva','Malstrom',4,19.00);
INSERT INTO Customers VALUES (82,'Harry','Ibsen',4,24.00);
INSERT INTO Customers VALUES (83,'Miles','Tilman',4,55.00);
INSERT INTO Customers VALUES (84,'Kelly','Weston',4,65.00);
INSERT INTO Customers VALUES (85,'Raul','Jackman',3,56.00);
INSERT INTO Customers VALUES (86,'Pirkko','Kostan',4,71.00);
INSERT INTO Customers VALUES (87,'William','Green',5,33.00);
INSERT INTO Customers VALUES (88,'Clover','Jones',5,43.00);
INSERT INTO Customers VALUES (89,'Andy','Nelson',5,44.00);
INSERT INTO Customers VALUES (90,'Burt','Heider',5,12.00);
INSERT INTO Customers VALUES (91,'Freddy','Miles',4,23.00);

--
-- Table structure for table 'Stock'
--

CREATE TABLE Stock (
  StockID INTEGER NOT NULL auto_increment,
  Date DATE DEFAULT NULL,
  Title varchar(50) DEFAULT NULL,
  StockNumber INTEGER DEFAULT NULL,
  Primary KEY (StockID)
) TYPE=MyISAM;

--
-- Dumping data for table 'Stock'
--

INSERT INTO Stock VALUES (1,'2003-11-21','The One Person',4);
INSERT INTO Stock VALUES (2,'2003-10-30','Coming Down',2);