Mercurial > dive4elements > river
changeset 2335:e1fb4a1e0b4a
Generalized oracle spatial schema.
flys-backend/trunk@2794 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Schilberg <bjoern@intevation.de> |
|---|---|
| date | Tue, 20 Sep 2011 13:21:29 +0000 |
| parents | 8a3dbb705ebf |
| children | 60c722dc0304 |
| files | flys-backend/ChangeLog flys-backend/doc/schema/oracle-spatial.sql |
| diffstat | 2 files changed, 13 insertions(+), 9 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Mon Sep 19 14:33:40 2011 +0000 +++ b/flys-backend/ChangeLog Tue Sep 20 13:21:29 2011 +0000 @@ -1,3 +1,7 @@ +2011-09-20 Bjoern Schilberg <bjoern@intevation.de> + + * doc/schema/oracle-spatial.sql: Generalized oracle spatial schema. + 2011-09-19 Ingo Weinzierl <ingo@intevation.de> Tagged RELEASE 2.5
--- a/flys-backend/doc/schema/oracle-spatial.sql Mon Sep 19 14:33:40 2011 +0000 +++ b/flys-backend/doc/schema/oracle-spatial.sql Tue Sep 20 13:21:29 2011 +0000 @@ -6,7 +6,7 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38), area NUMBER(19,5), - name VARCHAR2(80), + name VARCHAR2(255), ID NUMBER PRIMARY KEY NOT NULL ); --EXTENT 2520667.897954 5376316.575645 2634771.191263 5508288.005707 @@ -45,7 +45,7 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38), - name VARCHAR2(50), + name VARCHAR2(255), ID NUMBER PRIMARY KEY NOT NULL ); --Extent: (2540544.253718, 5456266.217464) - (2567747.834199, 5502557.982120) @@ -64,10 +64,10 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38), - x NUMBER(19,11), - y NUMBER(19,11), - km NUMBER(10) NOT NULL, - HPGP VARCHAR2(254), + x NUMBER(38,11), + y NUMBER(38,11), + km NUMBER(38,11) NOT NULL, + HPGP VARCHAR2(255), ID NUMBER PRIMARY KEY NOT NULL ); --Extent: (2539388.036000, 5450896.688000) - (2575586.296000, 5507370.606000) @@ -105,7 +105,7 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38), - km NUMBER(14,12) NOT NULL, + km NUMBER(38,12) NOT NULL, z NUMBER(18,5) DEFAULT 0 NOT NULL, ID NUMBER PRIMARY KEY NOT NULL ); @@ -125,8 +125,8 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38), - hws_facility VARCHAR2(40), - type VARCHAR2(254), + hws_facility VARCHAR2(255), + type VARCHAR2(255), ID NUMBER PRIMARY KEY NOT NULL ); --Extent: (2539778.101933, 5456638.161347) - (2567463.841704, 5500605.745332)