diff flys-backend/doc/schema/postgresql-spatial.sql @ 1243:3ebc0a7d6793

Removed all tables for different datasets at HYdrologie/Hydr.Grenzen/Linien/* flys-backend/trunk@2716 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Hans Plum <hans.plum@intevation.de>
date Tue, 13 Sep 2011 10:34:44 +0000
parents d6520d46edb7
children b28ab244a77d
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Tue Sep 13 08:02:38 2011 +0000
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Tue Sep 13 10:34:44 2011 +0000
@@ -126,63 +126,6 @@
 -- ALTER TABLE hw ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_ID_SEQ');
 
 -- Hydrologie/Hydr. Grenzen/Linien
-   -- BfG/boeschung_*.shp 
-CREATE SEQUENCE BANKS_ID_SEQ;
-CREATE TABLE banks (
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id)
-);
-SELECT AddGeometryColumn('banks','geom',31466,'MULTILINESTRING',2);
-ALTER TABLE banks ALTER COLUMN id SET DEFAULT NEXTVAL('BANKS_ID_SEQ');
-
-   -- BfG/hauptoeff_*.shp
-CREATE SEQUENCE MAINSPANS_ID_SEQ;
-CREATE TABLE mainspans(
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id)
-);
-SELECT AddGeometryColumn('mainspans','geom',31466,'MULTILINESTRING',2);
-ALTER TABLE mainspans ALTER COLUMN id SET DEFAULT NEXTVAL('MAINSPANS_ID_SEQ');
-
-   -- BfG/MNQ-*.shp
-CREATE SEQUENCE MNQ_ID_SEQ;
-CREATE TABLE mnq (gid serial PRIMARY KEY,
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id),
-    haltung varchar(16)
-);
-SELECT AddGeometryColumn('mnq', 'the_geom',31466,'MULTIPOLYGON',2);
-ALTER TABLE mnq ALTER COLUMN id SET DEFAULT NEXTVAL('MNQ_ID_SEQ');
-
-   -- BfG/modellgrenze*.shp
-CREATE SEQUENCE MODELBOUNDARY_ID_SEQ;
-CREATE TABLE modelboundary (
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id)
-);
-SELECT AddGeometryColumn('modelboundary','geom',31466,'MULTILINESTRING',2);
-ALTER TABLE modelboundary ALTER COLUMN id SET DEFAULT NEXTVAL('MODELBOUNDARY_ID_SEQ');
-
-   -- TODO: Klaeren ob benoetigt, da einzel Geometrien in Tabelle vorland.
-   -- BfG/saar-sld-vorland.shp
-
-   -- BfG/uferlinie.shp
-CREATE SEQUENCE SHORELINE_ID_SEQ;
-CREATE TABLE shoreline(
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id)
-);
-SELECT AddGeometryColumn('shoreline','geom',31466,'MULTILINESTRING',2);
-ALTER TABLE shoreline ALTER COLUMN id SET DEFAULT NEXTVAL('SHORELINE_ID_SEQ');
-
-   -- BfG/vorland_*.shp
-CREATE SEQUENCE FORELAND_ID_SEQ;
-CREATE TABLE foreland(
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id)
-);
-SELECT AddGeometryColumn('foreland','geom',31466,'MULTILINESTRING',2);
-ALTER TABLE foreland ALTER COLUMN id SET DEFAULT NEXTVAL('FORELANDS_ID_SEQ');
 
 
 -- Hydrologie/Streckendaten

http://dive4elements.wald.intevation.org