Mercurial > dive4elements > river
view flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4776:20b6ebf23916
!!! FLYS backend schema change !!! Add column bfg_id column to discharge_tables.
Alter existing databases with
alter table discharge_tables add column bfg_id varchar(50);
This column is now used to synchronize FLYS with the AFT database.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Sat, 05 Jan 2013 15:05:51 +0100 |
| parents | d9f1202cef78 |
| children | 7a68967ca72a |
line wrap: on
line source
select.abflusstafel = \ SELECT ABFLUSSTAFEL_NR, \ ABFLUSSTAFEL_BEZ, \ GUELTIG_VON, \ GUELTIG_BIS, \ PEGELNULLPUNKT, \ BFG_ID \ FROM ABFLUSSTAFEL \ WHERE MESSSTELLE_NR LIKE :number