# HG changeset patch
# User Tom Gottfried <tom.gottfried@intevation.de>
# Date 1364382801 -3600
# Node ID 303701ab73c616a8953d204d771ef1fd09116de0
# Parent  5287440b57b3af038e1c15dba6633068f07fba63
store name and km of reference gauges in measurement_stations too, as not all are in gauges

diff -r 5287440b57b3 -r 303701ab73c6 flys-backend/doc/schema/oracle-minfo.sql
--- a/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 11:48:53 2013 +0100
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 12:13:21 2013 +0100
@@ -287,6 +287,9 @@
     measurement_type         VARCHAR(64)  NOT NULL,
     riverside                VARCHAR(16),
     reference_gauge_id       NUMBER(38),
+    -- store name and km of reference gauges here too, as not all are in gauges
+    reference_gauge_name     VARCHAR(64),
+    reference_gauge_station  NUMBER(38,3),
     observation_timerange_id NUMBER(38),
     operator                 VARCHAR(64),
     description              VARCHAR(512),
diff -r 5287440b57b3 -r 303701ab73c6 flys-backend/doc/schema/postgresql-minfo.sql
--- a/flys-backend/doc/schema/postgresql-minfo.sql	Wed Mar 27 11:48:53 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-minfo.sql	Wed Mar 27 12:13:21 2013 +0100
@@ -287,6 +287,9 @@
     measurement_type         VARCHAR(64)  NOT NULL,
     riverside                VARCHAR(16),
     reference_gauge_id       int,
+    -- store name and km of reference gauges here too, as not all are in gauges
+    reference_gauge_name     VARCHAR(64),
+    reference_gauge_station  NUMERIC,
     observation_timerange_id int,
     operator                 VARCHAR(64),
     description              VARCHAR(512),