# HG changeset patch
# User Tom Gottfried <tom.gottfried@intevation.de>
# Date 1364385357 -3600
# Node ID e47c4e9b050edc8a6e02513d4e2e5c1e2bf5f97b
# Parent  45c5b8b08ffd7a9311b436279a4214080c384ad2
Schema corrected: measurement_station.reference_gauge_station is not needed

diff -r 45c5b8b08ffd -r e47c4e9b050e flys-backend/doc/schema/oracle-minfo.sql
--- a/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 12:45:52 2013 +0100
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 12:55:57 2013 +0100
@@ -287,9 +287,8 @@
     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
+    -- store name 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 45c5b8b08ffd -r e47c4e9b050e flys-backend/doc/schema/postgresql-minfo.sql
--- a/flys-backend/doc/schema/postgresql-minfo.sql	Wed Mar 27 12:45:52 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-minfo.sql	Wed Mar 27 12:55:57 2013 +0100
@@ -287,9 +287,8 @@
     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
+    -- store name 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),