diff flys-backend/doc/schema/oracle-spatial.sql @ 5535:16afd4613f9d

Fix syntax errors in oracle scheme
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 03 Apr 2013 15:31:31 +0200
parents 4c4fed23693f
children 5f91881124ba
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql	Wed Apr 03 15:31:04 2013 +0200
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Wed Apr 03 15:31:31 2013 +0200
@@ -337,9 +337,9 @@
     GEOM MDSYS.SDO_GEOMETRY,
     river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
     name VARCHAR(255),
-    kind   NUMBER(38) REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0,
-    sectie NUMBER(38) REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0,
-    sobek  NUMBER(38) REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0,
+    kind   NUMBER(38) DEFAULT 0 NOT NULL REFERENCES boundary_kinds(id),
+    sectie NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sectie_kinds(id),
+    sobek  NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sobek_kinds(id),
     path     VARCHAR(256),
     id NUMBER PRIMARY KEY NOT NULL
 );
@@ -356,9 +356,9 @@
     GEOM MDSYS.SDO_GEOMETRY,
     river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
     name VARCHAR(255),
-    kind   NUMBER(38) REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0,
-    sectie NUMBER(38) REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0,
-    sobek  NUMBER(38) REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0,
+    kind   NUMBER(38) DEFAULT 0 NOT NULL REFERENCES boundary_kinds(id),
+    sectie NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sectie_kinds(id),
+    sobek  NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sobek_kinds(id),
     path     VARCHAR(256),
     id NUMBER PRIMARY KEY NOT NULL
 );

http://dive4elements.wald.intevation.org