Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5024:808718c6de97 dami
SCHEMA Remove geom_target and geom_rated_level from hws_lines table
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Tue, 19 Feb 2013 14:57:13 +0100 |
| parents | eecd1ebba128 |
| children | a5f438895a38 |
comparison
equal
deleted
inserted
replaced
| 5014:97dfb065a300 | 5024:808718c6de97 |
|---|---|
| 163 source VARCHAR(256), | 163 source VARCHAR(256), |
| 164 status_date TIMESTAMP, | 164 status_date TIMESTAMP, |
| 165 description VARCHAR(256) | 165 description VARCHAR(256) |
| 166 ); | 166 ); |
| 167 SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 2); | 167 SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 2); |
| 168 SELECT AddGeometryColumn('hws_lines', 'geom_target', 31467, 'LINESTRING', 2); -- ? | |
| 169 SELECT AddGeometryColumn('hws_lines', 'geom_rated_level', 31467, 'LINESTRING', 2); -- ? | |
| 170 -- TODO: dike_km_from dike_km_to, are they geometries? | 168 -- TODO: dike_km_from dike_km_to, are they geometries? |
| 171 | 169 |
| 172 ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ'); | 170 ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ'); |
| 173 | 171 |
| 174 --Hydrologie/HW-Schutzanlagen/*Punkte.shp | 172 --Hydrologie/HW-Schutzanlagen/*Punkte.shp |