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; |