# HG changeset patch # User Andre Heinecke # Date 1361353380 -3600 # Node ID 2837b11cdb13077479fcca8eee7631c6211866cf # Parent d6860fca89e4787b7c20e81191626431f43142c8 SCHEMA Change: Make hws_lines a 3d geom diff -r d6860fca89e4 -r 2837b11cdb13 flys-backend/doc/schema/postgresql-migrate-dami.sql --- a/flys-backend/doc/schema/postgresql-migrate-dami.sql Wed Feb 20 10:40:07 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-migrate-dami.sql Wed Feb 20 10:43:00 2013 +0100 @@ -74,7 +74,7 @@ status_date TIMESTAMP, description VARCHAR(256) ); -SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 2); +SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 3); -- TODO: dike_km_from dike_km_to, are they geometries? ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ'); diff -r d6860fca89e4 -r 2837b11cdb13 flys-backend/doc/schema/postgresql-spatial.sql --- a/flys-backend/doc/schema/postgresql-spatial.sql Wed Feb 20 10:40:07 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Wed Feb 20 10:43:00 2013 +0100 @@ -152,7 +152,7 @@ status_date TIMESTAMP, description VARCHAR(256) ); -SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 2); +SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 3); -- TODO: dike_km_from dike_km_to, are they geometries? ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ');