sampledata.sql

hsql是很有名的嵌入式数据库

INSERT INTO Item VALUES(34,11,4,17,1.5);
INSERT INTO Item VALUES(34,10,41,16,1.5);
INSERT INTO Item VALUES(34,9,8,17,1.5);
INSERT INTO Item VALUES(34,8,3,1,1.5);
INSERT INTO Item VALUES(34,7,21,22,1.5);
INSERT INTO Item VALUES(34,6,32,7,1.5);
INSERT INTO Item VALUES(34,5,45,13,1.5);
INSERT INTO Item VALUES(34,4,27,1,1.5);
INSERT INTO Item VALUES(34,3,44,15,1.5);
INSERT INTO Item VALUES(34,2,28,22,1.5);
INSERT INTO Item VALUES(34,1,4,3,1.5);
INSERT INTO Item VALUES(34,0,10,22,1.5);
INSERT INTO Customer VALUES(35,'George','Karsen','412 College Av.','Chicago');
INSERT INTO Product VALUES(35,'Telephone Shoe',76);
INSERT INTO Invoice VALUES(35,4,0.0);
INSERT INTO Item VALUES(35,13,19,17,1.5);
INSERT INTO Item VALUES(35,12,7,23,1.5);
INSERT INTO Item VALUES(35,11,44,9,1.5);
INSERT INTO Item VALUES(35,10,17,11,1.5);
INSERT INTO Item VALUES(35,9,19,1,1.5);
INSERT INTO Item VALUES(35,8,0,1,1.5);
INSERT INTO Item VALUES(35,7,22,15,1.5);
INSERT INTO Item VALUES(35,6,5,4,1.5);
INSERT INTO Item VALUES(35,5,33,5,1.5);
INSERT INTO Item VALUES(35,4,14,17,1.5);
INSERT INTO Item VALUES(35,3,27,10,1.5);
INSERT INTO Item VALUES(35,2,14,4,1.5);
INSERT INTO Item VALUES(35,1,3,9,1.5);
INSERT INTO Item VALUES(35,0,20,17,1.5);
INSERT INTO Customer VALUES(36,'John','Steel','276 Upland Pl.','Dallas');
INSERT INTO Product VALUES(36,'Ice Tea Iron',32);
INSERT INTO Invoice VALUES(36,42,0.0);
INSERT INTO Item VALUES(36,11,44,9,1.5);
INSERT INTO Item VALUES(36,10,47,11,1.5);
INSERT INTO Item VALUES(36,9,31,18,1.5);
INSERT INTO Item VALUES(36,8,4,21,1.5);
INSERT INTO Item VALUES(36,7,39,19,1.5);
INSERT INTO Item VALUES(36,6,39,20,1.5);
INSERT INTO Item VALUES(36,5,25,8,1.5);
INSERT INTO Item VALUES(36,4,40,5,1.5);
INSERT INTO Item VALUES(36,3,10,8,1.5);
INSERT INTO Item VALUES(36,2,1,6,1.5);
INSERT INTO Item VALUES(36,1,15,23,1.5);
INSERT INTO Item VALUES(36,0,18,13,1.5);
INSERT INTO Customer VALUES(37,'Michael','Clancy','19 Seventh Av.','Dallas');
INSERT INTO Product VALUES(37,'Clock Shoe',94);
INSERT INTO Invoice VALUES(37,39,0.0);
INSERT INTO Item VALUES(37,21,6,9,1.5);
INSERT INTO Item VALUES(37,20,14,1,1.5);
INSERT INTO Item VALUES(37,19,19,20,1.5);
INSERT INTO Item VALUES(37,18,26,22,1.5);
INSERT INTO Item VALUES(37,17,38,18,1.5);
INSERT INTO Item VALUES(37,16,27,8,1.5);
INSERT INTO Item VALUES(37,15,32,12,1.5);
INSERT INTO Item VALUES(37,14,12,3,1.5);
INSERT INTO Item VALUES(37,13,32,3,1.5);
INSERT INTO Item VALUES(37,12,24,23,1.5);
INSERT INTO Item VALUES(37,11,30,5,1.5);
INSERT INTO Item VALUES(37,10,1,18,1.5);
INSERT INTO Item VALUES(37,9,47,16,1.5);
INSERT INTO Item VALUES(37,8,46,9,1.5);
INSERT INTO Item VALUES(37,7,24,19,1.5);
INSERT INTO Item VALUES(37,6,34,12,1.5);
INSERT INTO Item VALUES(37,5,1,14,1.5);
INSERT INTO Item VALUES(37,4,13,20,1.5);
INSERT INTO Item VALUES(37,3,26,7,1.5);
INSERT INTO Item VALUES(37,2,36,8,1.5);
INSERT INTO Item VALUES(37,1,15,20,1.5);
INSERT INTO Item VALUES(37,0,41,24,1.5);
INSERT INTO Customer VALUES(38,'Andrew','Heiniger','347 College Av.','Lyon');
INSERT INTO Product VALUES(38,'Clock Ice Tea',216);
INSERT INTO Invoice VALUES(38,46,0.0);
INSERT INTO Item VALUES(38,19,4,7,1.5);
INSERT INTO Item VALUES(38,18,28,20,1.5);
INSERT INTO Item VALUES(38,17,32,4,1.5);
INSERT INTO Item VALUES(38,16,40,18,1.5);
INSERT INTO Item VALUES(38,15,47,10,1.5);
INSERT INTO Item VALUES(38,14,20,7,1.5);
INSERT INTO Item VALUES(38,13,8,7,1.5);
INSERT INTO Item VALUES(38,12,1,18,1.5);
INSERT INTO Item VALUES(38,11,19,18,1.5);
INSERT INTO Item VALUES(38,10,4,18,1.5);
INSERT INTO Item VALUES(38,9,27,20,1.5);
INSERT INTO Item VALUES(38,8,40,10,1.5);
INSERT INTO Item VALUES(38,7,15,1,1.5);
INSERT INTO Item VALUES(38,6,5,19,1.5);
INSERT INTO Item VALUES(38,5,48,17,1.5);
INSERT INTO Item VALUES(38,4,45,14,1.5);
INSERT INTO Item VALUES(38,3,27,19,1.5);
INSERT INTO Item VALUES(38,2,4,8,1.5);
INSERT INTO Item VALUES(38,1,45,13,1.5);
INSERT INTO Item VALUES(38,0,48,14,1.5);
INSERT INTO Customer VALUES(39,'Mary','Karsen','202 College Av.','Chicago');
INSERT INTO Product VALUES(39,'Ice Tea Shoe',154);
INSERT INTO Invoice VALUES(39,5,0.0);
INSERT INTO Item VALUES(39,3,20,17,1.5);
INSERT INTO Item VALUES(39,2,39,16,1.5);
INSERT INTO Item VALUES(39,1,24,6,1.5);
INSERT INTO Item VALUES(39,0,10,12,1.5);
INSERT INTO Customer VALUES(40,'Susanne','Miller','440 - 20th Ave.','Dallas');
INSERT INTO Product VALUES(40,'Shoe Clock',28);
INSERT INTO Invoice VALUES(40,4,0.0);
INSERT INTO Item VALUES(40,20,4,16,1.5);
INSERT INTO Item VALUES(40,19,7,23,1.5);
INSERT INTO Item VALUES(40,18,33,11,1.5);
INSERT INTO Item VALUES(40,17,4,20,1.5);
INSERT INTO Item VALUES(40,16,27,16,1.5);
INSERT INTO Item VALUES(40,15,22,12,1.5);
INSERT INTO Item VALUES(40,14,4,24,1.5);
INSERT INTO Item VALUES(40,13,6,8,1.5);
INSERT INTO Item VALUES(40,12,35,13,1.5);
INSERT INTO Item VALUES(40,11,27,2,1.5);
INSERT INTO Item VALUES(40,10,6,11,1.5);
INSERT INTO Item VALUES(40,9,40,17,1.5);
INSERT INTO Item VALUES(40,8,11,4,1.5);
INSERT INTO Item VALUES(40,7,31,1,1.5);
INSERT INTO Item VALUES(40,6,28,12,1.5);
INSERT INTO Item VALUES(40,5,32,18,1.5);
INSERT INTO Item VALUES(40,4,18,13,1.5);
INSERT INTO Item VALUES(40,3,26,10,1.5);
INSERT INTO Item VALUES(40,2,4,5,1.5);
INSERT INTO Item VALUES(40,1,45,24,1.5);
INSERT INTO Item VALUES(40,0,46,24,1.5);
INSERT INTO Customer VALUES(41,'Bill','King','546 College Av.','New York');
INSERT INTO Product VALUES(41,'Clock Ice Tea',206);
INSERT INTO Invoice VALUES(41,19,0.0);
INSERT INTO Item VALUES(41,11,48,15,1.5);
INSERT INTO Item VALUES(41,10,24,20,1.5);
INSERT INTO Item VALUES(41,9,26,21,1.5);
INSERT INTO Item VALUES(41,8,9,22,1.5);
INSERT INTO Item VALUES(41,7,22,18,1.5);
INSERT INTO Item VALUES(41,6,17,11,1.5);
INSERT INTO Item VALUES(41,5,9,21,1.5);
INSERT INTO Item VALUES(41,4,16,22,1.5);
INSERT INTO Item VALUES(41,3,29,20,1.5);
INSERT INTO Item VALUES(41,2,36,2,1.5);
INSERT INTO Item VALUES(41,1,47,19,1.5);
INSERT INTO Item VALUES(41,0,5,24,1.5);
INSERT INTO Customer VALUES(42,'Robert','Ott','503 Seventh Av.','Oslo');
INSERT INTO Product VALUES(42,'Iron Chair',198);
INSERT INTO Invoice VALUES(42,38,0.0);
INSERT INTO Item VALUES(42,4,48,15,1.5);
INSERT INTO Item VALUES(42,3,40,14,1.5);
INSERT INTO Item VALUES(42,2,40,19,1.5);
INSERT INTO Item VALUES(42,1,18,21,1.5);
INSERT INTO Item VALUES(42,0,48,9,1.5);
INSERT INTO Customer VALUES(43,'Susanne','Smith','2 Upland Pl.','Dallas');
INSERT INTO Product VALUES(43,'Telephone Clock',94);
INSERT INTO Invoice VALUES(43,13,0.0);
INSERT INTO Item VALUES(43,16,38,12,1.5);
INSERT INTO Item VALUES(43,15,48,7,1.5);
INSERT INTO Item VALUES(43,14,3,18,1.5);
INSERT INTO Item VALUES(43,13,44,22,1.5);
INSERT INTO Item VALUES(43,12,40,24,1.5);
INSERT INTO Item VALUES(43,11,49,23,1.5);
INSERT INTO Item VALUES(43,10,35,1,1.5);
INSERT INTO Item VALUES(43,9,7,23,1.5);
INSERT INTO Item VALUES(43,8,44,8,1.5);
INSERT INTO Item VALUES(43,7,11,15,1.5);
INSERT INTO Item VALUES(43,6,24,1,1.5);
INSERT INTO Item VALUES(43,5,33,6,1.5);
INSERT INTO Item VALUES(43,4,32,22,1.5);
INSERT INTO Item VALUES(43,3,6,18,1.5);
INSERT INTO Item VALUES(43,2,2,15,1.5);
INSERT INTO Item VALUES(43,1,18,19,1.5);
INSERT INTO Item VALUES(43,0,15,22,1.5);
INSERT INTO Customer VALUES(44,'Sylvia','Ott','361 College Av.','New York');
INSERT INTO Product VALUES(44,'Ice Tea Ice Tea',96);
INSERT INTO Invoice VALUES(44,32,0.0);
INSERT INTO Item VALUES(44,8,28,23,1.5);
INSERT INTO Item VALUES(44,7,49,17,1.5);
INSERT INTO Item VALUES(44,6,14,15,1.5);
INSERT INTO Item VALUES(44,5,41,22,1.5);
INSERT INTO Item VALUES(44,4,12,3,1.5);
INSERT INTO Item VALUES(44,3,3,14,1.5);
INSERT INTO Item VALUES(44,2,17,14,1.5);
INSERT INTO Item VALUES(44,1,34,17,1.5);
INSERT INTO Item VALUES(44,0,33,20,1.5);
INSERT INTO Customer VALUES(45,'Janet','May','396 Seventh Av.','Oslo');
INSERT INTO Product VALUES(45,'Iron Ice Tea',180);
INSERT INTO Invoice VALUES(45,42,0.0);
INSERT INTO Item VALUES(45,14,3,16,1.5);
INSERT INTO Item VALUES(45,13,47,8,1.5);
INSERT INTO Item VALUES(45,12,32,13,1.5);
INSERT INTO Item VALUES(45,11,31,22,1.5);
INSERT INTO Item VALUES(45,10,41,24,1.5);
INSERT INTO Item VALUES(45,9,26,18,1.5);
INSERT INTO Item VALUES(45,8,9,2,1.5);
INSERT INTO Item VALUES(45,7,6,24,1.5);
INSERT INTO Item VALUES(45,6,39,5,1.5);
INSERT INTO Item VALUES(45,5,45,17,1.5);
INSERT INTO Item VALUES(45,4,3,14,1.5);
INSERT INTO Item VALUES(45,3,14,11,1.5);
INSERT INTO Item VALUES(45,2,46,8,1.5);
INSERT INTO Item VALUES(45,1,11,6,1.5);
INSERT INTO Item VALUES(45,0,44,6,1.5);
INSERT INTO Customer VALUES(46,'Andrew','May','172 Seventh Av.','New York');
INSERT INTO Product VALUES(46,'Ice Tea Clock',62);
INSERT INTO Invoice VALUES(46,24,0.0);
INSERT INTO Item VALUES(46,17,12,23,1.5);
INSERT INTO Item VALUES(46,16,46,21,1.5);
INSERT INTO Item VALUES(46,15,40,11,1.5);
INSERT INTO Item VALUES(46,14,24,10,1.5);
INSERT INTO Item VALUES(46,13,36,20,1.5);
INSERT INTO Item VALUES(46,12,21,24,1.5);
INSERT INTO Item VALUES(46,11,1,4,1.5);
INSERT INTO Item VALUES(46,10,11,24,1.5);
INSERT INTO Item VALUES(46,9,7,4,1.5);
INSERT INTO Item VALUES(46,8,8,22,1.5);
INSERT INTO Item VALUES(46,7,49,9,1.5);
INSERT INTO Item VALUES(46,6,41,18,1.5);
INSERT INTO Item VALUES(46,5,25,9,1.5);
INSERT INTO Item VALUES(46,4,17,5,1.5);
INSERT INTO Item VALUES(46,3,21,19,1.5);
INSERT INTO Item VALUES(46,2,30,14,1.5);
INSERT INTO Item VALUES(46,1,12,24,1.5);
INSERT INTO Item VALUES(46,0,5,21,1.5);
INSERT INTO Customer VALUES(47,'Janet','Fuller','445 Upland Pl.','Dallas');
INSERT INTO Product VALUES(47,'Ice Tea Iron',178);
INSERT INTO Invoice VALUES(47,45,0.0);
INSERT INTO Item VALUES(47,13,33,8,1.5);
INSERT INTO Item VALUES(47,12,12,20,1.5);
INSERT INTO Item VALUES(47,11,35,10,1.5);
INSERT INTO Item VALUES(47,10,45,2,1.5);
INSERT INTO Item VALUES(47,9,32,9,1.5);
INSERT INTO Item VALUES(47,8,16,2,1.5);
INSERT INTO Item VALUES(47,7,28,14,1.5);
INSERT INTO Item VALUES(47,6,8,10,1.5);
INSERT INTO Item VALUES(47,5,40,8,1.5);
INSERT INTO Item VALUES(47,4,15,1,1.5);
INSERT INTO Item VALUES(47,3,1,4,1.5);
INSERT INTO Item VALUES(47,2,17,6,1.5);
INSERT INTO Item VALUES(47,1,23,13,1.5);
INSERT INTO Item VALUES(47,0,23,15,1.5);
INSERT INTO Customer VALUES(48,'Robert','White','549 Seventh Av.','San Francisco');
INSERT INTO Product VALUES(48,'Clock Clock',210);
INSERT INTO Invoice VALUES(48,22,0.0);
INSERT INTO Item VALUES(48,10,41,10,1.5);
INSERT INTO Item VALUES(48,9,35,17,1.5);
INSERT INTO Item VALUES(48,8,5,12,1.5);
INSERT INTO Item VALUES(48,7,30,19,1.5);
INSERT INTO Item VALUES(48,6,11,17,1.5);
INSERT INTO Item VALUES(48,5,24,16,1.5);
INSERT INTO Item VALUES(48,4,48,4,1.5);
INSERT INTO Item VALUES(48,3,10,2,1.5);
INSERT INTO Item VALUES(48,2,23,10,1.5);
INSERT INTO Item VALUES(48,1,26,23,1.5);
INSERT INTO Item VALUES(48,0,6,23,1.5);
INSERT INTO Customer VALUES(49,'George','Fuller','534 - 20th Ave.','Olten');
INSERT INTO Product VALUES(49,'Iron Iron',22);
INSERT INTO Invoice VALUES(49,32,0.0);
INSERT INTO Item VALUES(49,16,24,18,1.5);
INSERT INTO Item VALUES(49,15,19,24,1.5);
INSERT INTO Item VALUES(49,14,23,5,1.5);
INSERT INTO Item VALUES(49,13,6,22,1.5);
INSERT INTO Item VALUES(49,12,21,17,1.5);
INSERT INTO Item VALUES(49,11,40,15,1.5);
INSERT INTO Item VALUES(49,10,30,16,1.5);
INSERT INTO Item VALUES(49,9,7,24,1.5);
INSERT INTO Item VALUES(49,8,48,24,1.5);
INSERT INTO Item VALUES(49,7,6,21,1.5);
INSERT INTO Item VALUES(49,6,29,15,1.5);
INSERT INTO Item VALUES(49,5,16,1,1.5);
INSERT INTO Item VALUES(49,4,47,14,1.5);
INSERT INTO Item VALUES(49,3,17,19,1.5);
INSERT INTO Item VALUES(49,2,29,6,1.5);
INSERT INTO Item VALUES(49,1,22,16,1.5);
INSERT INTO Item VALUES(49,0,18,6,1.5);
SET REFERENTIAL_INTEGRITY TRUE;
UPDATE Product SET Price=ROUND(Price*.1,2);
UPDATE Item SET Cost=Cost*SELECT Price FROM Product prod WHERE ProductID=prod.ID;
UPDATE Invoice SET Total=SELECT SUM(Cost*Quantity) FROM Item WHERE InvoiceID=Invoice.ID;

COMMIT;