Mercurial > dive4elements > river
view backend/doc/schema/oracle-drop-sinfo-uinfo.sql @ 9443:515643b2c49a
Added computation of uinfo salix line vegetation zone height (not yet connected to the cross section facet)
author | mschaefer |
---|---|
date | Mon, 20 Aug 2018 18:50:33 +0200 |
parents | 1f63e9d3b0ec |
children |
line wrap: on
line source
SET AUTOCOMMIT ON; DROP TABLE bed_mobility CASCADE CONSTRAINTS PURGE; DROP TABLE bed_mobility_values CASCADE CONSTRAINTS PURGE; DROP TABLE infrastructure CASCADE CONSTRAINTS PURGE; DROP TABLE infrastructure_values CASCADE CONSTRAINTS PURGE; DROP TABLE channel CASCADE CONSTRAINTS PURGE; DROP TABLE channel_values CASCADE CONSTRAINTS PURGE; DROP TABLE collision_type CASCADE CONSTRAINTS PURGE; DROP TABLE collision CASCADE CONSTRAINTS PURGE; DROP TABLE collision_values CASCADE CONSTRAINTS PURGE; DROP TABLE tkh CASCADE CONSTRAINTS PURGE; DROP TABLE tkh_column CASCADE CONSTRAINTS PURGE; DROP TABLE tkh_values CASCADE CONSTRAINTS PURGE; DROP TABLE depth_evolution CASCADE CONSTRAINTS PURGE; DROP TABLE depth_evolution_values CASCADE CONSTRAINTS PURGE; DROP TABLE daily_discharge CASCADE CONSTRAINTS PURGE; DROP TABLE daily_discharge_values CASCADE CONSTRAINTS PURGE; DROP TABLE salix CASCADE CONSTRAINTS PURGE; DROP TABLE salix_values CASCADE CONSTRAINTS PURGE; DROP TABLE salix_rank CASCADE CONSTRAINTS PURGE; DROP TABLE vegetation_type CASCADE CONSTRAINTS PURGE; DROP TABLE vegetation CASCADE CONSTRAINTS PURGE; DROP TABLE vegetation_zone CASCADE CONSTRAINTS PURGE; DROP TABLE flow_depth CASCADE CONSTRAINTS PURGE; DROP TABLE flow_depth_column CASCADE CONSTRAINTS PURGE; DROP TABLE flow_depth_values CASCADE CONSTRAINTS PURGE; DROP SEQUENCE BED_MOBILITY_ID_SEQ; DROP SEQUENCE BED_MOBILITY_VALUES_ID_SEQ; DROP SEQUENCE INFRASTRUCTURE_ID_SEQ; DROP SEQUENCE INFRASTRUCTURE_VALUES_ID_SEQ; DROP SEQUENCE CHANNEL_ID_SEQ; DROP SEQUENCE CHANNEL_VALUES_ID_SEQ; DROP SEQUENCE COLLISION_TYPE_ID_SEQ; DROP SEQUENCE COLLISION_ID_SEQ; DROP SEQUENCE COLLISION_VALUES_ID_SEQ; DROP SEQUENCE TKH_ID_SEQ; DROP SEQUENCE TKH_COLUMN_ID_SEQ; DROP SEQUENCE TKH_VALUES_ID_SEQ; DROP SEQUENCE DEPTH_EVOLUTION_ID_SEQ; DROP SEQUENCE DEPTH_EVOLUTION_VALUES_ID_SEQ; DROP SEQUENCE DAILY_DISCHARGE_ID_SEQ; DROP SEQUENCE DAILY_DISCHARGE_VALUES_ID_SEQ; DROP SEQUENCE SALIX_ID_SEQ; DROP SEQUENCE SALIX_VALUES_ID_SEQ; --DROP SEQUENCE SALIX_RANK_ID_SEQ; --DROP SEQUENCE VEGETATION_TYPE_ID_SEQ; DROP SEQUENCE VEGETATION_ID_SEQ; DROP SEQUENCE VEGETATION_ZONE_ID_SEQ; DROP SEQUENCE FLOW_DEPTH_ID_SEQ; DROP SEQUENCE FLOW_DEPTH_COLUMN_ID_SEQ; DROP SEQUENCE FLOW_DEPTH_VALUES_ID_SEQ;