Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-minfo.sql @ 8471:a846a3d910a0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove obsolete lines from drop script.
author "Tom Gottfried <tom@intevation.de>"
date Thu, 13 Nov 2014 13:28:45 +0100
parents 5f28aa1be795
children 1a4ad0d4231a
comparison
equal deleted inserted replaced
8470:c5a7aae52396 8471:a846a3d910a0
6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; 6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system;
7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; 7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model;
8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; 8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model;
9 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; 9 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range;
10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; 10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent;
11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent;
12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model;
13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model;
14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range;
15 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id; 11 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
16 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;
17 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id; 13 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
18 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id; 14 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
19 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;
45 DROP TABLE bed_height_type PURGE; 41 DROP TABLE bed_height_type PURGE;
46 DROP TABLE location_system PURGE; 42 DROP TABLE location_system PURGE;
47 DROP TABLE elevation_model PURGE; 43 DROP TABLE elevation_model PURGE;
48 DROP TABLE bed_height_single PURGE; 44 DROP TABLE bed_height_single PURGE;
49 DROP TABLE bed_height_single_values PURGE; 45 DROP TABLE bed_height_single_values PURGE;
50 DROP TABLE bed_height_epoch_values PURGE;
51 DROP TABLE bed_height_epoch PURGE;
52 DROP TABLE depths PURGE; 46 DROP TABLE depths PURGE;
53 DROP TABLE sediment_density PURGE; 47 DROP TABLE sediment_density PURGE;
54 DROP TABLE sediment_density_values PURGE; 48 DROP TABLE sediment_density_values PURGE;
55 DROP TABLE morphologic_width PURGE; 49 DROP TABLE morphologic_width PURGE;
56 DROP TABLE morphologic_width_values PURGE; 50 DROP TABLE morphologic_width_values PURGE;
70 64
71 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 65 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
72 DROP SEQUENCE ELEVATION_MODEL_SEQ; 66 DROP SEQUENCE ELEVATION_MODEL_SEQ;
73 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 67 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
74 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; 68 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
75 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
76 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ;
77 DROP SEQUENCE DEPTHS_ID_SEQ; 69 DROP SEQUENCE DEPTHS_ID_SEQ;
78 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ; 70 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
79 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ; 71 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
80 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; 72 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
81 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; 73 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org