Mercurial > gemma
comparison schema/gemma.sql @ 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 | 2d294ad81241 |
children | 345515bc4548 |
comparison
equal
deleted
inserted
replaced
5421:c9da747d4109 | 5422:ad8e3fffb868 |
---|---|
831 | 831 |
832 CREATE TABLE sounding_results_marking_points ( | 832 CREATE TABLE sounding_results_marking_points ( |
833 sounding_result_id int NOT NULL REFERENCES sounding_results | 833 sounding_result_id int NOT NULL REFERENCES sounding_results |
834 ON DELETE CASCADE, | 834 ON DELETE CASCADE, |
835 height numeric NOT NULL, | 835 height numeric NOT NULL, |
836 points geometry(MULTIPOINTZ, 4326) NOT NULL, | 836 points geography(MULTIPOINTZ, 4326) NOT NULL, |
837 PRIMARY KEY (sounding_result_id, height) | 837 PRIMARY KEY (sounding_result_id, height) |
838 ) | 838 ) |
839 | 839 |
840 -- | 840 -- |
841 -- Fairway availability | 841 -- Fairway availability |