# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527688682 -7200
# Node ID beb1863eefaf0b8ff9df4a5ba8f92632a6f91860
# Parent  7a91106668b8f24e8fa946f4f64dae75b14919e6
Add waterway area.

diff -r 7a91106668b8 -r beb1863eefaf wamos.sql
--- a/wamos.sql	Fri May 25 22:17:20 2018 +0200
+++ b/wamos.sql	Wed May 30 15:58:02 2018 +0200
@@ -45,6 +45,22 @@
 --        EXCLUDE USING GIST (stretch WITH &&)
 --        );
 
+CREATE TABLE wamos.countries (
+       country_code char(2) PRIMARY KEY -- ISO 3166 country code
+       -- A smallint PK would require even less disk space i.e. on the FK side.
+       -- This might be an issue in case cache space becomes a limiting
+       -- factor when there are many FKs pointing here.
+       );
+
+--
+-- General river information
+--
+CREATE TABLE wamos.waterway_area (
+       dummy_attrib varchar,
+       "..." varchar
+       -- TODO: add real waterway area attributes (DRC 2.1.3)
+       );
+
 CREATE TABLE wamos.gauges (
        location isrs PRIMARY KEY,
        dummy_attrib varchar,
@@ -52,13 +68,6 @@
        -- TODO: add real gauge attributes (DRC 2.1.4)
        );
 
-CREATE TABLE wamos.countries (
-       country_code char(2) PRIMARY KEY -- ISO 3166 country code
-       -- A smallint PK would require even less disk space i.e. on the FK side.
-       -- This might be an issue in case cache space becomes a limiting
-       -- factor when there are many FKs pointing here.
-       );
-
 --
 -- Bottlenecks
 --