Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5137:04eb62eae722
River Axes and HWS_lines are now multiline
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 28 Feb 2013 12:58:25 +0100 |
| parents | e4cc9aebfcf1 |
| children | d4fdd98a04f7 |
comparison
equal
deleted
inserted
replaced
| 5136:ec3430d12d2e | 5137:04eb62eae722 |
|---|---|
| 7 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 7 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 8 kind int NOT NULL DEFAULT 0, | 8 kind int NOT NULL DEFAULT 0, |
| 9 name VARCHAR(64), | 9 name VARCHAR(64), |
| 10 path VARCHAR(256) | 10 path VARCHAR(256) |
| 11 ); | 11 ); |
| 12 SELECT AddGeometryColumn('river_axes', 'geom', 31467, 'LINESTRING', 2); | 12 SELECT AddGeometryColumn('river_axes', 'geom', 31467, 'MULTILINESTRING', 2); |
| 13 ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ'); | 13 ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ'); |
| 14 | 14 |
| 15 | 15 |
| 16 -- TODO: TestMe. | 16 -- TODO: TestMe. |
| 17 -- Geodaesie/Flussachse+km/km.shp | 17 -- Geodaesie/Flussachse+km/km.shp |
| 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', 3); | 155 SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'MULTILINESTRING', 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 |