Table Books

isbn varchar 20
title varchar 70
author varchar 50
price float -

DROP TABLE IF EXISTS `test`.`books`;
CREATE TABLE  `test`.`books` (
`isbn` varchar(20) NOT NULL,
`title` varchar(70) NOT NULL,
`author` varchar(50) NOT NULL,
`price` float NOT NULL,
PRIMARY KEY  (`isbn`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;