Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-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 | 08b3109c637b |
| children | 7b35f2c070c3 |
line wrap: on
line diff
--- 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');