appserver/tests/v2-tests/appserv-tests/devtests/classloader/servlet/sql/create_derby.sql

DROP TABLE books;

CREATE TABLE books (
	ID VARCHAR(8),
	SURNAME VARCHAR(24),
	FIRST_NAME VARCHAR(24),
	TITLE VARCHAR(96),
	PRICE FLOAT,
	YEAR1 		INTEGER		NOT NULL,
        DESCRIPTION VARCHAR(30),
	INVENTORY INTEGER NOT NULL
);