Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 5783:153456f84602
add missing constraints to Oracle Schema (issue426) and some cosmetics
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 22 Apr 2013 13:00:13 +0200 |
parents | b5553164fabf |
children |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Mon Apr 22 12:11:55 2013 +0200 +++ b/flys-backend/doc/schema/oracle-spatial.sql Mon Apr 22 13:00:13 2013 +0200 @@ -34,7 +34,7 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, - km NUMBER(7,3), + km NUMBER(7,3) NOT NULL, name VARCHAR(64), path VARCHAR(256), ID NUMBER PRIMARY KEY NOT NULL @@ -313,7 +313,7 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, - name VARCHAR(255), + name VARCHAR(255) NOT NULL, kind NUMBER NOT NULL REFERENCES floodmap_kinds(id), diff NUMBER(19,5), count NUMBER(38),