Mercurial > gemma

changeset 383:84597b9da68e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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,