diff flys-backend/doc/schema/postgresql-spatial.sql @ 5013:eecd1ebba128 dami

SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines')
author Tom Gottfried <tom.gottfried@intevation.de>
date Tue, 19 Feb 2013 09:57:57 +0100
parents ee52faa6b7ac
children 808718c6de97
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Tue Feb 19 09:44:38 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Tue Feb 19 09:57:57 2013 +0100
@@ -41,23 +41,6 @@
 ALTER TABLE cross_section_tracks ALTER COLUMN id SET DEFAULT NEXTVAL('CROSS_SECTION_TRACKS_ID_SEQ');
 
 
--- Geodaesie/Linien/rohre-und-spreen
-CREATE SEQUENCE LINES_ID_SEQ;
-CREATE TABLE lines (
-    id       int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id) ON DELETE CASCADE,
-    kind     VARCHAR(16) NOT NULL,
-    z        FLOAT8 DEFAULT 0,
-    name     VARCHAR(64),
-    path     VARCHAR(256)
-);
-SELECT AddGeometryColumn('lines', 'geom', 31467, 'LINESTRING', 3);
-ALTER TABLE lines ALTER COLUMN id SET DEFAULT NEXTVAL('LINES_ID_SEQ');
--- 'kind':
--- 0: ROHR1
--- 1: DAMM
-
-
 -- Geodaesie/Bauwerke/Wehre.shp
 CREATE SEQUENCE BUILDINGS_ID_SEQ;
 CREATE TABLE buildings (

http://dive4elements.wald.intevation.org