changeset 5068:df090e461c30 dami

Add some missed changes to the migrate-dami.sql script
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 20 Feb 2013 18:30:05 +0100
parents be27a2bb7ca2
children 082e7b01d562
files flys-backend/doc/schema/postgresql-migrate-dami.sql
diffstat 1 files changed, 6 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-migrate-dami.sql	Wed Feb 20 18:29:46 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-migrate-dami.sql	Wed Feb 20 18:30:05 2013 +0100
@@ -1,5 +1,10 @@
 DROP table hws;
 DROP sequence HWS_ID_SEQ;
+DROP table lines;
+DROP sequence LINES_ID_SEQ;
+DROP table catchment;
+DROP sequence CATCHMENT_ID_SEQ;
+
 -- Static lookup tables for Hochwasserschutzanlagen
 CREATE TABLE hws_kinds (
     id int PRIMARY KEY NOT NULL,
@@ -108,6 +113,7 @@
 
 ALTER TABLE hydr_boundaries_poly ADD COLUMN sectie INT REFERENCES sectie_kinds(id);
 ALTER TABLE hydr_boundaries_poly ADD COLUMN sobek INT REFERENCES sobek_kinds(id);
+ALTER TABLE hydr_boundaries_poly ADD FOREIGN KEY (kind) REFERENCES boundary_kinds(id);
 ALTER TABLE hydr_boundaries ADD COLUMN sectie INT REFERENCES sectie_kinds(id);
 ALTER TABLE hydr_boundaries ADD COLUMN sobek INT REFERENCES sobek_kinds(id);
 ALTER TABLE hydr_boundaries ADD FOREIGN KEY (kind) REFERENCES boundary_kinds(id);

http://dive4elements.wald.intevation.org