Mercurial > gemma

comparison schema/gemma.sql @ 5393:fe3f651bb03d extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove octree_index and octree_checksum column from schema. They are not needed any longer and are replaced by mesh_index and mesh_checksum.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sun, 04 Jul 2021 10:52:56 +0200
parents 18969a4d31b6
children f1a42eea08d3
comparison
equal deleted inserted replaced
5392:014dc3219bdb 5393:fe3f651bb03d
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