# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527692987 -7200
# Node ID ed7a50cfbc19fc2163017df705a4eac4b15f2152
# Parent  8c0af903a7648ac17719c399443f9c4aedd1cbdd
Add sections and stretches stub and fix comment.

diff -r 8c0af903a764 -r ed7a50cfbc19 wamos.sql
--- a/wamos.sql	Wed May 30 16:58:30 2018 +0200
+++ b/wamos.sql	Wed May 30 17:09:47 2018 +0200
@@ -101,7 +101,16 @@
        -- TODO: add relations to stuff provided as enumerations
        dummy_attrib varchar,
        "..." varchar
-       -- TODO: add real waterway area attributes (DRC 2.1.3)
+       -- TODO: add real distance mark attributes (DRC 2.1.7)
+       );
+
+CREATE TABLE sections_stretches (
+       id varchar PRIMARY KEY,
+       is_section boolean NOT NULL, -- maps 'function' from interface
+       stretch isrsrange,
+       dummy_attrib varchar,
+       "..." varchar
+       -- TODO: add real section/stretch attributes (DRC 2.2.1)
        );
 
 --