Mercurial > gemma

changeset 731:4d6329afc1ea

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added table for contour lines of sounding results.
author Sascha L. Teichmann <teichmann@intevation.de>
date Sun, 23 Sep 2018 16:01:04 +0200
parents 4c05bdbf8e4b
children 39b5cf9a6b8f
files schema/gemma.sql
diffstat 1 files changed, 7 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Sat Sep 22 22:23:21 2018 +0200
+++ b/schema/gemma.sql	Sun Sep 23 16:01:04 2018 +0200
@@ -411,6 +411,13 @@
         checksum varchar NOT NULL,
         octree_index bytea NOT NULL
     )
+
+    CREATE TABLE sounding_results_contour_lines (
+        sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results,
+        height numeric NOT NULL,
+        lines geography(multilinestringz, 4326) NOT NULL,
+        UNIQUE (sounding_result_id, height)
+    )
     --
     -- Fairway availability
     --