Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 5205:31fd42400c84
Oracle Schema: add missing constraint and allow 7-digit kms
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 08 Mar 2013 13:06:40 +0100 |
| parents | 94c3eb995bf6 |
| children | 908848b74d7e |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Fri Mar 08 12:51:34 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Fri Mar 08 13:06:40 2013 +0100 @@ -14,7 +14,7 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, - kind_id NUMBER(38) REFERENCES axis_kinds(id) NOT NULL, + kind_id NUMBER(38) REFERENCES axis_kinds(id) NOT NULL DEFAULT 0, name VARCHAR(64), path VARCHAR(256), ID NUMBER PRIMARY KEY NOT NULL @@ -34,7 +34,7 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, - km NUMBER(6,3), + km NUMBER(7,3), name VARCHAR(64), path VARCHAR(256), ID NUMBER PRIMARY KEY NOT NULL