1 -- Script to create the query schema and the tables therein
5 INSERT INTO config.upgrade_log (version) VALUES ('0102'); -- Scott McKellar
7 CREATE TABLE query.record_column (
9 from_relation INT NOT NULL REFERENCES query.from_relation
11 DEFERRABLE INITIALLY DEFERRED,
13 column_name TEXT NOT NULL,
14 column_type INT NOT NULL REFERENCES query.datatype
16 DEFERRABLE INITIALLY DEFERRED,
17 CONSTRAINT column_sequence UNIQUE (from_relation, seq_no)
20 CREATE TABLE query.select_item (
21 id SERIAL PRIMARY KEY,
22 stored_query INT NOT NULL REFERENCES query.stored_query
24 DEFERRABLE INITIALLY DEFERRED,
26 expression INT NOT NULL REFERENCES query.expression
27 DEFERRABLE INITIALLY DEFERRED,
29 grouped_by BOOL NOT NULL DEFAULT FALSE,
30 CONSTRAINT select_sequence UNIQUE( stored_query, seq_no )
33 CREATE TABLE query.order_by_item (
34 id SERIAL PRIMARY KEY,
35 stored_query INT NOT NULL REFERENCES query.stored_query
37 DEFERRABLE INITIALLY DEFERRED,
39 expression INT NOT NULL REFERENCES query.expression
41 DEFERRABLE INITIALLY DEFERRED,
42 CONSTRAINT order_by_sequence UNIQUE( stored_query, seq_no )