# HG changeset patch
# User Bjoern Schilberg <bjoern@intevation.de>
# Date 1316524889 0
# Node ID e1fb4a1e0b4ab940f7de0aef3b70ec6163222b31
# Parent  8a3dbb705ebf427f16306392ea2cb7fc4d01c54f
Generalized oracle spatial schema.


flys-backend/trunk@2794 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 8a3dbb705ebf -r e1fb4a1e0b4a flys-backend/ChangeLog
--- 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
diff -r 8a3dbb705ebf -r e1fb4a1e0b4a flys-backend/doc/schema/oracle-spatial.sql
--- 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)