hsql_sql

data.sql
insert into PURCHASE (CUSTOMERNAME, PRODUCT, PURCHASEDATE)
values('Bruce','Mountain Bike','2010-05-12 00:00:00.0');
insert into PURCHASE (CUSTOMERNAME, PRODUCT, PURCHASEDATE)
values('Paul','Football','2010-04-30 00:00:00.0');
insert into PURCHASE (CUSTOMERNAME, PRODUCT, PURCHASEDATE)
values('Rick','Kayak','2010-06-05 00:00:00.0');


schema.sql
-- ----------------------------------------------
-- DDL Statements for tables
-- ----------------------------------------------

CREATE TABLE "PURCHASE" ("ID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), "CUSTOMERNAME" VARCHAR(255), "PRODUCT" VARCHAR(255), "PURCHASEDATE" TIMESTAMP);

-- ----------------------------------------------
-- DDL Statements for keys
-- ----------------------------------------------

-- primary/unique
ALTER TABLE "PURCHASE" ADD CONSTRAINT "SQL120325130144010" PRIMARY KEY ("ID");