Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
5036:d6860fca89e4 | 5037:2837b11cdb13 |
---|---|
72 shore_side INT DEFAULT 0, | 72 shore_side INT DEFAULT 0, |
73 source VARCHAR(256), | 73 source VARCHAR(256), |
74 status_date TIMESTAMP, | 74 status_date TIMESTAMP, |
75 description VARCHAR(256) | 75 description VARCHAR(256) |
76 ); | 76 ); |
77 SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 2); | 77 SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 3); |
78 -- TODO: dike_km_from dike_km_to, are they geometries? | 78 -- TODO: dike_km_from dike_km_to, are they geometries? |
79 | 79 |
80 ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ'); | 80 ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ'); |
81 | 81 |
82 --Hydrologie/HW-Schutzanlagen/*Punkte.shp | 82 --Hydrologie/HW-Schutzanlagen/*Punkte.shp |