Mercurial > dive4elements > river
view flys-backend/doc/schema/postgresql-cleanup.sql @ 508:a9c7f6ec3a5a 2.3.1
merged flys-backend/2.3.1
author | Thomas Arendsen Hein <thomas@intevation.de> |
---|---|
date | Fri, 28 Sep 2012 12:14:12 +0200 |
parents | 77f337650211 |
children |
line wrap: on
line source
BEGIN; DROP VIEW wst_value_table; 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;