Mercurial > gemma

changeset 1861:5083a1d19a4b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adjusted database schema for distance marks importer.
author Raimund Renkert <raimund.renkert@intevation.de>
date Thu, 17 Jan 2019 13:15:22 +0100
parents f54ac71db1ac
children 427f86518097
files schema/gemma.sql
diffstat 1 files changed, 6 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Jan 17 13:14:32 2019 +0100
+++ b/schema/gemma.sql	Thu Jan 17 13:15:22 2019 +0100
@@ -310,14 +310,14 @@
     )
 
     CREATE TABLE distance_marks (
-        country char(2) NOT NULL REFERENCES countries,
-        hectom int NOT NULL,
+        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+        country char(2) REFERENCES countries,
+        hectom int,
         geom geography(POINT, 4326) NOT NULL,
         -- include location in primary key, because we have no fairway code:
-        PRIMARY KEY (country, hectom, geom),
-        catdis smallint NOT NULL REFERENCES catdis,
-        position_code char(2) NOT NULL REFERENCES position_codes,
-        related_enc varchar(12) NOT NULL
+        catdis smallint REFERENCES catdis,
+        position_code char(2) REFERENCES position_codes,
+        related_enc varchar(12)
     )
 
     -- A table to help geoserver serve the distance marks as WFS 1.1.0.