Mercurial > dive4elements > river
comparison flys-aft/src/main/resources/sql/flys-common.properties @ 5540:25c2505df28f
Merged
| author | Christian Lins <christian.lins@intevation.de> |
|---|---|
| date | Wed, 03 Apr 2013 16:00:21 +0200 |
| parents | 11fba4dabe05 |
| children |
comparison
equal
deleted
inserted
replaced
| 5539:8d0af912351c | 5540:25c2505df28f |
|---|---|
| 50 select.gauge.master.discharge.table = \ | 50 select.gauge.master.discharge.table = \ |
| 51 SELECT \ | 51 SELECT \ |
| 52 dt.id AS id, \ | 52 dt.id AS id, \ |
| 53 dt.bfg_id AS bfg_id \ | 53 dt.bfg_id AS bfg_id \ |
| 54 FROM discharge_tables dt JOIN gauges g ON dt.gauge_id = g.id \ | 54 FROM discharge_tables dt JOIN gauges g ON dt.gauge_id = g.id \ |
| 55 WHERE g.id = :gauge_id AND g.kind = 0 | 55 WHERE g.id = :gauge_id AND dt.kind = 0 |
| 56 update.bfg.id.discharge.table = \ | 56 update.bfg.id.discharge.table = \ |
| 57 UPDATE discharge_tables SET bfg_id = :bfg_id WHERE id = :id | 57 UPDATE discharge_tables SET bfg_id = :bfg_id WHERE id = :id |