Mercurial > gemma

comparison schema/gemma.sql @ 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 d5b707bbd1d5
children b8366b24dc55
comparison
equal deleted inserted replaced
382:f9b6f5a2aaa9 383:84597b9da68e
195 -- rwdr double precision NOT NULL, 195 -- rwdr double precision NOT NULL,
196 -- EXCLUDE USING GIST (stretch WITH &&) 196 -- EXCLUDE USING GIST (stretch WITH &&)
197 --) 197 --)
198 198
199 CREATE TABLE waterway_area ( 199 CREATE TABLE waterway_area (
200 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
200 area geography(POLYGON, 4326) NOT NULL, 201 area geography(POLYGON, 4326) NOT NULL,
201 catccl smallint REFERENCES catccls, 202 catccl smallint REFERENCES catccls,
202 dirimp smallint REFERENCES dirimps 203 dirimp smallint REFERENCES dirimps
203 ) 204 )
204 CREATE UNIQUE INDEX ON waterway_area ((ST_GeoHash(area, 23))) 205 CREATE UNIQUE INDEX ON waterway_area ((ST_GeoHash(area, 23)))
257 CREATE TRIGGER gauge_measurements_date_info 258 CREATE TRIGGER gauge_measurements_date_info
258 BEFORE UPDATE ON gauge_measurements 259 BEFORE UPDATE ON gauge_measurements
259 FOR EACH ROW EXECUTE PROCEDURE update_date_info() 260 FOR EACH ROW EXECUTE PROCEDURE update_date_info()
260 261
261 CREATE TABLE waterway_axis ( 262 CREATE TABLE waterway_axis (
263 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
262 wtwaxs geography(LINESTRING, 4326) NOT NULL, 264 wtwaxs geography(LINESTRING, 4326) NOT NULL,
263 -- TODO: Do we need to check data set quality (DRC 2.1.6)? 265 -- TODO: Do we need to check data set quality (DRC 2.1.6)?
264 objnam varchar NOT NULL, 266 objnam varchar NOT NULL,
265 nobjnam varchar 267 nobjnam varchar
266 ) 268 )
313 CREATE TRIGGER waterway_profiles_date_info 315 CREATE TRIGGER waterway_profiles_date_info
314 BEFORE UPDATE ON waterway_profiles 316 BEFORE UPDATE ON waterway_profiles
315 FOR EACH ROW EXECUTE PROCEDURE update_date_info() 317 FOR EACH ROW EXECUTE PROCEDURE update_date_info()
316 318
317 CREATE TABLE fairway_dimensions ( 319 CREATE TABLE fairway_dimensions (
320 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
318 area geography(POLYGON, 4326) NOT NULL, 321 area geography(POLYGON, 4326) NOT NULL,
319 level_of_service smallint NOT NULL REFERENCES levels_of_service, 322 level_of_service smallint NOT NULL REFERENCES levels_of_service,
320 min_width smallint NOT NULL, 323 min_width smallint NOT NULL,
321 max_width smallint NOT NULL, 324 max_width smallint NOT NULL,
322 min_depth smallint NOT NULL, 325 min_depth smallint NOT NULL,