Mercurial > gemma
comparison schema/gemma.sql @ 4648:66fcd898efd9 stree-experiment
Started with conversion tool.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Sun, 13 Oct 2019 19:22:36 +0200 |
parents | 28999c7c0c18 |
children | 443867b548b5 |
comparison
equal
deleted
inserted
replaced
4647:18331577a251 | 4648:66fcd898efd9 |
---|---|
710 surtyp varchar REFERENCES survey_types, | 710 surtyp varchar REFERENCES survey_types, |
711 coverage varchar REFERENCES coverage_types, | 711 coverage varchar REFERENCES coverage_types, |
712 depth_reference varchar NOT NULL, -- REFERENCES depth_references, | 712 depth_reference varchar NOT NULL, -- REFERENCES depth_references, |
713 octree_checksum varchar, | 713 octree_checksum varchar, |
714 octree_index bytea, | 714 octree_index bytea, |
715 mesh_checksum varchar, | |
716 mesh_index bytea, | |
715 staging_done boolean NOT NULL DEFAULT false | 717 staging_done boolean NOT NULL DEFAULT false |
716 ) | 718 ) |
717 CREATE CONSTRAINT TRIGGER a_sounding_results_reference_bottleneck | 719 CREATE CONSTRAINT TRIGGER a_sounding_results_reference_bottleneck |
718 AFTER INSERT OR UPDATE OF bottleneck_id ON sounding_results | 720 AFTER INSERT OR UPDATE OF bottleneck_id ON sounding_results |
719 FOR EACH ROW | 721 FOR EACH ROW |