Mercurial > gemma

comparison schema/gemma.sql @ 5031:8c590ef35280

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improve feedback if geometry cannot be stored This is also a backout of rev. 36a3dce20232
author Tom Gottfried <tom@intevation.de>
date Wed, 18 Mar 2020 19:19:09 +0100
parents 737d7859dd86
children e21cbb9768a2 f64ff954ee31
comparison
equal deleted inserted replaced
5030:737d7859dd86 5031:8c590ef35280
706 FOR EACH ROW EXECUTE PROCEDURE update_date_info() 706 FOR EACH ROW EXECUTE PROCEDURE update_date_info()
707 707
708 CREATE TABLE fairway_dimensions ( 708 CREATE TABLE fairway_dimensions (
709 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 709 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
710 area geography(MULTIPOLYGON, 4326) NOT NULL 710 area geography(MULTIPOLYGON, 4326) NOT NULL
711 CHECK(ST_IsValid(CAST(area AS geometry))), 711 CHECK(ST_IsValid(CAST(area AS geometry))
712 AND NOT ST_IsEmpty(CAST(area AS geometry))),
712 level_of_service smallint NOT NULL REFERENCES levels_of_service, 713 level_of_service smallint NOT NULL REFERENCES levels_of_service,
713 min_width smallint NOT NULL, 714 min_width smallint NOT NULL,
714 max_width smallint NOT NULL, 715 max_width smallint NOT NULL,
715 min_depth smallint NOT NULL, 716 min_depth smallint NOT NULL,
716 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, 717 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,