Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-minfo.sql @ 8666:1a4ad0d4231a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(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
comparison
equal deleted inserted replaced
8665:8fbc0649da13 8666:1a4ad0d4231a
1 SET AUTOCOMMIT ON; 1 SET AUTOCOMMIT ON;
2 2
3 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; 3 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit;
4 ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id; 4 ALTER TABLE bed_height DROP CONSTRAINT fk_bh_river_id;
5 ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; 5 ALTER TABLE bed_height DROP CONSTRAINT fk_bh_type;
6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; 6 ALTER TABLE bed_height DROP CONSTRAINT fk_bh_location_system;
7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; 7 ALTER TABLE bed_height DROP CONSTRAINT fk_bh_cur_elevation_model;
8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; 8 ALTER TABLE bed_height DROP CONSTRAINT fk_bh_old_elevation_model;
9 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; 9 ALTER TABLE bed_height DROP CONSTRAINT fk_bh_range;
10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; 10 ALTER TABLE bed_height_values DROP CONSTRAINT fk_bed_values_parent;
11 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id; 11 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
12 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id; 12 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
13 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id; 13 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
14 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id; 14 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
15 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id; 15 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id;
39 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; 39 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id;
40 40
41 DROP TABLE bed_height_type PURGE; 41 DROP TABLE bed_height_type PURGE;
42 DROP TABLE location_system PURGE; 42 DROP TABLE location_system PURGE;
43 DROP TABLE elevation_model PURGE; 43 DROP TABLE elevation_model PURGE;
44 DROP TABLE bed_height_single PURGE; 44 DROP TABLE bed_height PURGE;
45 DROP TABLE bed_height_single_values PURGE; 45 DROP TABLE bed_height_values PURGE;
46 DROP TABLE depths PURGE; 46 DROP TABLE depths PURGE;
47 DROP TABLE sediment_density PURGE; 47 DROP TABLE sediment_density PURGE;
48 DROP TABLE sediment_density_values PURGE; 48 DROP TABLE sediment_density_values PURGE;
49 DROP TABLE morphologic_width PURGE; 49 DROP TABLE morphologic_width PURGE;
50 DROP TABLE morphologic_width_values PURGE; 50 DROP TABLE morphologic_width_values PURGE;
62 DROP TABLE sq_relation_value PURGE; 62 DROP TABLE sq_relation_value PURGE;
63 DROP TABLE sq_relation PURGE; 63 DROP TABLE sq_relation PURGE;
64 64
65 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 65 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
66 DROP SEQUENCE ELEVATION_MODEL_SEQ; 66 DROP SEQUENCE ELEVATION_MODEL_SEQ;
67 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 67 DROP SEQUENCE BED_HEIGHT_ID_SEQ;
68 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; 68 DROP SEQUENCE BED_HEIGHT_VALUES_ID_SEQ;
69 DROP SEQUENCE DEPTHS_ID_SEQ; 69 DROP SEQUENCE DEPTHS_ID_SEQ;
70 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ; 70 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
71 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ; 71 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
72 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; 72 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
73 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; 73 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org