Mercurial > dive4elements > river
diff backend/doc/schema/oracle-drop.sql @ 8683:cfafe5764509
(issue 1796) Scheme change! Add model for seddb_name lookup table.
author | Andre Heinecke <andre.heinecke@intevation.de> |
---|---|
date | Mon, 13 Apr 2015 11:24:32 +0200 |
parents | 765944ca6df0 |
children |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-drop.sql Mon Apr 13 11:03:00 2015 +0200 +++ b/backend/doc/schema/oracle-drop.sql Mon Apr 13 11:24:32 2015 +0200 @@ -24,6 +24,7 @@ ALTER TABLE official_lines DROP CONSTRAINT cOffLinesWstColumns; ALTER TABLE ranges DROP CONSTRAINT cRangesRivers; ALTER TABLE rivers DROP CONSTRAINT cRiversUnits; +ALTER TABLE rivers DROP CONSTRAINT cRiversSeddbNames; ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums; ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges; ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns; @@ -62,6 +63,7 @@ DROP TABLE official_lines PURGE; DROP TABLE wsts PURGE; DROP TABLE wst_kinds PURGE; +DROP TABLE seddb_names PURGE; DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; DROP SEQUENCE ANNOTATIONS_ID_SEQ; DROP SEQUENCE ATTRIBUTES_ID_SEQ;