Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 2844:c4db0f75a94a
Prepared the importer to import MINFO specific waterlevel values and added a stub for a parser.
flys-backend/trunk@4287 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 24 Apr 2012 11:16:06 +0000 |
| parents | 6be2bf2492f9 |
| children | c1c6c9190636 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Fri Apr 20 08:16:39 2012 +0000 +++ b/flys-backend/doc/schema/oracle-minfo.sql Tue Apr 24 11:16:06 2012 +0000 @@ -309,8 +309,8 @@ CREATE TABLE waterlevel_values( id NUMBER(38,0) NOT NULL, waterlevel_q_range_id NUMBER(38,0) NOT NULL, - station NUMBER(38,0) NOT NULL, - w NUMBER(38,0) NOT NULL, + station NUMBER(38,3) NOT NULL, + w NUMBER(38,2) NOT NULL, PRIMARY KEY (id), CONSTRAINT fk_wv_waterlevel_q_range_id FOREIGN KEY (waterlevel_q_range_id) REFERENCES waterlevel_q_range(id) );