diff flys-backend/doc/schema/oracle-spatial.sql @ 5783:153456f84602

add missing constraints to Oracle Schema (issue426) and some cosmetics
author Tom Gottfried <tom@intevation.de>
date Mon, 22 Apr 2013 13:00:13 +0200
parents b5553164fabf
children
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql	Mon Apr 22 12:11:55 2013 +0200
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Mon Apr 22 13:00:13 2013 +0200
@@ -34,7 +34,7 @@
     OGR_FID NUMBER(38),
     GEOM MDSYS.SDO_GEOMETRY,
     river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
-    km NUMBER(7,3),
+    km NUMBER(7,3) NOT NULL,
     name     VARCHAR(64),
     path     VARCHAR(256),
     ID NUMBER PRIMARY KEY NOT NULL
@@ -313,7 +313,7 @@
     OGR_FID NUMBER(38),
     GEOM MDSYS.SDO_GEOMETRY,
     river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
-    name VARCHAR(255),
+    name VARCHAR(255) NOT NULL,
     kind NUMBER NOT NULL REFERENCES floodmap_kinds(id),
     diff NUMBER(19,5),
     count NUMBER(38),

http://dive4elements.wald.intevation.org