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 |