-- MySQL dump 8.22
--
-- Host: localhost    Database: cdlibrary
---------------------------------------------------------
-- Server version	3.23.52

--
-- Table structure for table 'borrowed_cds'
--

CREATE TABLE borrowed_cds (
  TransactionNo int(5) NOT NULL default '0',
  cdID int(4) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table 'borrowed_cds'
--



--
-- Table structure for table 'borrower'
--

CREATE TABLE borrower (
  BorrowerID int(3) NOT NULL auto_increment,
  Forename varchar(15) NOT NULL default '',
  Surname varchar(15) default NULL,
  AddressOne varchar(35) default NULL,
  AddressTwo varchar(35) default NULL,
  City varchar(20) default NULL,
  Postcode varchar(7) default NULL,
  TeleNo varchar(13) default NULL,
  E-mail varchar(30) default NULL,
  PRIMARY KEY  (BorrowerID)
) TYPE=MyISAM;

--
-- Dumping data for table 'borrower'
--


INSERT INTO borrower VALUES (1,'David','Findlay','Davies Lodge','23 Driven St','Edinburgh','EH5 APE','0131 555 5579','david@keithjbrown.co.uk');
INSERT INTO borrower VALUES (2,'Iain','Brown','54 Home St','Edinburgh',NULL,' EH23 8','0131 555 5580','iain@keithjbrown.co.uk');
INSERT INTO borrower VALUES (3,'James','Christie','13 Lucky St','New Mains','Edinburgh','EH6 PAD','0131 555 5562','james@newmains.co.uk');

--
-- Table structure for table 'cd_releases'
--

CREATE TABLE cd_releases (
  releaseID int(4) NOT NULL auto_increment,
  Artist varchar(30) NOT NULL default '',
  Title varchar(50) NOT NULL default '',
  Year varchar(4) NOT NULL default '',
  Label varchar(30) NOT NULL default '',
  No_of_tracks int(2) NOT NULL default '0',
  PRIMARY KEY  (releaseID)
) TYPE=MyISAM;

--
-- Dumping data for table 'cd_releases'
--


INSERT INTO cd_releases VALUES (1,'Britney Spears','Britney','2001','Jive',14);
INSERT INTO cd_releases VALUES (2,'Pink','Cant Take Me Home','2002','LaFace',15);
INSERT INTO cd_releases VALUES (3,'Christina Aguilera','Stripped','2002','RCA',20);
INSERT INTO cd_releases VALUES (4,'Darius','Dive In','2002','Mercury',14);
INSERT INTO cd_releases VALUES (5,'Will Young','From Now On','2002','RCA',13);
INSERT INTO cd_releases VALUES (6,'Robbie Williams','Escapology','2002','Chrysalis',14);


--
-- Table structure for table 'cds_bought'
--

CREATE TABLE cds_bought (
  cdID int(4) NOT NULL auto_increment,
  releaseID int(4) NOT NULL default '0',
  copy int(2) NOT NULL default '0',
  PRIMARY KEY  (cdID)
) TYPE=MyISAM;

--
-- Dumping data for table 'cds_bought'
--


INSERT INTO cds_bought VALUES (1,1,1);
INSERT INTO cds_bought VALUES (2,2,1);
INSERT INTO cds_bought VALUES (3,3,1);
INSERT INTO cds_bought VALUES (4,4,1);
INSERT INTO cds_bought VALUES (5,5,1);
INSERT INTO cds_bought VALUES (6,6,1);
INSERT INTO cds_bought VALUES (7,3,2);

--
-- Table structure for table 'loans'
--

CREATE TABLE loans (
  TransactionNo int(5) NOT NULL auto_increment,
  BorrowerID int(3) NOT NULL default '0',
  Date_Borrowed date NOT NULL default '0000-00-00',
  Due_Back date NOT NULL default '0000-00-00',
  PRIMARY KEY  (TransactionNo)
) TYPE=MyISAM;

--
-- Dumping data for table 'loans'
--


INSERT INTO loans VALUES (1,1,'2002-12-01','2002-12-08');
INSERT INTO loans VALUES (2,2,'2002-12-08','2002-12-15');