Mercurial > gemma

diff schema/gemma.sql @ 1131:2e6b47cdb2ca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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,