view flys-backend/doc/schema/postgresql-cleanup.sql @ 169:7929f4144d2f

Bound Apache Commons DBCP with Hibernate. flys-backend/trunk@1459 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 11 Mar 2011 16:23:42 +0000
parents
children 88c14d5d45be
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 RIVERS_ID_SEQ;

COMMIT;

http://dive4elements.wald.intevation.org