Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 2803:cdc084071c14
Adapted the column type of relation 'dem' in oracle-spatial schema.
flys-backend/trunk@4160 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 19 Mar 2012 06:11:38 +0000 |
| parents | efb10ed2af96 |
| children | 875a87b8489f |
comparison
equal
deleted
inserted
replaced
| 2802:3fdac7b43dac | 2803:cdc084071c14 |
|---|---|
| 140 CREATE SEQUENCE DEM_ID_SEQ; | 140 CREATE SEQUENCE DEM_ID_SEQ; |
| 141 CREATE TABLE dem ( | 141 CREATE TABLE dem ( |
| 142 ID NUMBER PRIMARY KEY NOT NULL, | 142 ID NUMBER PRIMARY KEY NOT NULL, |
| 143 river_id NUMBER(38), | 143 river_id NUMBER(38), |
| 144 -- XXX Should we use the ranges table instead? | 144 -- XXX Should we use the ranges table instead? |
| 145 lower NUMBER(38), | 145 lower NUMBER(19,5), |
| 146 upper NUMBER(38), | 146 upper NUMBER(19,5), |
| 147 path VARCHAR(256), | 147 path VARCHAR(256), |
| 148 UNIQUE (river_id, lower, upper) | 148 UNIQUE (river_id, lower, upper) |
| 149 ); | 149 ); |
| 150 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW | 150 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW |
| 151 BEGIN | 151 BEGIN |