Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5121:e4cc9aebfcf1 dami
sensible constraints for dem-table
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 27 Feb 2013 19:44:08 +0100 |
| parents | c4b28de753de |
| children | 5ba502e78e05 |
comparison
equal
deleted
inserted
replaced
| 5120:d49b3baa30d0 | 5121:e4cc9aebfcf1 |
|---|---|
| 139 srid NUMBER NOT NULL, | 139 srid NUMBER NOT NULL, |
| 140 format VARCHAR(32), | 140 format VARCHAR(32), |
| 141 border_break NUMBER(1) DEFAULT 0 NOT NULL, | 141 border_break NUMBER(1) DEFAULT 0 NOT NULL, |
| 142 resolution VARCHAR(16), | 142 resolution VARCHAR(16), |
| 143 description VARCHAR(256), | 143 description VARCHAR(256), |
| 144 path VARCHAR(256) | 144 path VARCHAR(256) NOT NULL |
| 145 ); | 145 ); |
| 146 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW | 146 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW |
| 147 BEGIN | 147 BEGIN |
| 148 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual; | 148 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual; |
| 149 END; | 149 END; |