Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 160:27d3d0093993 | 207:2b745b5e731c |
|---|---|
| 1 BEGIN; | |
| 2 | |
| 3 DROP TABLE wst_column_q_ranges; | |
| 4 DROP TABLE wst_q_ranges; | |
| 5 DROP TABLE wst_column_values; | |
| 6 DROP TABLE wst_column; | |
| 7 DROP TABLE wst; | |
| 8 | |
| 9 DROP TABLE discharge_table_values; | |
| 10 DROP TABLE discharge_tables; | |
| 11 | |
| 12 DROP TABLE main_values CASCADE; | |
| 13 DROP TABLE time_intervals CASCADE; | |
| 14 DROP TABLE named_main_values CASCADE; | |
| 15 DROP TABLE main_value_types CASCADE; | |
| 16 | |
| 17 DROP TABLE gauges CASCADE; | |
| 18 | |
| 19 DROP TABLE annotations CASCADE; | |
| 20 DROP TABLE positions CASCADE; | |
| 21 DROP TABLE ranges CASCADE; | |
| 22 DROP TABLE attributes CASCADE; | |
| 23 | |
| 24 DROP TABLE rivers CASCADE; | |
| 25 | |
| 26 DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ; | |
| 27 DROP SEQUENCE WST_Q_RANGES_ID_SEQ; | |
| 28 DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ; | |
| 29 DROP SEQUENCE WST_COLUMNS_ID_SEQ; | |
| 30 DROP SEQUENCE WSTS_ID_SEQ; | |
| 31 DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ; | |
| 32 DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ; | |
| 33 DROP SEQUENCE MAIN_VALUES_ID_SEQ; | |
| 34 DROP SEQUENCE TIME_INTERVALS_ID_SEQ; | |
| 35 DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; | |
| 36 DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ; | |
| 37 DROP SEQUENCE GAUGES_ID_SEQ; | |
| 38 DROP SEQUENCE ANNOTATIONS_ID_SEQ; | |
| 39 DROP SEQUENCE POSITIONS_ID_SEQ; | |
| 40 DROP SEQUENCE RANGES_ID_SEQ; | |
| 41 DROP SEQUENCE ATTRIBUTES_ID_SEQ; | |
| 42 DROP SEQUENCE RIVERS_ID_SEQ; | |
| 43 | |
| 44 COMMIT; |