connect 'jdbc:derby://localhost:1527/DerbyDB;create=true;user=derbypublic;password=derbypublic';
DROP TABLE books;

DROP SCHEMA BOOKSTORE restrict;

CREATE SCHEMA BOOKSTORE;

CREATE TABLE books
(id VARCHAR(8) not null,
CONSTRAINT pk_books PRIMARY KEY(id),
surname VARCHAR(24),
first_name VARCHAR(24),
title VARCHAR(96),
price FLOAT,
yr INT,
description VARCHAR(30),
inventory INT);

INSERT INTO books VALUES('201', 'Duke', '',
 'My Early Years: Growing up on *7',
 10.75, 1995, 'What a cool book.', 20);

INSERT INTO books VALUES('202', 'Jeeves', '',
 'Web Servers for Fun and Profit', 10.75,
 2000, 'What a cool book.', 20);

INSERT INTO books VALUES('203', 'Masterson', 'Webster',
 'Web Components for Web Developers',
 17.75, 2000, 'What a cool book.', 20);

INSERT INTO books VALUES('205', 'Novation', 'Kevin',
 'From Oak to Java: The Revolution of a Language',
 10.75, 1998, 'What a cool book.', 20);

INSERT INTO books VALUES('206', 'Gosling', 'James',
 'Java Intermediate Bytecodes', 10.75,
 2000, 'What a cool book.', 20);

INSERT INTO books VALUES('207', 'Thrilled', 'Ben',
 'The Green Project: Programming for Consumer Devices',
 10.75, 1998, 'What a cool book', 20);

INSERT INTO books VALUES('208', 'Tru', 'Itzal',
 'Duke: A Biography of the Java Evangelist',
 10.75, 2001, 'What a cool book.', 20);