Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 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 | 66d9389c80cb |
| children | 555a99dff849 |
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