Mercurial > dive4elements > river
comparison etl/src/main/resources/sql/flys-common.properties @ 5930:33e514a0c6b7
Delete discharge tables which are in AFT but not in FLYS. Fixed Oracle specific pom.xml
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Wed, 08 May 2013 17:04:49 +0200 |
| parents | 5aa05a7a34b7 |
| children | 3bb6c2a3ef72 |
comparison
equal
deleted
inserted
replaced
| 5929:4d526e313fa0 | 5930:33e514a0c6b7 |
|---|---|
| 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 dt.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 |
| 58 delete.discharge.table.values = \ | |
| 59 DELETE from discharge_table_values where table_id = :id | |
| 60 delete.discharge.table = \ | |
| 61 DELETE from discharge_tables where id = :id and kind = 1 |