Mercurial > gemma

changeset 75:ed7a50cfbc19

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add sections and stretches stub and fix comment.
author Tom Gottfried <tom@intevation.de>
date Wed, 30 May 2018 17:09:47 +0200
parents 8c0af903a764
children 2a6e49a7b839
files wamos.sql
diffstat 1 files changed, 10 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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)
        );
 
 --