# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527874364 -7200
# Node ID a8878834adfbb269186fbe4be4541074af7a8a42
# Parent  a36bfec5edd3d4e53f7f6a1de99dc4fcfbe37400
Add fairway attributes.

diff -r a36bfec5edd3 -r a8878834adfb wamos.sql
--- a/wamos.sql	Fri Jun 01 19:24:11 2018 +0200
+++ b/wamos.sql	Fri Jun 01 19:32:44 2018 +0200
@@ -205,11 +205,16 @@
        );
 
 CREATE TABLE wamos_waterway.fairway_dimensions (
-       level_of_service smallint REFERENCES levels_of_service,
-       dummy_attrib varchar,
-       "..." varchar
-       -- TODO: add real fairway dimension attributes (DRC 2.2.2)
+       area geometry(POLYGON, 4326) PRIMARY KEY,
+       level_of_service smallint NOT NULL REFERENCES levels_of_service,
+       min_width smallint NOT NULL,
+       max_width smallint NOT NULL,
+       min_depth smallint NOT NULL,
+       date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+       source_organization varchar NOT NULL
        );
+CREATE TRIGGER fairway_dimensions_date_info BEFORE UPDATE ON fairway_dimensions
+       FOR EACH ROW EXECUTE PROCEDURE update_date_info();
 
 --
 -- Bottlenecks