Mercurial > dive4elements > river
diff 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 diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/flys-backend/doc/schema/postgresql-cleanup.sql Fri Mar 11 16:23:42 2011 +0000 @@ -0,0 +1,28 @@ +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;