changeset 5513:ef3517905e6e

Add not null and default for hydr_boundary classifiers
author Andre Heinecke <aheinecke@intevation.de>
date Thu, 28 Mar 2013 15:31:34 +0100
parents b91ffd97edc8
children 4c4fed23693f
files flys-backend/doc/schema/oracle-spatial.sql flys-backend/doc/schema/postgresql-spatial.sql
diffstat 2 files changed, 12 insertions(+), 12 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql	Thu Mar 28 15:29:09 2013 +0100
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Thu Mar 28 15:31:34 2013 +0100
@@ -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),
-    sectie NUMBER(38) REFERENCES sectie_kinds(id),
-    sobek  NUMBER(38) REFERENCES sobek_kinds(id),
+    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,
     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),
-    sectie NUMBER(38) REFERENCES sectie_kinds(id),
-    sobek  NUMBER(38) REFERENCES sobek_kinds(id),
+    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,
     path     VARCHAR(256),
     id NUMBER PRIMARY KEY NOT NULL
 );
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 28 15:29:09 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 28 15:31:34 2013 +0100
@@ -277,9 +277,9 @@
     id         int PRIMARY KEY NOT NULL,
     river_id   int REFERENCES rivers(id) ON DELETE CASCADE,
     name       VARCHAR(255),
-    kind       int REFERENCES boundary_kinds(id),
-    sectie     int REFERENCES sectie_kinds(id),
-    sobek      int REFERENCES sobek_kinds(id),
+    kind       int REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0,
+    sectie     int REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0,
+    sobek      int REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0,
     path       VARCHAR(256)
 );
 SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'MULTILINESTRING',3);
@@ -291,9 +291,9 @@
     id         int PRIMARY KEY NOT NULL,
     river_id   int REFERENCES rivers(id) ON DELETE CASCADE,
     name       VARCHAR(255),
-    kind       int REFERENCES boundary_kinds(id),
-    sectie     int REFERENCES sectie_kinds(id),
-    sobek      int REFERENCES sobek_kinds(id),
+    kind       int REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0,
+    sectie     int REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0,
+    sobek      int REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0,
     path       VARCHAR(256)
 );
 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3);

http://dive4elements.wald.intevation.org