Mercurial > gemma

changeset 89:a36bfec5edd3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Move more tables to waterway schema to tweak diagrams.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 19:24:11 +0200
parents a96fee9654db
children a8878834adfb
files wamos.sql
diffstat 1 files changed, 11 insertions(+), 11 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri Jun 01 19:18:18 2018 +0200
+++ b/wamos.sql	Fri Jun 01 19:24:11 2018 +0200
@@ -200,6 +200,17 @@
        -- TODO: add real profile attributes (DRC 2.2.3)
        );
 
+CREATE TABLE wamos_waterway.levels_of_service (
+       level_of_service smallint PRIMARY KEY
+       );
+
+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)
+       );
+
 --
 -- Bottlenecks
 --
@@ -286,21 +297,10 @@
 --
 -- Fairway availability
 --
-CREATE TABLE wamos_fairway.levels_of_service (
-       level_of_service smallint PRIMARY KEY
-       );
-
 CREATE TABLE wamos_fairway.measure_types (
        measure_type varchar PRIMARY KEY
        );
 
-CREATE TABLE wamos_fairway.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.fairway_availability (
        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
        position_code char(2) REFERENCES position_codes,