Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 2365:60532f75396b
Adapted 'lines' relation and made lines queryable for a given river.
flys-backend/trunk@3219 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 10 Nov 2011 13:35:31 +0000 |
| parents | c4f090a00178 |
| children | a3c02addd1fa |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Wed Nov 09 16:25:20 2011 +0000 +++ b/flys-backend/doc/schema/oracle-spatial.sql Thu Nov 10 13:35:31 2011 +0000 @@ -60,7 +60,7 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38), - kind NUMBER(38) DEFAULT 0 NOT NULL, + kind VARCHAR2(16) NOT NULL, z NUMBER(38,12) DEFAULT 0, ID NUMBER PRIMARY KEY NOT NULL );