--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/flys-backend/doc/schema/postgresql-cleanup.sql	Fri Sep 28 12:14:07 2012 +0200
@@ -0,0 +1,44 @@
+BEGIN;
+
+DROP TABLE wst_column_q_ranges;
+DROP TABLE wst_q_ranges;
+DROP TABLE wst_column_values;
+DROP TABLE wst_column;
+DROP TABLE wst;
+
+DROP TABLE discharge_table_values;
+DROP TABLE discharge_tables;
+
+DROP TABLE main_values CASCADE;
+DROP TABLE time_intervals CASCADE;
+DROP TABLE named_main_values CASCADE;
+DROP TABLE main_value_types CASCADE;
+
+DROP TABLE gauges CASCADE;
+
+DROP TABLE annotations CASCADE;
+DROP TABLE positions CASCADE;
+DROP TABLE ranges CASCADE;
+DROP TABLE attributes CASCADE;
+
+DROP TABLE rivers CASCADE;
+
+DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ;
+DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
+DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
+DROP SEQUENCE WST_COLUMNS_ID_SEQ;
+DROP SEQUENCE WSTS_ID_SEQ;
+DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ;
+DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ;
+DROP SEQUENCE MAIN_VALUES_ID_SEQ;
+DROP SEQUENCE TIME_INTERVALS_ID_SEQ;
+DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
+DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ;
+DROP SEQUENCE GAUGES_ID_SEQ;
+DROP SEQUENCE ANNOTATIONS_ID_SEQ;
+DROP SEQUENCE POSITIONS_ID_SEQ;
+DROP SEQUENCE RANGES_ID_SEQ;
+DROP SEQUENCE ATTRIBUTES_ID_SEQ;
+DROP SEQUENCE RIVERS_ID_SEQ;
+
+COMMIT;