# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1362744400 -3600
# Node ID 31fd42400c8407ebb540b4597d00506a0f72ef2e
# Parent  20f9b633900efd6136b7fa6e69f9ad14dca19d31
Oracle Schema: add missing constraint and allow 7-digit kms

diff -r 20f9b633900e -r 31fd42400c84 flys-backend/doc/schema/oracle-spatial.sql
--- a/flys-backend/doc/schema/oracle-spatial.sql	Fri Mar 08 12:51:34 2013 +0100
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Fri Mar 08 13:06:40 2013 +0100
@@ -14,7 +14,7 @@
     OGR_FID NUMBER(38),
     GEOM MDSYS.SDO_GEOMETRY,
     river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
-    kind_id  NUMBER(38) REFERENCES axis_kinds(id) NOT NULL,
+    kind_id  NUMBER(38) REFERENCES axis_kinds(id) NOT NULL DEFAULT 0,
     name     VARCHAR(64),
     path     VARCHAR(256),
     ID NUMBER PRIMARY KEY NOT NULL
@@ -34,7 +34,7 @@
     OGR_FID NUMBER(38),
     GEOM MDSYS.SDO_GEOMETRY,
     river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
-    km NUMBER(6,3),
+    km NUMBER(7,3),
     name     VARCHAR(64),
     path     VARCHAR(256),
     ID NUMBER PRIMARY KEY NOT NULL