Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-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 | 94c3eb995bf6 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Fri Mar 01 12:40:15 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Fri Mar 01 13:28:45 2013 +0100 @@ -150,7 +150,7 @@ border_break NUMBER(1) DEFAULT 0 NOT NULL, resolution VARCHAR(16), description VARCHAR(256), - path VARCHAR(256) NOT NULL + path VARCHAR(256) NOT NULL UNIQUE ); CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW BEGIN