Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5408:91f5908c472a
Add building_kinds to drop script and fix syntax of buildings table
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Mon, 25 Mar 2013 17:01:07 +0100 |
| parents | e65fee5ea98a |
| children | 8b29a94ebdd8 |
comparison
equal
deleted
inserted
replaced
| 5407:db5def5456ce | 5408:91f5908c472a |
|---|---|
| 90 CREATE SEQUENCE BUILDINGS_ID_SEQ; | 90 CREATE SEQUENCE BUILDINGS_ID_SEQ; |
| 91 CREATE TABLE buildings( | 91 CREATE TABLE buildings( |
| 92 OGR_FID NUMBER(38), | 92 OGR_FID NUMBER(38), |
| 93 GEOM MDSYS.SDO_GEOMETRY, | 93 GEOM MDSYS.SDO_GEOMETRY, |
| 94 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 94 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 95 kind_id NUMBER(38) REFERENCES building_kinds(id) NOT NULL DEFAULT 0, | 95 kind_id NUMBER(38) DEFAULT 0 NOT NULL REFERENCES building_kinds(id), |
| 96 km NUMBER(38,11) NOT NULL, | 96 km NUMBER(38,11), |
| 97 name VARCHAR2(255), -- The layername | 97 name VARCHAR2(255), -- The layername |
| 98 description VARCHAR(256), -- Name taken from attributes | 98 description VARCHAR(256), -- Name taken from attributes |
| 99 path VARCHAR(256), | 99 path VARCHAR(256), |
| 100 ID NUMBER PRIMARY KEY NOT NULL | 100 ID NUMBER PRIMARY KEY NOT NULL |
| 101 ); | 101 ); |