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
);