Mercurial > dive4elements > river
changeset 5127:3d8000616ed5 dami
Fix oracle-spatial creation script and posgresql drop script
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Thu, 28 Feb 2013 11:14:38 +0100 |
parents | 5ba502e78e05 |
children | a020100ee6a1 538d6c28cd8a |
files | flys-backend/doc/schema/oracle-spatial.sql flys-backend/doc/schema/postgresql-drop-spatial.sql |
diffstat | 2 files changed, 0 insertions(+), 7 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Thu Feb 28 10:09:31 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Thu Feb 28 11:14:38 2013 +0100 @@ -237,7 +237,6 @@ CREATE TABLE hws_points ( OGR_FID NUMBER(38), GEOM MDSYS.SDO_GEOMETRY, - ogr_fid NUMBER, kind_id NUMBER DEFAULT 2 REFERENCES hws_kinds(id), fed_state_id NUMBER REFERENCES fed_states(id), river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
--- a/flys-backend/doc/schema/postgresql-drop-spatial.sql Thu Feb 28 10:09:31 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-drop-spatial.sql Thu Feb 28 11:14:38 2013 +0100 @@ -9,9 +9,6 @@ DROP TABLE cross_section_tracks; DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; -DROP TABLE lines; -DROP SEQUENCE LINES_ID_SEQ; - DROP TABLE buildings; DROP SEQUENCE BUILDINGS_ID_SEQ; @@ -24,9 +21,6 @@ DROP TABLE dem; DROP SEQUENCE DEM_ID_SEQ; -DROP TABLE catchment; -DROP SEQUENCE CATCHMENT_ID_SEQ; - DROP TABLE hws_points; DROP SEQUENCE HWS_POINTS_ID_SEQ;