Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 4775:d9f1202cef78 | 4776:20b6ebf23916 |
|---|---|
| 89 CREATE SEQUENCE DISCHARGE_TABLES_ID_SEQ; | 89 CREATE SEQUENCE DISCHARGE_TABLES_ID_SEQ; |
| 90 | 90 |
| 91 CREATE TABLE discharge_tables ( | 91 CREATE TABLE discharge_tables ( |
| 92 id NUMBER(38,0) NOT NULL, | 92 id NUMBER(38,0) NOT NULL, |
| 93 description VARCHAR2(255), | 93 description VARCHAR2(255), |
| 94 bfg_id VARCHAR2(50), | |
| 94 kind NUMBER(38,0), | 95 kind NUMBER(38,0), |
| 95 gauge_id NUMBER(38,0), | 96 gauge_id NUMBER(38,0), |
| 96 time_interval_id NUMBER(38,0), | 97 time_interval_id NUMBER(38,0), |
| 97 PRIMARY KEY (id) | 98 PRIMARY KEY (id) |
| 98 ); | 99 ); |