diff backend/doc/schema/oracle-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 3531f0cee5e1
children 94cddb00f934
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Wed Apr 08 14:47:30 2015 +0200
+++ b/backend/doc/schema/oracle-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
 );
 

http://dive4elements.wald.intevation.org