Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 3793:8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
flys-backend/trunk@5433 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 11 Sep 2012 13:55:08 +0000 |
| parents | cc8fc6b29649 |
| children | fc32a4955087 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Mon Sep 10 13:00:59 2012 +0000 +++ b/flys-backend/doc/schema/oracle-minfo.sql Tue Sep 11 13:55:08 2012 +0000 @@ -245,7 +245,7 @@ name VARCHAR(64) NOT NULL, lower NUMBER(38,3), upper NUMBER(38,3), - unit_id NUMBER (38,0), + unit_id NUMBER(38,0), PRIMARY KEY (id), CONSTRAINT fk_gf_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) ); @@ -306,7 +306,7 @@ CREATE SEQUENCE WATERLEVEL_VALUES_ID_SEQ; -CREATE TABLE waterlevel_values( +CREATE TABLE waterlevel_values ( id NUMBER(38,0) NOT NULL, waterlevel_q_range_id NUMBER(38,0) NOT NULL, station NUMBER(38,3) NOT NULL, @@ -374,7 +374,7 @@ fraction VARCHAR(32) NOT NULL, function VARCHAR(32) NOT NULL, km NUMBER(38,3) NOT NULL, - a NUMBER NOT NULL, + a NUMBER(38, 3) NOT NULL, b NUMBER(38,3) NOT NULL, PRIMARY KEY (id), CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id)