Mercurial > dive4elements > river
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');