# HG changeset patch
# User mschaefer
# Date 1524489883 -7200
# Node ID 5974bba60e4efba8a74334bc94de1d37fcac93ae
# Parent  aab0c2730a258c4051447ecf07fbc124dddebdaa
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script

diff -r aab0c2730a25 -r 5974bba60e4e backend/doc/schema/oracle-drop-sinfo-uinfo.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/backend/doc/schema/oracle-drop-sinfo-uinfo.sql	Mon Apr 23 15:24:43 2018 +0200
@@ -0,0 +1,53 @@
+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;