Mercurial > dive4elements > river
changeset 5513:ef3517905e6e
Add not null and default for hydr_boundary classifiers
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 28 Mar 2013 15:31:34 +0100 |
| parents | b91ffd97edc8 |
| children | 4c4fed23693f |
| files | flys-backend/doc/schema/oracle-spatial.sql flys-backend/doc/schema/postgresql-spatial.sql |
| diffstat | 2 files changed, 12 insertions(+), 12 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Thu Mar 28 15:29:09 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Thu Mar 28 15:31:34 2013 +0100 @@ -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), - sectie NUMBER(38) REFERENCES sectie_kinds(id), - sobek NUMBER(38) REFERENCES sobek_kinds(id), + 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, 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), - sectie NUMBER(38) REFERENCES sectie_kinds(id), - sobek NUMBER(38) REFERENCES sobek_kinds(id), + 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, path VARCHAR(256), id NUMBER PRIMARY KEY NOT NULL );
--- a/flys-backend/doc/schema/postgresql-spatial.sql Thu Mar 28 15:29:09 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Thu Mar 28 15:31:34 2013 +0100 @@ -277,9 +277,9 @@ id int PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind int REFERENCES boundary_kinds(id), - sectie int REFERENCES sectie_kinds(id), - sobek int REFERENCES sobek_kinds(id), + kind int REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0, + sectie int REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0, + sobek int REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0, path VARCHAR(256) ); SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'MULTILINESTRING',3); @@ -291,9 +291,9 @@ id int PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind int REFERENCES boundary_kinds(id), - sectie int REFERENCES sectie_kinds(id), - sobek int REFERENCES sobek_kinds(id), + kind int REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0, + sectie int REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0, + sobek int REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0, path VARCHAR(256) ); SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3);