Mercurial > gemma

changeset 76:2a6e49a7b839

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add fairway dimensions stub.
author Tom Gottfried <tom@intevation.de>
date Wed, 30 May 2018 17:23:57 +0200
parents ed7a50cfbc19
children e5bcd9293d3d
files wamos.sql
diffstat 1 files changed, 7 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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,