Mercurial > dive4elements > river
changeset 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 | db5def5456ce |
children | 8b29a94ebdd8 |
files | flys-backend/doc/schema/oracle-drop-spatial.sql flys-backend/doc/schema/oracle-spatial.sql flys-backend/doc/schema/postgresql-drop-spatial.sql |
diffstat | 3 files changed, 4 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-spatial.sql Mon Mar 25 17:00:37 2013 +0100 +++ b/flys-backend/doc/schema/oracle-drop-spatial.sql Mon Mar 25 17:01:07 2013 +0100 @@ -75,3 +75,4 @@ DROP TABLE boundary_kinds; DROP TABLE cross_section_track_kinds; DROP TABLE floodplain_kinds; +DROP TABLE building_kinds;
--- a/flys-backend/doc/schema/oracle-spatial.sql Mon Mar 25 17:00:37 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Mon Mar 25 17:01:07 2013 +0100 @@ -92,8 +92,8 @@ OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, - kind_id NUMBER(38) REFERENCES building_kinds(id) NOT NULL DEFAULT 0, - km NUMBER(38,11) NOT NULL, + kind_id NUMBER(38) DEFAULT 0 NOT NULL REFERENCES building_kinds(id), + km NUMBER(38,11), name VARCHAR2(255), -- The layername description VARCHAR(256), -- Name taken from attributes path VARCHAR(256),
--- a/flys-backend/doc/schema/postgresql-drop-spatial.sql Mon Mar 25 17:00:37 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-drop-spatial.sql Mon Mar 25 17:01:07 2013 +0100 @@ -45,5 +45,6 @@ DROP TABLE sectie_kinds; DROP TABLE boundary_kinds; DROP TABLE axis_kinds; +DROP TABLE building_kinds; COMMIT;