# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527693837 -7200
# Node ID 2a6e49a7b8397707b3d52b7e2c80d488462e0fd0
# Parent  ed7a50cfbc19fc2163017df705a4eac4b15f2152
Add fairway dimensions stub.

diff -r ed7a50cfbc19 -r 2a6e49a7b839 wamos.sql
--- a/wamos.sql	Wed May 30 17:09:47 2018 +0200
+++ b/wamos.sql	Wed May 30 17:23:57 2018 +0200
@@ -212,6 +212,13 @@
        measure_type varchar PRIMARY KEY
        );
 
+CREATE TABLE fairway_dimensions (
+       level_of_service smallint REFERENCES levels_of_service,
+       dummy_attrib varchar,
+       "..." varchar
+       -- TODO: add real fairway dimension attributes (DRC 2.2.2)
+       );
+
 CREATE TABLE wamos.fairway_availability (
        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
        position varchar REFERENCES spot_marks,