Mercurial > gemma

comparison schema/gemma.sql @ 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 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