Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 2803:cdc084071c14
Adapted the column type of relation 'dem' in oracle-spatial schema.
flys-backend/trunk@4160 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 19 Mar 2012 06:11:38 +0000 |
| parents | efb10ed2af96 |
| children | 875a87b8489f |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Mon Mar 19 06:09:31 2012 +0000 +++ b/flys-backend/doc/schema/oracle-spatial.sql Mon Mar 19 06:11:38 2012 +0000 @@ -142,8 +142,8 @@ ID NUMBER PRIMARY KEY NOT NULL, river_id NUMBER(38), -- XXX Should we use the ranges table instead? - lower NUMBER(38), - upper NUMBER(38), + lower NUMBER(19,5), + upper NUMBER(19,5), path VARCHAR(256), UNIQUE (river_id, lower, upper) );