Mercurial > gemma

comparison schema/gemma.sql @ 4057:b79b60c0cc5a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
date_info has to be provided by the data source
author Tom Gottfried <tom@intevation.de>
date Thu, 25 Jul 2019 08:16:34 +0200
parents 4f2f34f5d14d
children 4332b9e26e2f 419f28898db0
comparison
equal deleted inserted replaced
4056:1ecfe5d015b0 4057:b79b60c0cc5a
731 bottleneck_id int NOT NULL REFERENCES bottlenecks(id), 731 bottleneck_id int NOT NULL REFERENCES bottlenecks(id),
732 surdat date NOT NULL, 732 surdat date NOT NULL,
733 UNIQUE (bottleneck_id, surdat), 733 UNIQUE (bottleneck_id, surdat),
734 -- additional_data xml -- Currently not relevant for GEMMA 734 -- additional_data xml -- Currently not relevant for GEMMA
735 critical boolean, 735 critical boolean,
736 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, 736 date_info timestamp with time zone NOT NULL,
737 source_organization varchar NOT NULL 737 source_organization varchar NOT NULL
738 ) 738 )
739 CREATE TRIGGER fairway_availability_date_info
740 BEFORE UPDATE ON fairway_availability
741 FOR EACH ROW EXECUTE PROCEDURE update_date_info()
742 739
743 CREATE TABLE fa_reference_values ( 740 CREATE TABLE fa_reference_values (
744 fairway_availability_id int NOT NULL REFERENCES fairway_availability, 741 fairway_availability_id int NOT NULL REFERENCES fairway_availability,
745 level_of_service smallint NOT NULL REFERENCES levels_of_service, 742 level_of_service smallint NOT NULL REFERENCES levels_of_service,
746 PRIMARY KEY (fairway_availability_id, level_of_service), 743 PRIMARY KEY (fairway_availability_id, level_of_service),