1 -- @tag: custom_data_export
2 -- @description: Benutzerdefinierter Datenexport
3 -- @depends: release_3_5_0
4 CREATE TYPE custom_data_export_query_parameter_type_enum AS ENUM ('text', 'number', 'date', 'timestamp');
6 CREATE TABLE custom_data_export_queries (
9 description TEXT NOT NULL,
10 sql_query TEXT NOT NULL,
12 itime TIMESTAMP NOT NULL DEFAULT now(),
13 mtime TIMESTAMP NOT NULL DEFAULT now(),
18 CREATE TABLE custom_data_export_query_parameters (
20 query_id INTEGER NOT NULL,
23 parameter_type custom_data_export_query_parameter_type_enum NOT NULL,
24 itime TIMESTAMP NOT NULL DEFAULT now(),
25 mtime TIMESTAMP NOT NULL DEFAULT now(),
28 FOREIGN KEY (query_id) REFERENCES custom_data_export_queries (id) ON DELETE CASCADE
31 CREATE TRIGGER mtime_custom_data_export_queries
32 BEFORE UPDATE ON custom_data_export_queries
33 FOR EACH ROW EXECUTE PROCEDURE set_mtime();
35 CREATE TRIGGER mtime_custom_data_export_query_parameters
36 BEFORE UPDATE ON custom_data_export_query_parameters
37 FOR EACH ROW EXECUTE PROCEDURE set_mtime();