changeset 5315:aa407dfb9949

removed unique constraint to allow one dem to be used by several rivers
author Tom Gottfried <tom@intevation.de>
date Thu, 14 Mar 2013 18:04:36 +0100
parents ac2746f3e75f
children c45d40b1d79c
files flys-backend/doc/schema/oracle-spatial.sql flys-backend/doc/schema/postgresql-spatial.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql	Thu Mar 14 17:42:51 2013 +0100
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Thu Mar 14 18:04:36 2013 +0100
@@ -161,7 +161,7 @@
     border_break     NUMBER(1) DEFAULT 0 NOT NULL,
     resolution       VARCHAR(16),
     description      VARCHAR(256),
-    path             VARCHAR(256) NOT NULL UNIQUE
+    path             VARCHAR(256) NOT NULL
 );
 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW
     BEGIN
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 14 17:42:51 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 14 18:04:36 2013 +0100
@@ -121,7 +121,7 @@
     border_break     BOOLEAN NOT NULL DEFAULT FALSE,
     resolution       VARCHAR(16),
     description      VARCHAR(256),
-    path             VARCHAR(256) NOT NULL UNIQUE
+    path             VARCHAR(256) NOT NULL
 );
 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ');
 

http://dive4elements.wald.intevation.org