Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-migrate-dami.sql @ 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 | bdef4c74d675 |
| children | df090e461c30 |
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');