Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle.sql @ 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 | 83a42e6a562d |
| children | 5c07ec3e9e25 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle.sql Sat Jan 05 14:52:55 2013 +0100 +++ b/flys-backend/doc/schema/oracle.sql Sat Jan 05 15:05:51 2013 +0100 @@ -91,6 +91,7 @@ CREATE TABLE discharge_tables ( id NUMBER(38,0) NOT NULL, description VARCHAR2(255), + bfg_id VARCHAR2(50), kind NUMBER(38,0), gauge_id NUMBER(38,0), time_interval_id NUMBER(38,0),