Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
5155:6b19902baf31 | 5158:a9658d43b621 |
---|---|
148 srid NUMBER NOT NULL, | 148 srid NUMBER NOT NULL, |
149 format VARCHAR(32), | 149 format VARCHAR(32), |
150 border_break NUMBER(1) DEFAULT 0 NOT NULL, | 150 border_break NUMBER(1) DEFAULT 0 NOT NULL, |
151 resolution VARCHAR(16), | 151 resolution VARCHAR(16), |
152 description VARCHAR(256), | 152 description VARCHAR(256), |
153 path VARCHAR(256) NOT NULL | 153 path VARCHAR(256) NOT NULL UNIQUE |
154 ); | 154 ); |
155 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW | 155 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW |
156 BEGIN | 156 BEGIN |
157 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual; | 157 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual; |
158 END; | 158 END; |