sampledata.sql

hsqldb是100％java实现的数据库,是一个开放源代码的JAVA数据库 l 具有标准的SQL语法和JAVA接口 l HSQLDB可以自由使用和分发 l 非常简洁和快速的

/*
 *  $Id
 *
 *  Creates and populates database objects with sample data.
 *  This file was created by grabbing the commands made by creating
 *  sample data with the DatabaseManager utility.
 */


DROP TABLE Item IF EXISTS;
DROP TABLE Invoice IF EXISTS;
DROP TABLE Product IF EXISTS;
DROP TABLE Customer IF EXISTS;
CREATE TABLE Customer(ID INTEGER PRIMARY KEY,FirstName VARCHAR,LastName VARCHAR,Street VARCHAR,City VARCHAR);
CREATE TABLE Product(ID INTEGER PRIMARY KEY,Name VARCHAR,Price DECIMAL);
CREATE TABLE Invoice(ID INTEGER PRIMARY KEY,CustomerID INTEGER,Total DECIMAL, FOREIGN KEY (CustomerId) REFERENCES Customer(ID) ON DELETE CASCADE);
CREATE TABLE Item(InvoiceID INTEGER,Item INTEGER,ProductID INTEGER,Quantity INTEGER,Cost DECIMAL,PRIMARY KEY(InvoiceID,Item), FOREIGN KEY (InvoiceId) REFERENCES Invoice (ID) ON DELETE CASCADE, FOREIGN KEY (ProductId) REFERENCES Product(ID) ON DELETE CASCADE);
SET REFERENTIAL_INTEGRITY FALSE;
INSERT INTO Customer VALUES(0,'Laura','Steel','429 Seventh Av.','Dallas');
INSERT INTO Product VALUES(0,'Iron Iron',54);
INSERT INTO Invoice VALUES(0,0,0.0);
INSERT INTO Item VALUES(0,12,1,11,1.5);
INSERT INTO Item VALUES(0,11,12,4,1.5);
INSERT INTO Item VALUES(0,10,4,8,1.5);
INSERT INTO Item VALUES(0,9,35,4,1.5);
INSERT INTO Item VALUES(0,8,0,23,1.5);
INSERT INTO Item VALUES(0,7,7,10,1.5);
INSERT INTO Item VALUES(0,6,16,9,1.5);
INSERT INTO Item VALUES(0,5,12,15,1.5);
INSERT INTO Item VALUES(0,4,47,1,1.5);
INSERT INTO Item VALUES(0,3,1,9,1.5);
INSERT INTO Item VALUES(0,2,47,3,1.5);
INSERT INTO Item VALUES(0,1,14,19,1.5);
INSERT INTO Item VALUES(0,0,7,12,1.5);
INSERT INTO Customer VALUES(1,'Susanne','King','366 - 20th Ave.','Olten');
INSERT INTO Product VALUES(1,'Chair Shoe',248);
INSERT INTO Invoice VALUES(1,33,0.0);
INSERT INTO Item VALUES(1,6,25,19,1.5);
INSERT INTO Item VALUES(1,5,25,9,1.5);
INSERT INTO Item VALUES(1,4,16,16,1.5);
INSERT INTO Item VALUES(1,3,38,8,1.5);
INSERT INTO Item VALUES(1,2,19,6,1.5);
INSERT INTO Item VALUES(1,1,0,9,1.5);
INSERT INTO Item VALUES(1,0,40,8,1.5);
INSERT INTO Customer VALUES(2,'Anne','Miller','20 Upland Pl.','Lyon');
INSERT INTO Product VALUES(2,'Telephone Clock',248);
INSERT INTO Invoice VALUES(2,23,0.0);
INSERT INTO Item VALUES(2,16,36,24,1.5);
INSERT INTO Item VALUES(2,15,0,18,1.5);
INSERT INTO Item VALUES(2,14,48,19,1.5);
INSERT INTO Item VALUES(2,13,12,1,1.5);
INSERT INTO Item VALUES(2,12,21,15,1.5);
INSERT INTO Item VALUES(2,11,42,21,1.5);
INSERT INTO Item VALUES(2,10,49,11,1.5);
INSERT INTO Item VALUES(2,9,18,7,1.5);
INSERT INTO Item VALUES(2,8,39,2,1.5);
INSERT INTO Item VALUES(2,7,30,5,1.5);
INSERT INTO Item VALUES(2,6,43,8,1.5);
INSERT INTO Item VALUES(2,5,30,4,1.5);
INSERT INTO Item VALUES(2,4,38,18,1.5);
INSERT INTO Item VALUES(2,3,19,13,1.5);
INSERT INTO Item VALUES(2,2,11,9,1.5);
INSERT INTO Item VALUES(2,1,25,3,1.5);
INSERT INTO Item VALUES(2,0,4,18,1.5);
INSERT INTO Customer VALUES(3,'Michael','Clancy','542 Upland Pl.','San Francisco');
INSERT INTO Product VALUES(3,'Chair Chair',254);
INSERT INTO Invoice VALUES(3,21,0.0);
INSERT INTO Item VALUES(3,17,30,17,1.5);
INSERT INTO Item VALUES(3,16,19,11,1.5);
INSERT INTO Item VALUES(3,15,23,18,1.5);
INSERT INTO Item VALUES(3,14,17,22,1.5);
INSERT INTO Item VALUES(3,13,41,2,1.5);
INSERT INTO Item VALUES(3,12,41,22,1.5);
INSERT INTO Item VALUES(3,11,7,11,1.5);
INSERT INTO Item VALUES(3,10,10,17,1.5);
INSERT INTO Item VALUES(3,9,29,17,1.5);
INSERT INTO Item VALUES(3,8,49,9,1.5);
INSERT INTO Item VALUES(3,7,26,4,1.5);
INSERT INTO Item VALUES(3,6,13,18,1.5);
INSERT INTO Item VALUES(3,5,30,10,1.5);
INSERT INTO Item VALUES(3,4,20,12,1.5);
INSERT INTO Item VALUES(3,3,0,22,1.5);
INSERT INTO Item VALUES(3,2,49,3,1.5);
INSERT INTO Item VALUES(3,1,1,20,1.5);
INSERT INTO Item VALUES(3,0,11,21,1.5);
INSERT INTO Customer VALUES(4,'Sylvia','Ringer','365 College Av.','Dallas');
INSERT INTO Product VALUES(4,'Ice Tea Shoe',128);
INSERT INTO Invoice VALUES(4,30,0.0);
INSERT INTO Item VALUES(4,5,37,24,1.5);
INSERT INTO Item VALUES(4,4,9,18,1.5);
INSERT INTO Item VALUES(4,3,23,20,1.5);
INSERT INTO Item VALUES(4,2,41,23,1.5);
INSERT INTO Item VALUES(4,1,35,15,1.5);
INSERT INTO Item VALUES(4,0,28,9,1.5);
INSERT INTO Customer VALUES(5,'Laura','Miller','294 Seventh Av.','Paris');
INSERT INTO Product VALUES(5,'Clock Clock',236);
INSERT INTO Invoice VALUES(5,34,0.0);
INSERT INTO Item VALUES(5,13,18,17,1.5);
INSERT INTO Item VALUES(5,12,8,15,1.5);
INSERT INTO Item VALUES(5,11,38,23,1.5);
INSERT INTO Item VALUES(5,10,28,18,1.5);
INSERT INTO Item VALUES(5,9,37,9,1.5);
INSERT INTO Item VALUES(5,8,20,3,1.5);
INSERT INTO Item VALUES(5,7,2,4,1.5);
INSERT INTO Item VALUES(5,6,7,9,1.5);
INSERT INTO Item VALUES(5,5,46,15,1.5);
INSERT INTO Item VALUES(5,4,32,14,1.5);
INSERT INTO Item VALUES(5,3,24,12,1.5);
INSERT INTO Item VALUES(5,2,20,18,1.5);
INSERT INTO Item VALUES(5,1,9,23,1.5);
INSERT INTO Item VALUES(5,0,9,5,1.5);
INSERT INTO Customer VALUES(6,'Laura','White','506 Upland Pl.','Palo Alto');
INSERT INTO Product VALUES(6,'Ice Tea Chair',98);
INSERT INTO Invoice VALUES(6,19,0.0);
INSERT INTO Item VALUES(6,11,44,1,1.5);
INSERT INTO Item VALUES(6,10,16,13,1.5);
INSERT INTO Item VALUES(6,9,19,2,1.5);
INSERT INTO Item VALUES(6,8,41,19,1.5);
INSERT INTO Item VALUES(6,7,26,10,1.5);
INSERT INTO Item VALUES(6,6,37,22,1.5);
INSERT INTO Item VALUES(6,5,14,20,1.5);
INSERT INTO Item VALUES(6,4,31,20,1.5);
INSERT INTO Item VALUES(6,3,30,2,1.5);
INSERT INTO Item VALUES(6,2,23,8,1.5);
INSERT INTO Item VALUES(6,1,38,21,1.5);
INSERT INTO Item VALUES(6,0,15,20,1.5);
INSERT INTO Customer VALUES(7,'James','Peterson','231 Upland Pl.','San Francisco');
INSERT INTO Product VALUES(7,'Telephone Shoe',84);
INSERT INTO Invoice VALUES(7,26,0.0);
INSERT INTO Item VALUES(7,18,23,5,1.5);
INSERT INTO Item VALUES(7,17,40,1,1.5);
INSERT INTO Item VALUES(7,16,7,12,1.5);
INSERT INTO Item VALUES(7,15,24,17,1.5);
INSERT INTO Item VALUES(7,14,47,14,1.5);
INSERT INTO Item VALUES(7,13,32,23,1.5);
INSERT INTO Item VALUES(7,12,40,16,1.5);
INSERT INTO Item VALUES(7,11,19,13,1.5);
INSERT INTO Item VALUES(7,10,7,1,1.5);
INSERT INTO Item VALUES(7,9,9,21,1.5);
INSERT INTO Item VALUES(7,8,42,19,1.5);
INSERT INTO Item VALUES(7,7,2,22,1.5);
INSERT INTO Item VALUES(7,6,14,4,1.5);
INSERT INTO Item VALUES(7,5,24,10,1.5);
INSERT INTO Item VALUES(7,4,2,13,1.5);
INSERT INTO Item VALUES(7,3,30,2,1.5);
INSERT INTO Item VALUES(7,2,27,17,1.5);
INSERT INTO Item VALUES(7,1,23,12,1.5);
INSERT INTO Item VALUES(7,0,43,16,1.5);
INSERT INTO Customer VALUES(8,'Andrew','Miller','288 - 20th Ave.','Seattle');
INSERT INTO Product VALUES(8,'Ice Tea Clock',226);
INSERT INTO Invoice VALUES(8,29,0.0);
INSERT INTO Item VALUES(8,9,21,23,1.5);
INSERT INTO Item VALUES(8,8,38,7,1.5);
INSERT INTO Item VALUES(8,7,6,5,1.5);
INSERT INTO Item VALUES(8,6,15,19,1.5);
INSERT INTO Item VALUES(8,5,24,18,1.5);
INSERT INTO Item VALUES(8,4,15,8,1.5);
INSERT INTO Item VALUES(8,3,41,16,1.5);
INSERT INTO Item VALUES(8,2,11,8,1.5);
INSERT INTO Item VALUES(8,1,44,16,1.5);
INSERT INTO Item VALUES(8,0,34,15,1.5);
INSERT INTO Customer VALUES(9,'James','Schneider','277 Seventh Av.','Berne');
INSERT INTO Product VALUES(9,'Clock Telephone',172);
INSERT INTO Invoice VALUES(9,38,0.0);
INSERT INTO Item VALUES(9,19,48,23,1.5);
INSERT INTO Item VALUES(9,18,3,12,1.5);
INSERT INTO Item VALUES(9,17,13,17,1.5);
INSERT INTO Item VALUES(9,16,24,10,1.5);
INSERT INTO Item VALUES(9,15,48,23,1.5);
INSERT INTO Item VALUES(9,14,15,8,1.5);
INSERT INTO Item VALUES(9,13,42,13,1.5);
INSERT INTO Item VALUES(9,12,25,23,1.5);
INSERT INTO Item VALUES(9,11,12,16,1.5);
INSERT INTO Item VALUES(9,10,38,11,1.5);
INSERT INTO Item VALUES(9,9,13,6,1.5);
INSERT INTO Item VALUES(9,8,24,11,1.5);
INSERT INTO Item VALUES(9,7,2,22,1.5);
INSERT INTO Item VALUES(9,6,18,10,1.5);
INSERT INTO Item VALUES(9,5,6,2,1.5);
INSERT INTO Item VALUES(9,4,36,16,1.5);
INSERT INTO Item VALUES(9,3,4,14,1.5);
INSERT INTO Item VALUES(9,2,29,12,1.5);
INSERT INTO Item VALUES(9,1,18,21,1.5);
INSERT INTO Item VALUES(9,0,45,8,1.5);
INSERT INTO Customer VALUES(10,'Anne','Fuller','135 Upland Pl.','Dallas');
INSERT INTO Product VALUES(10,'Telephone Ice Tea',204);
INSERT INTO Invoice VALUES(10,24,0.0);
INSERT INTO Item VALUES(10,9,5,10,1.5);
INSERT INTO Item VALUES(10,8,22,11,1.5);
INSERT INTO Item VALUES(10,7,4,13,1.5);
INSERT INTO Item VALUES(10,6,18,14,1.5);
INSERT INTO Item VALUES(10,5,5,24,1.5);
INSERT INTO Item VALUES(10,4,10,24,1.5);
INSERT INTO Item VALUES(10,3,46,1,1.5);
INSERT INTO Item VALUES(10,2,7,9,1.5);
INSERT INTO Item VALUES(10,1,33,17,1.5);
INSERT INTO Item VALUES(10,0,20,1,1.5);
INSERT INTO Customer VALUES(11,'Julia','White','412 Upland Pl.','Chicago');
INSERT INTO Product VALUES(11,'Telephone Iron',88);
INSERT INTO Invoice VALUES(11,24,0.0);
INSERT INTO Item VALUES(11,8,20,1,1.5);
INSERT INTO Item VALUES(11,7,48,22,1.5);
INSERT INTO Item VALUES(11,6,0,12,1.5);
INSERT INTO Item VALUES(11,5,19,2,1.5);
INSERT INTO Item VALUES(11,4,47,16,1.5);
INSERT INTO Item VALUES(11,3,32,21,1.5);
INSERT INTO Item VALUES(11,2,0,3,1.5);
INSERT INTO Item VALUES(11,1,21,21,1.5);
INSERT INTO Item VALUES(11,0,45,10,1.5);
INSERT INTO Customer VALUES(12,'George','Ott','381 Upland Pl.','Palo Alto');
INSERT INTO Product VALUES(12,'Clock Ice Tea',168);
INSERT INTO Invoice VALUES(12,23,0.0);
INSERT INTO Item VALUES(12,18,9,4,1.5);
INSERT INTO Item VALUES(12,17,31,15,1.5);
INSERT INTO Item VALUES(12,16,0,9,1.5);
INSERT INTO Item VALUES(12,15,22,16,1.5);
INSERT INTO Item VALUES(12,14,25,11,1.5);
INSERT INTO Item VALUES(12,13,36,21,1.5);
INSERT INTO Item VALUES(12,12,13,12,1.5);
INSERT INTO Item VALUES(12,11,28,16,1.5);
INSERT INTO Item VALUES(12,10,46,19,1.5);
INSERT INTO Item VALUES(12,9,25,22,1.5);
INSERT INTO Item VALUES(12,8,48,2,1.5);
INSERT INTO Item VALUES(12,7,48,7,1.5);
INSERT INTO Item VALUES(12,6,31,15,1.5);
INSERT INTO Item VALUES(12,5,37,17,1.5);
INSERT INTO Item VALUES(12,4,20,11,1.5);
INSERT INTO Item VALUES(12,3,0,18,1.5);
INSERT INTO Item VALUES(12,2,6,5,1.5);
INSERT INTO Item VALUES(12,1,41,19,1.5);
INSERT INTO Item VALUES(12,0,1,24,1.5);
INSERT INTO Customer VALUES(13,'Laura','Ringer','38 College Av.','New York');
INSERT INTO Product VALUES(13,'Telephone Clock',180);
INSERT INTO Invoice VALUES(13,39,0.0);
INSERT INTO Item VALUES(13,21,40,1,1.5);
INSERT INTO Item VALUES(13,20,5,19,1.5);
INSERT INTO Item VALUES(13,19,42,18,1.5);
INSERT INTO Item VALUES(13,18,0,16,1.5);
INSERT INTO Item VALUES(13,17,32,18,1.5);
INSERT INTO Item VALUES(13,16,22,23,1.5);
INSERT INTO Item VALUES(13,15,0,20,1.5);
INSERT INTO Item VALUES(13,14,1,12,1.5);
INSERT INTO Item VALUES(13,13,10,20,1.5);
INSERT INTO Item VALUES(13,12,17,3,1.5);
INSERT INTO Item VALUES(13,11,14,3,1.5);
INSERT INTO Item VALUES(13,10,45,24,1.5);
INSERT INTO Item VALUES(13,9,24,10,1.5);
INSERT INTO Item VALUES(13,8,48,11,1.5);
INSERT INTO Item VALUES(13,7,29,24,1.5);
INSERT INTO Item VALUES(13,6,19,8,1.5);
INSERT INTO Item VALUES(13,5,22,19,1.5);
INSERT INTO Item VALUES(13,4,26,21,1.5);
INSERT INTO Item VALUES(13,3,32,2,1.5);
INSERT INTO Item VALUES(13,2,13,20,1.5);
INSERT INTO Item VALUES(13,1,1,1,1.5);
INSERT INTO Item VALUES(13,0,16,10,1.5);
INSERT INTO Customer VALUES(14,'Bill','Karsen','53 College Av.','Oslo');
INSERT INTO Product VALUES(14,'Telephone Iron',124);
INSERT INTO Invoice VALUES(14,35,0.0);
INSERT INTO Item VALUES(14,13,11,23,1.5);
INSERT INTO Item VALUES(14,12,4,20,1.5);
INSERT INTO Item VALUES(14,11,25,15,1.5);
INSERT INTO Item VALUES(14,10,44,16,1.5);
INSERT INTO Item VALUES(14,9,13,16,1.5);
INSERT INTO Item VALUES(14,8,23,7,1.5);
INSERT INTO Item VALUES(14,7,43,4,1.5);
INSERT INTO Item VALUES(14,6,26,18,1.5);
INSERT INTO Item VALUES(14,5,11,8,1.5);
INSERT INTO Item VALUES(14,4,41,17,1.5);
INSERT INTO Item VALUES(14,3,34,11,1.5);
INSERT INTO Item VALUES(14,2,15,18,1.5);
INSERT INTO Item VALUES(14,1,9,22,1.5);
INSERT INTO Item VALUES(14,0,42,18,1.5);
INSERT INTO Customer VALUES(15,'Bill','Clancy','319 Upland Pl.','Seattle');
INSERT INTO Product VALUES(15,'Ice Tea Chair',94);