Mercurial > dive4elements > river
changeset 5037:2837b11cdb13 dami
SCHEMA Change: Make hws_lines a 3d geom
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Wed, 20 Feb 2013 10:43:00 +0100 |
| parents | d6860fca89e4 |
| children | 57a845da72bd |
| files | flys-backend/doc/schema/postgresql-migrate-dami.sql flys-backend/doc/schema/postgresql-spatial.sql |
| diffstat | 2 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- 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');
--- 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');