|
HSQLDB example source code file (sample.sql)
The HSQLDB sample.sql source code/* $Id: sample.sql,v 1.4 2005/02/25 23:34:30 fredt Exp $ Examplifies use of SqlTool. PCTASK Table creation */ /* Ignore error for these two statements */ \c true DROP TABLE pctasklist; DROP TABLE pctask; \c false \p Creating table pctask CREATE TABLE pctask ( id integer identity, name varchar(40), description varchar, url varchar, UNIQUE (name) ); \p Creating table pctasklist CREATE TABLE pctasklist ( id integer identity, host varchar(20) not null, tasksequence int not null, pctask integer, assigndate timestamp default current_timestamp, completedate timestamp, show bit default true, FOREIGN KEY (pctask) REFERENCES pctask, UNIQUE (host, tasksequence) ); \p Granting privileges GRANT select ON pctask TO public; GRANT all ON pctask TO tomcat; GRANT select ON pctasklist TO public; GRANT all ON pctasklist TO tomcat; \p Inserting test records INSERT INTO pctask (name, description, url) VALUES ( 'task one', 'Description for task 1', 'http://cnn.com'); INSERT INTO pctasklist (host, tasksequence, pctask) VALUES ( 'admc-masq', 101, SELECT id FROM pctask WHERE name = 'task one'); commit; Other HSQLDB examples (source code examples)Here is a short list of links related to this HSQLDB sample.sql source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.