Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-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 | 66d9389c80cb |
| children | 555a99dff849 |
comparison
equal
deleted
inserted
replaced
| 5314:ac2746f3e75f | 5315:aa407dfb9949 |
|---|---|
| 159 srid NUMBER NOT NULL, | 159 srid NUMBER NOT NULL, |
| 160 format VARCHAR(32), | 160 format VARCHAR(32), |
| 161 border_break NUMBER(1) DEFAULT 0 NOT NULL, | 161 border_break NUMBER(1) DEFAULT 0 NOT NULL, |
| 162 resolution VARCHAR(16), | 162 resolution VARCHAR(16), |
| 163 description VARCHAR(256), | 163 description VARCHAR(256), |
| 164 path VARCHAR(256) NOT NULL UNIQUE | 164 path VARCHAR(256) NOT NULL |
| 165 ); | 165 ); |
| 166 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW | 166 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW |
| 167 BEGIN | 167 BEGIN |
| 168 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual; | 168 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual; |
| 169 END; | 169 END; |