# HG changeset patch
# User Sascha L. Teichmann <teichmann@intevation.de>
# Date 1368432322 -7200
# Node ID 3bb6c2a3ef72dd7e00e1cf5eaf9bad5b3bfe93a2
# Parent  af13ceeba52afcff94b1503dbf8bafcabc6e8186
River ETL: Limit the discharge tables to load to the historical (kind = 1) ones. This prevents the wrong tables (values) to be deleted.

diff -r af13ceeba52a -r 3bb6c2a3ef72 etl/src/main/resources/sql/flys-common.properties
--- a/etl/src/main/resources/sql/flys-common.properties	Sun May 12 18:13:50 2013 +0200
+++ b/etl/src/main/resources/sql/flys-common.properties	Mon May 13 10:05:22 2013 +0200
@@ -46,7 +46,7 @@
         dt.bfg_id      AS bfg_id \
     FROM discharge_tables dt \
     LEFT OUTER JOIN time_intervals ti ON dt.time_interval_id = ti.id \
-    WHERE gauge_id = :gauge_id
+    WHERE dt.gauge_id = :gauge_id AND dt.kind = 1
 select.gauge.master.discharge.table = \
     SELECT \
         dt.id AS id, \