Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 5158:a9658d43b621
added missing constraints in schema (mostly for Oracle)
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 01 Mar 2013 13:28:45 +0100 |
| parents | d4fdd98a04f7 |
| children | 8aac391871f9 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Fri Mar 01 12:40:15 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Fri Mar 01 13:28:45 2013 +0100 @@ -107,7 +107,7 @@ border_break BOOLEAN NOT NULL DEFAULT FALSE, resolution VARCHAR(16), description VARCHAR(256), - path VARCHAR(256) NOT NULL + path VARCHAR(256) NOT NULL UNIQUE ); ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ');