Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.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 | a5f438895a38 |
| children | e4cc9aebfcf1 |
comparison
equal
deleted
inserted
replaced
| 5036:d6860fca89e4 | 5037:2837b11cdb13 |
|---|---|
| 150 shore_side INT DEFAULT 0, | 150 shore_side INT DEFAULT 0, |
| 151 source VARCHAR(256), | 151 source VARCHAR(256), |
| 152 status_date TIMESTAMP, | 152 status_date TIMESTAMP, |
| 153 description VARCHAR(256) | 153 description VARCHAR(256) |
| 154 ); | 154 ); |
| 155 SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 2); | 155 SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 3); |
| 156 -- TODO: dike_km_from dike_km_to, are they geometries? | 156 -- TODO: dike_km_from dike_km_to, are they geometries? |
| 157 | 157 |
| 158 ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ'); | 158 ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ'); |
| 159 | 159 |
| 160 --Hydrologie/HW-Schutzanlagen/*Punkte.shp | 160 --Hydrologie/HW-Schutzanlagen/*Punkte.shp |