Mercurial > dive4elements > river
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);