Mercurial > dive4elements > river
view flys-backend/doc/schema/postgresql-cleanup.sql @ 761:3170fe2e7661
Forgot to store reference to edge.
flys-backend/trunk@2111 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 14 Jun 2011 13:55:49 +0000 |
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;