Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/etl/src/main/resources/sql/flys-common.properties Wed May 08 17:02:51 2013 +0200 +++ b/etl/src/main/resources/sql/flys-common.properties Wed May 08 17:04:49 2013 +0200 @@ -55,3 +55,7 @@ WHERE g.id = :gauge_id AND dt.kind = 0 update.bfg.id.discharge.table = \ UPDATE discharge_tables SET bfg_id = :bfg_id WHERE id = :id +delete.discharge.table.values = \ + DELETE from discharge_table_values where table_id = :id +delete.discharge.table = \ + DELETE from discharge_tables where id = :id and kind = 1