Mercurial > gemma
changeset 5422:ad8e3fffb868 marking-single-beam
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) );