Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-minfo.sql @ 8666:1a4ad0d4231a
(issue1763) Use more distinct constraint names and adapt drop-script.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 08 Apr 2015 18:15:55 +0200 |
| parents | 9db1f48bfea9 |
| children | bfca77cbf353 |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-minfo.sql Wed Apr 08 14:47:30 2015 +0200 +++ b/backend/doc/schema/postgresql-minfo.sql Wed Apr 08 18:15:55 2015 +0200 @@ -49,16 +49,16 @@ evaluation_by VARCHAR(255), description VARCHAR(255), PRIMARY KEY(id), - CONSTRAINT fk_bed_river_id FOREIGN KEY (river_id) + CONSTRAINT fk_bh_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, - CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), - CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) + CONSTRAINT fk_bh_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), + CONSTRAINT fk_bh_location_system FOREIGN KEY (location_system_id) REFERENCES location_system(id), - CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) + CONSTRAINT fk_bh_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id), - CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) + CONSTRAINT fk_bh_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id), - CONSTRAINT fk_range FOREIGN KEY (range_id) + CONSTRAINT fk_bh_range FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE );