Mercurial > gemma
changeset 1861:5083a1d19a4b
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.