mschaefer@9019: SET AUTOCOMMIT ON;
mschaefer@9019: 
mschaefer@9019: DROP TABLE bed_mobility CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE bed_mobility_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE infrastructure CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE infrastructure_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE channel CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE channel_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE collision_type CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE collision CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE collision_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE tkh CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE tkh_column CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE tkh_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE depth_evolution CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE depth_evolution_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE daily_discharge CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE daily_discharge_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE salix CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE salix_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE salix_rank CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE vegetation_type CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE vegetation CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE vegetation_zone CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE flow_depth CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE flow_depth_column CASCADE CONSTRAINTS PURGE;
mschaefer@9019: DROP TABLE flow_depth_values CASCADE CONSTRAINTS PURGE;
mschaefer@9019: 
mschaefer@9019: DROP SEQUENCE BED_MOBILITY_ID_SEQ;
mschaefer@9019: DROP SEQUENCE BED_MOBILITY_VALUES_ID_SEQ;
mschaefer@9019: DROP SEQUENCE INFRASTRUCTURE_ID_SEQ;
mschaefer@9019: DROP SEQUENCE INFRASTRUCTURE_VALUES_ID_SEQ;
mschaefer@9019: DROP SEQUENCE CHANNEL_ID_SEQ;
mschaefer@9019: DROP SEQUENCE CHANNEL_VALUES_ID_SEQ;
mschaefer@9019: DROP SEQUENCE COLLISION_TYPE_ID_SEQ;
mschaefer@9019: DROP SEQUENCE COLLISION_ID_SEQ;
mschaefer@9019: DROP SEQUENCE COLLISION_VALUES_ID_SEQ;
mschaefer@9019: DROP SEQUENCE TKH_ID_SEQ;
mschaefer@9019: DROP SEQUENCE TKH_COLUMN_ID_SEQ;
mschaefer@9019: DROP SEQUENCE TKH_VALUES_ID_SEQ;
mschaefer@9019: DROP SEQUENCE DEPTH_EVOLUTION_ID_SEQ;
mschaefer@9019: DROP SEQUENCE DEPTH_EVOLUTION_VALUES_ID_SEQ;
mschaefer@9019: DROP SEQUENCE DAILY_DISCHARGE_ID_SEQ;
mschaefer@9019: DROP SEQUENCE DAILY_DISCHARGE_VALUES_ID_SEQ;
mschaefer@9019: DROP SEQUENCE SALIX_ID_SEQ;
mschaefer@9019: DROP SEQUENCE SALIX_VALUES_ID_SEQ;
mschaefer@9032: --DROP SEQUENCE SALIX_RANK_ID_SEQ;
mschaefer@9032: --DROP SEQUENCE VEGETATION_TYPE_ID_SEQ;
mschaefer@9019: DROP SEQUENCE VEGETATION_ID_SEQ;
mschaefer@9019: DROP SEQUENCE VEGETATION_ZONE_ID_SEQ;
mschaefer@9019: DROP SEQUENCE FLOW_DEPTH_ID_SEQ;
mschaefer@9019: DROP SEQUENCE FLOW_DEPTH_COLUMN_ID_SEQ;
mschaefer@9019: DROP SEQUENCE FLOW_DEPTH_VALUES_ID_SEQ;