diff backend/doc/schema/oracle-drop-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 a846a3d910a0
children
line wrap: on
line diff
--- a/backend/doc/schema/oracle-drop-minfo.sql	Wed Apr 08 14:47:30 2015 +0200
+++ b/backend/doc/schema/oracle-drop-minfo.sql	Wed Apr 08 18:15:55 2015 +0200
@@ -1,13 +1,13 @@
 SET AUTOCOMMIT ON;
 
 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit;
-ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id;
-ALTER TABLE bed_height_single DROP CONSTRAINT fk_type;
-ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system;
-ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model;
-ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model;
-ALTER TABLE bed_height_single DROP CONSTRAINT fk_range;
-ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent;
+ALTER TABLE bed_height DROP CONSTRAINT fk_bh_river_id;
+ALTER TABLE bed_height DROP CONSTRAINT fk_bh_type;
+ALTER TABLE bed_height DROP CONSTRAINT fk_bh_location_system;
+ALTER TABLE bed_height DROP CONSTRAINT fk_bh_cur_elevation_model;
+ALTER TABLE bed_height DROP CONSTRAINT fk_bh_old_elevation_model;
+ALTER TABLE bed_height DROP CONSTRAINT fk_bh_range;
+ALTER TABLE bed_height_values DROP CONSTRAINT fk_bed_values_parent;
 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
@@ -41,8 +41,8 @@
 DROP TABLE bed_height_type PURGE;
 DROP TABLE location_system PURGE;
 DROP TABLE elevation_model PURGE;
-DROP TABLE bed_height_single PURGE;
-DROP TABLE bed_height_single_values PURGE;
+DROP TABLE bed_height PURGE;
+DROP TABLE bed_height_values PURGE;
 DROP TABLE depths PURGE;
 DROP TABLE sediment_density PURGE;
 DROP TABLE sediment_density_values PURGE;
@@ -64,8 +64,8 @@
 
 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
 DROP SEQUENCE ELEVATION_MODEL_SEQ;
-DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
-DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
+DROP SEQUENCE BED_HEIGHT_ID_SEQ;
+DROP SEQUENCE BED_HEIGHT_VALUES_ID_SEQ;
 DROP SEQUENCE DEPTHS_ID_SEQ;
 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;

http://dive4elements.wald.intevation.org