Mercurial > gemma
changeset 383:84597b9da68e
Let all tables have a PRIMARY KEY again
GeoServer requires tables to have a PK if no extra settings
should be provided. Thus, add PKs without meaning to tables
that might be served through GeoServer.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 10 Aug 2018 18:44:15 +0200 |
parents | f9b6f5a2aaa9 |
children | af82a8989b44 |
files | schema/gemma.sql |
diffstat | 1 files changed, 3 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Fri Aug 10 18:31:52 2018 +0200 +++ b/schema/gemma.sql Fri Aug 10 18:44:15 2018 +0200 @@ -197,6 +197,7 @@ --) CREATE TABLE waterway_area ( + id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, area geography(POLYGON, 4326) NOT NULL, catccl smallint REFERENCES catccls, dirimp smallint REFERENCES dirimps @@ -259,6 +260,7 @@ FOR EACH ROW EXECUTE PROCEDURE update_date_info() CREATE TABLE waterway_axis ( + id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, wtwaxs geography(LINESTRING, 4326) NOT NULL, -- TODO: Do we need to check data set quality (DRC 2.1.6)? objnam varchar NOT NULL, @@ -315,6 +317,7 @@ FOR EACH ROW EXECUTE PROCEDURE update_date_info() CREATE TABLE fairway_dimensions ( + id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, area geography(POLYGON, 4326) NOT NULL, level_of_service smallint NOT NULL REFERENCES levels_of_service, min_width smallint NOT NULL,