# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1533919455 -7200
# Node ID 84597b9da68efd6667ec13986b80a3c9c67fa8a4
# Parent  f9b6f5a2aaa918b7cb5e710703d32490d9dfcd41
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.

diff -r f9b6f5a2aaa9 -r 84597b9da68e schema/gemma.sql
--- 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,