comparison 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
comparison
equal deleted inserted replaced
8665:8fbc0649da13 8666:1a4ad0d4231a
47 old_elevation_model_id int, 47 old_elevation_model_id int,
48 range_id int, 48 range_id int,
49 evaluation_by VARCHAR(255), 49 evaluation_by VARCHAR(255),
50 description VARCHAR(255), 50 description VARCHAR(255),
51 PRIMARY KEY(id), 51 PRIMARY KEY(id),
52 CONSTRAINT fk_bed_river_id FOREIGN KEY (river_id) 52 CONSTRAINT fk_bh_river_id FOREIGN KEY (river_id)
53 REFERENCES rivers(id) ON DELETE CASCADE, 53 REFERENCES rivers(id) ON DELETE CASCADE,
54 CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), 54 CONSTRAINT fk_bh_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id),
55 CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) 55 CONSTRAINT fk_bh_location_system FOREIGN KEY (location_system_id)
56 REFERENCES location_system(id), 56 REFERENCES location_system(id),
57 CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) 57 CONSTRAINT fk_bh_cur_elevation_model FOREIGN KEY (cur_elevation_model_id)
58 REFERENCES elevation_model(id), 58 REFERENCES elevation_model(id),
59 CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) 59 CONSTRAINT fk_bh_old_elevation_model FOREIGN KEY (old_elevation_model_id)
60 REFERENCES elevation_model(id), 60 REFERENCES elevation_model(id),
61 CONSTRAINT fk_range FOREIGN KEY (range_id) 61 CONSTRAINT fk_bh_range FOREIGN KEY (range_id)
62 REFERENCES ranges(id) ON DELETE CASCADE 62 REFERENCES ranges(id) ON DELETE CASCADE
63 ); 63 );
64 64
65 65
66 CREATE SEQUENCE BED_HEIGHT_VALUES_ID_SEQ; 66 CREATE SEQUENCE BED_HEIGHT_VALUES_ID_SEQ;

http://dive4elements.wald.intevation.org