3 INSERT INTO config.upgrade_log (version) VALUES ('0098'); -- Scott McKellar
5 CREATE TABLE query.stored_query (
7 type TEXT NOT NULL CONSTRAINT query_type CHECK
8 ( type IN ( 'SELECT', 'UNION', 'INTERSECT', 'EXCEPT' ) ),
9 use_all BOOLEAN NOT NULL DEFAULT FALSE,
10 use_distinct BOOLEAN NOT NULL DEFAULT FALSE,
11 from_clause INT NOT NULL , --REFERENCES query.from_clause
12 where_clause INT , --REFERENCES query.expression
13 --DEFERRABLE INITIALLY DEFERRED,
14 having_clause INT --REFERENCES query.expression
15 --DEFERRABLE INITIALLY DEFERRED
18 -- (Foreign keys to be defined later after other tables are created)
20 CREATE TABLE query.query_sequence (
21 id SERIAL PRIMARY KEY,
22 parent_query INT NOT NULL
23 REFERENCES query.stored_query
25 DEFERRABLE INITIALLY DEFERRED,
27 child_query INT NOT NULL
28 REFERENCES query.stored_query
30 DEFERRABLE INITIALLY DEFERRED,
31 CONSTRAINT query_query_seq UNIQUE( parent_query, seq_no )