Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-cleanup.sql @ 170:88c14d5d45be
Added missing sequences. Deleted unsupported sqlite schema.
flys-backend/trunk@1460 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 14 Mar 2011 11:31:00 +0000 |
| parents | 7929f4144d2f |
| children | 4a83e14f40f9 |
comparison
equal
deleted
inserted
replaced
| 169:7929f4144d2f | 170:88c14d5d45be |
|---|---|
| 21 DROP TABLE ranges CASCADE; | 21 DROP TABLE ranges CASCADE; |
| 22 DROP TABLE attributes CASCADE; | 22 DROP TABLE attributes CASCADE; |
| 23 | 23 |
| 24 DROP TABLE rivers CASCADE; | 24 DROP TABLE rivers CASCADE; |
| 25 | 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_COLUMN_ID_SEQ; | |
| 30 DROP SEQUENCE WST_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; | |
| 26 DROP SEQUENCE RIVERS_ID_SEQ; | 42 DROP SEQUENCE RIVERS_ID_SEQ; |
| 27 | 43 |
| 28 COMMIT; | 44 COMMIT; |