sascha@169: BEGIN;
sascha@169: 
sascha@476: DROP VIEW wst_value_table;
sascha@476: 
sascha@169: DROP TABLE wst_column_q_ranges;
sascha@169: DROP TABLE wst_q_ranges;
sascha@169: DROP TABLE wst_column_values;
sascha@169: DROP TABLE wst_column;
sascha@169: DROP TABLE wst;
sascha@169: 
sascha@169: DROP TABLE discharge_table_values;
sascha@169: DROP TABLE discharge_tables;
sascha@169: 
sascha@169: DROP TABLE main_values CASCADE;
sascha@169: DROP TABLE time_intervals CASCADE;
sascha@169: DROP TABLE named_main_values CASCADE;
sascha@169: DROP TABLE main_value_types CASCADE;
sascha@169: 
sascha@169: DROP TABLE gauges CASCADE;
sascha@169: 
sascha@169: DROP TABLE annotations CASCADE;
sascha@169: DROP TABLE positions CASCADE;
sascha@169: DROP TABLE ranges CASCADE;
sascha@169: DROP TABLE attributes CASCADE;
sascha@169: 
sascha@169: DROP TABLE rivers CASCADE;
sascha@169: 
sascha@170: DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ;
sascha@170: DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
sascha@170: DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
sascha@171: DROP SEQUENCE WST_COLUMNS_ID_SEQ;
sascha@171: DROP SEQUENCE WSTS_ID_SEQ;
sascha@170: DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ;
sascha@170: DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ;
sascha@170: DROP SEQUENCE MAIN_VALUES_ID_SEQ;
sascha@170: DROP SEQUENCE TIME_INTERVALS_ID_SEQ;
sascha@170: DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
sascha@170: DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ;
sascha@170: DROP SEQUENCE GAUGES_ID_SEQ;
sascha@170: DROP SEQUENCE ANNOTATIONS_ID_SEQ;
sascha@170: DROP SEQUENCE POSITIONS_ID_SEQ;
sascha@170: DROP SEQUENCE RANGES_ID_SEQ;
sascha@170: DROP SEQUENCE ATTRIBUTES_ID_SEQ;
sascha@169: DROP SEQUENCE RIVERS_ID_SEQ;
sascha@169: 
sascha@169: COMMIT;