Mercurial > gemma

comparison schema/gemma.sql @ 5417:2d294ad81241 marking-single-beam

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Dont loose Z values in markings.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 07 Jul 2021 18:14:04 +0200
parents f5063fa7f666
children ad8e3fffb868
comparison
equal deleted inserted replaced
5416:31b0e865e7a0 5417:2d294ad81241
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 geography(MULTIPOINT, 4326) NOT NULL, 836 points geometry(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