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;

http://dive4elements.wald.intevation.org