Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 5535:16afd4613f9d
Fix syntax errors in oracle scheme
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Wed, 03 Apr 2013 15:31:31 +0200 |
| parents | 4c4fed23693f |
| children | 5f91881124ba |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Wed Apr 03 15:31:04 2013 +0200 +++ b/flys-backend/doc/schema/oracle-spatial.sql Wed Apr 03 15:31:31 2013 +0200 @@ -337,9 +337,9 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind NUMBER(38) REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0, - sectie NUMBER(38) REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0, - sobek NUMBER(38) REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0, + kind NUMBER(38) DEFAULT 0 NOT NULL REFERENCES boundary_kinds(id), + sectie NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sectie_kinds(id), + sobek NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sobek_kinds(id), path VARCHAR(256), id NUMBER PRIMARY KEY NOT NULL ); @@ -356,9 +356,9 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind NUMBER(38) REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0, - sectie NUMBER(38) REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0, - sobek NUMBER(38) REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0, + kind NUMBER(38) DEFAULT 0 NOT NULL REFERENCES boundary_kinds(id), + sectie NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sectie_kinds(id), + sobek NUMBER(38) DEFAULT 0 NOT NULL REFERENCES sobek_kinds(id), path VARCHAR(256), id NUMBER PRIMARY KEY NOT NULL );