Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-drop.sql @ 6300:0711ce5ca701
Backend: Modified schema for a better model of official lines.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Wed, 12 Jun 2013 16:36:34 +0200 |
| parents | 5aa05a7a34b7 |
| children | 97145ec4e33c |
comparison
equal
deleted
inserted
replaced
| 6299:16182a08ccf7 | 6300:0711ce5ca701 |
|---|---|
| 55 DROP TABLE units; | 55 DROP TABLE units; |
| 56 DROP TABLE wst_column_q_ranges; | 56 DROP TABLE wst_column_q_ranges; |
| 57 DROP TABLE wst_column_values; | 57 DROP TABLE wst_column_values; |
| 58 DROP TABLE wst_columns; | 58 DROP TABLE wst_columns; |
| 59 DROP TABLE wst_q_ranges; | 59 DROP TABLE wst_q_ranges; |
| 60 DROP TABLE official_lines; | |
| 60 DROP TABLE wsts; | 61 DROP TABLE wsts; |
| 61 DROP TABLE wst_kinds; | 62 DROP TABLE wst_kinds; |
| 62 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; | 63 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; |
| 63 DROP SEQUENCE ANNOTATIONS_ID_SEQ; | 64 DROP SEQUENCE ANNOTATIONS_ID_SEQ; |
| 64 DROP SEQUENCE ATTRIBUTES_ID_SEQ; | 65 DROP SEQUENCE ATTRIBUTES_ID_SEQ; |
| 84 DROP SEQUENCE UNITS_ID_SEQ; | 85 DROP SEQUENCE UNITS_ID_SEQ; |
| 85 DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ; | 86 DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ; |
| 86 DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ; | 87 DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ; |
| 87 DROP SEQUENCE WST_COLUMNS_ID_SEQ; | 88 DROP SEQUENCE WST_COLUMNS_ID_SEQ; |
| 88 DROP SEQUENCE WST_Q_RANGES_ID_SEQ; | 89 DROP SEQUENCE WST_Q_RANGES_ID_SEQ; |
| 90 DROP SEQUENCE OFFICIAL_LINES_ID_SEQ; | |
| 89 DROP SEQUENCE WSTS_ID_SEQ; | 91 DROP SEQUENCE WSTS_ID_SEQ; |
| 90 DROP VIEW wst_value_table; | 92 DROP VIEW wst_value_table; |
| 91 DROP VIEW wst_w_values ; | 93 DROP VIEW wst_w_values ; |
| 92 DROP VIEW wst_q_values; | 94 DROP VIEW wst_q_values; |
| 93 DROP VIEW official_lines; | |
| 94 DROP VIEW q_main_values; | |
| 95 DROP VIEW official_q_values; | |
| 96 DROP VIEW wst_ranges; | 95 DROP VIEW wst_ranges; |