Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-cleanup.sql @ 476:77f337650211
Added a view 'wst_value_table' which aggregates the data to build w/q value tables.
flys-backend/trunk@1723 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 18 Apr 2011 15:52:53 +0000 |
| parents | 4a83e14f40f9 |
| children |
comparison
equal
deleted
inserted
replaced
| 475:9aa0eddc5221 | 476:77f337650211 |
|---|---|
| 1 BEGIN; | 1 BEGIN; |
| 2 | |
| 3 DROP VIEW wst_value_table; | |
| 2 | 4 |
| 3 DROP TABLE wst_column_q_ranges; | 5 DROP TABLE wst_column_q_ranges; |
| 4 DROP TABLE wst_q_ranges; | 6 DROP TABLE wst_q_ranges; |
| 5 DROP TABLE wst_column_values; | 7 DROP TABLE wst_column_values; |
| 6 DROP TABLE wst_column; | 8 DROP TABLE wst_column; |