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