# HG changeset patch # User Andre Heinecke # Date 1361282233 -3600 # Node ID 808718c6de976c24054fc9f1e00bf746a34f7c6a # Parent 97dfb065a3001f5b2a5bdbac89ed576307233723 SCHEMA Remove geom_target and geom_rated_level from hws_lines table diff -r 97dfb065a300 -r 808718c6de97 flys-backend/doc/schema/postgresql-spatial.sql --- a/flys-backend/doc/schema/postgresql-spatial.sql Tue Feb 19 10:00:50 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Tue Feb 19 14:57:13 2013 +0100 @@ -165,8 +165,6 @@ description VARCHAR(256) ); SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 2); -SELECT AddGeometryColumn('hws_lines', 'geom_target', 31467, 'LINESTRING', 2); -- ? -SELECT AddGeometryColumn('hws_lines', 'geom_rated_level', 31467, 'LINESTRING', 2); -- ? -- TODO: dike_km_from dike_km_to, are they geometries? ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ');