Mercurial > gemma

diff schema/gemma.sql @ 720:aeaa2adf5a8b octree

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
octree: write SQL insert statements for octree indices.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 21 Sep 2018 17:36:00 +0200
parents 77928a3497f1
children 4d6329afc1ea
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Sep 21 16:29:38 2018 +0200
+++ b/schema/gemma.sql	Fri Sep 21 17:36:00 2018 +0200
@@ -406,6 +406,11 @@
 
     CREATE INDEX meshes_gix ON meshes USING gist(geom)
 
+    CREATE TABLE octrees (
+        sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results,
+        checksum varchar NOT NULL,
+        octree_index bytea NOT NULL
+    )
     --
     -- Fairway availability
     --