CREATE TABLE `book` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`isbn` varchar(100) NOT NULL default '',
`pictureId` int(11) NOT NULL default '0',
`price` decimal(10,2) NOT NULL default '0.00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# Dumping data for table `book`
#

INSERT INTO `book` VALUES (1, 'Java Examples in a Nutshell', '0596006209', 1, '27.97');
INSERT INTO `book` VALUES (2, 'Macromedia Flash MX 2004 ActionScript', '0321213432', 2, '31.49');
INSERT INTO `book` VALUES (3, 'HTML for the World Wide Web with XHTML and CSS', '0321130073', 3, '15.39');
INSERT INTO `book` VALUES (4, 'Macromedia Dreamweaver MX Hands-On Training', '0321112717', 4, '31.49');
INSERT INTO `book` VALUES (5, 'C# How to Program', '0130622214', 5, '75.93');
INSERT INTO `book` VALUES (6, 'PHP Essentials', '076152729X', 6, '10.55');







CREATE TABLE `author` (
`id` int(11) NOT NULL auto_increment,
`firstName` varchar(100) NOT NULL default '',
`lastName` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

#
# Dumping data for table `author`
#

INSERT INTO `author` VALUES (1, 'David', 'Flanagan');
INSERT INTO `author` VALUES (2, 'Derek', 'Franklin');
INSERT INTO `author` VALUES (3, 'Jobe', 'Makar');
INSERT INTO `author` VALUES (4, 'Elizabeth', 'Castro');
INSERT INTO `author` VALUES (5, 'Garo', 'Green');
INSERT INTO `author` VALUES (6, 'Abigail', 'Rudner');
INSERT INTO `author` VALUES (7, 'Harvey', 'Deitel');
INSERT INTO `author` VALUES (8, 'Paul', 'Deitel');
INSERT INTO `author` VALUES (9, 'Jeffrey', 'Listfield');
INSERT INTO `author` VALUES (10, 'Tem', 'Nieto');
INSERT INTO `author` VALUES (11, 'Cheryl', 'Yaeger');
INSERT INTO `author` VALUES (12, 'Marina', 'Zlatkina');
INSERT INTO `author` VALUES (13, 'Julie', 'Meloni');


CREATE TABLE `book_author` (
`book_id` int(11) NOT NULL default '0',
`author_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table `book_author`
#

INSERT INTO `book_author` VALUES (1, 1);
INSERT INTO `book_author` VALUES (2, 2);
INSERT INTO `book_author` VALUES (2, 3);
INSERT INTO `book_author` VALUES (3, 4);
INSERT INTO `book_author` VALUES (4, 5);
INSERT INTO `book_author` VALUES (4, 6);
INSERT INTO `book_author` VALUES (5, 7);
INSERT INTO `book_author` VALUES (5, 8);
INSERT INTO `book_author` VALUES (5, 9);
INSERT INTO `book_author` VALUES (5, 10);
INSERT INTO `book_author` VALUES (5, 11);
INSERT INTO `book_author` VALUES (5, 12);
INSERT INTO `book_author` VALUES (6, 13);

CREATE TABLE `book_picture` (
`id` int(11) NOT NULL auto_increment,
`picture` blob NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

