Mercurial > gemma
diff schema/gemma.sql @ 1131:2e6b47cdb2ca
Store octrees along with sounding results
The extra table with 1:1-relation to sounding results was a
provisorial solution with the intention to make it easily removable.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 07 Nov 2018 17:54:50 +0100 |
parents | 72cad6277e3a |
children | dd4071019676 |
line wrap: on
line diff
--- a/schema/gemma.sql Wed Nov 07 17:54:31 2018 +0100 +++ b/schema/gemma.sql Wed Nov 07 17:54:50 2018 +0100 @@ -416,15 +416,11 @@ coverage varchar REFERENCES coverage_types, depth_reference char(3) NOT NULL REFERENCES depth_references, point_cloud geography(MULTIPOINTZ, 4326) NOT NULL, + octree_checksum varchar, + octree_index bytea, staging_done boolean NOT NULL DEFAULT false ) - CREATE TABLE octrees ( - sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results, - checksum varchar NOT NULL, - octree_index bytea NOT NULL - ) - CREATE TABLE sounding_results_contour_lines ( sounding_result_id int NOT NULL REFERENCES sounding_results, height numeric NOT NULL,