Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 2823:13b3fcaa1b34
Add MINFO schema for PostgreSQL
flys-backend/trunk@4240 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 13 Apr 2012 16:15:23 +0000 |
| parents | 0c2567626754 |
| children | 85b2b5e7377f |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Fri Apr 13 13:27:09 2012 +0000 +++ b/flys-backend/doc/schema/oracle-minfo.sql Fri Apr 13 16:15:23 2012 +0000 @@ -110,7 +110,7 @@ id NUMBER(38,0) NOT NULL, lower NUMBER(38,2) NOT NULL, upper NUMBER(38,2) NOT NULL, - unit_id NUMBER(38,2) NOT NULL, + unit_id NUMBER(38,0) NOT NULL, PRIMARY KEY(id), CONSTRAINT fk_depths_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) );