Mercurial > gemma

changeset 5422:ad8e3fffb868 marking-single-beam

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
schema: geography supports MULTIPOINTZ as modifier.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 08 Jul 2021 10:53:26 +0200
parents c9da747d4109
children 24156a964eaa
files schema/gemma.sql schema/updates/1460/01.markings.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Jul 08 01:46:03 2021 +0200
+++ b/schema/gemma.sql	Thu Jul 08 10:53:26 2021 +0200
@@ -833,7 +833,7 @@
         sounding_result_id int NOT NULL REFERENCES sounding_results
           ON DELETE CASCADE,
         height numeric NOT NULL,
-        points geometry(MULTIPOINTZ, 4326) NOT NULL,
+        points geography(MULTIPOINTZ, 4326) NOT NULL,
         PRIMARY KEY (sounding_result_id, height)
     )
 
--- a/schema/updates/1460/01.markings.sql	Thu Jul 08 01:46:03 2021 +0200
+++ b/schema/updates/1460/01.markings.sql	Thu Jul 08 10:53:26 2021 +0200
@@ -4,7 +4,7 @@
    sounding_result_id int NOT NULL REFERENCES waterway.sounding_results
      ON DELETE CASCADE,
    height numeric NOT NULL,
-   points geometry(MULTIPOINTZ, 4326) NOT NULL,
+   points geography(MULTIPOINTZ, 4326) NOT NULL,
    PRIMARY KEY (sounding_result_id, height)
 );