Mercurial > dive4elements > river
view backend/doc/schema/oracle-drop-minfo.sql @ 8722:a83d519155ab
(issue1754) Do not base smoothing radius on calculation range
Using the calculation parameters for startkm and endkm in the
case that the domain axis had the default extend caused weird
behavior when zooming and led to too large radius values for
most data that only had valid values on a subset of the caluclation
range.
author | Andre Heinecke <andre.heinecke@intevation.de> |
---|---|
date | Tue, 28 Apr 2015 14:22:47 +0200 |
parents | 1a4ad0d4231a |
children |
line wrap: on
line source
SET AUTOCOMMIT ON; ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; 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; ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id; ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id; ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id; ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id; ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id; ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id; ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_grain_fraction_id; ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_unit_id; ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_time_interval_id; ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_river_id; ALTER TABLE sediment_load_ls_values DROP CONSTRAINT fk_sllsv_sediment_load_ls_id; ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_kind_id; ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_grain_fraction_id; ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_time_interval_id; ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_sq_time_interval_id; ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_sediment_load_id; ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_m_station_id; ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id; ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id; ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; DROP TABLE bed_height_type PURGE; DROP TABLE location_system PURGE; DROP TABLE elevation_model 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; DROP TABLE morphologic_width PURGE; DROP TABLE morphologic_width_values PURGE; DROP TABLE discharge_zone PURGE; DROP TABLE flow_velocity_model PURGE; DROP TABLE flow_velocity_model_values PURGE; DROP TABLE flow_velocity_measurements PURGE; DROP TABLE flow_velocity_measure_values PURGE; DROP TABLE grain_fraction PURGE; DROP TABLE sediment_load_ls PURGE; DROP TABLE sediment_load_ls_values PURGE; DROP TABLE sediment_load PURGE; DROP TABLE sediment_load_values PURGE; DROP TABLE measurement_station PURGE; DROP TABLE sq_relation_value PURGE; DROP TABLE sq_relation PURGE; DROP SEQUENCE LOCATION_SYSTEM_SEQ; DROP SEQUENCE ELEVATION_MODEL_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; DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ; DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ; DROP SEQUENCE FV_MEASURE_ID_SEQ; DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; DROP SEQUENCE SEDIMENT_LOAD_LS_ID_SEQ; DROP SEQUENCE SEDIMENT_LOAD_LS_VALUES_ID_SEQ; DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ; DROP SEQUENCE SEDIMENT_LOAD_VALUES_ID_SEQ; DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ; DROP SEQUENCE SQ_RELATION_ID_SEQ; DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;