Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5127:3d8000616ed5 dami
Fix oracle-spatial creation script and posgresql drop script
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 28 Feb 2013 11:14:38 +0100 |
| parents | 5ba502e78e05 |
| children | d4fdd98a04f7 |
comparison
equal
deleted
inserted
replaced
| 5122:5ba502e78e05 | 5127:3d8000616ed5 |
|---|---|
| 235 -- HWS Points | 235 -- HWS Points |
| 236 CREATE SEQUENCE HWS_POINTS_ID_SEQ; | 236 CREATE SEQUENCE HWS_POINTS_ID_SEQ; |
| 237 CREATE TABLE hws_points ( | 237 CREATE TABLE hws_points ( |
| 238 OGR_FID NUMBER(38), | 238 OGR_FID NUMBER(38), |
| 239 GEOM MDSYS.SDO_GEOMETRY, | 239 GEOM MDSYS.SDO_GEOMETRY, |
| 240 ogr_fid NUMBER, | |
| 241 kind_id NUMBER DEFAULT 2 REFERENCES hws_kinds(id), | 240 kind_id NUMBER DEFAULT 2 REFERENCES hws_kinds(id), |
| 242 fed_state_id NUMBER REFERENCES fed_states(id), | 241 fed_state_id NUMBER REFERENCES fed_states(id), |
| 243 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 242 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 244 name VARCHAR(256), | 243 name VARCHAR(256), |
| 245 path VARCHAR(256), | 244 path VARCHAR(256), |