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)

http://dive4elements.wald.intevation.org