view flys-backend/doc/schema/postgresql-cleanup.sql @ 207:2b745b5e731c 0.1

merged flys-backend/0.1
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:14:07 +0200
parents 4a83e14f40f9
children 77f337650211
line wrap: on
line source
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;

http://dive4elements.wald.intevation.org