Mercurial > gemma

comparison schema/gemma.sql @ 5395:23a30ba08243 extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into extended-report branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sun, 04 Jul 2021 11:38:30 +0200
parents f1a42eea08d3 4a6feb5d3727
children f5063fa7f666
comparison
equal deleted inserted replaced
5394:f1a42eea08d3 5395:23a30ba08243
805 CHECK(ST_IsValid(CAST(area AS geometry))), 805 CHECK(ST_IsValid(CAST(area AS geometry))),
806 surtyp varchar REFERENCES survey_types, 806 surtyp varchar REFERENCES survey_types,
807 coverage varchar REFERENCES coverage_types, 807 coverage varchar REFERENCES coverage_types,
808 depth_reference varchar NOT NULL, -- REFERENCES depth_references, 808 depth_reference varchar NOT NULL, -- REFERENCES depth_references,
809 zpg_exception bool NOT NULL DEFAULT FALSE, -- Found no LDC in ZPG case. 809 zpg_exception bool NOT NULL DEFAULT FALSE, -- Found no LDC in ZPG case.
810 octree_checksum varchar,
811 octree_index bytea,
812 mesh_checksum varchar, 810 mesh_checksum varchar,
813 mesh_index bytea, 811 mesh_index bytea,
814 staging_done boolean NOT NULL DEFAULT false 812 staging_done boolean NOT NULL DEFAULT false
815 ) 813 )
816 CREATE CONSTRAINT TRIGGER a_sounding_results_reference_bottleneck 814 CREATE CONSTRAINT TRIGGER a_sounding_results_reference_bottleneck