Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop.sql @ 8683:cfafe5764509

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(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
comparison
equal deleted inserted replaced
8682:5102733c4567 8683:cfafe5764509
22 ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes; 22 ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes;
23 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesNamedMainValues; 23 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesNamedMainValues;
24 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesWstColumns; 24 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesWstColumns;
25 ALTER TABLE ranges DROP CONSTRAINT cRangesRivers; 25 ALTER TABLE ranges DROP CONSTRAINT cRangesRivers;
26 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits; 26 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits;
27 ALTER TABLE rivers DROP CONSTRAINT cRiversSeddbNames;
27 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums; 28 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums;
28 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges; 29 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges;
29 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns; 30 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns;
30 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals; 31 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
31 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts; 32 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
60 DROP TABLE wst_columns PURGE; 61 DROP TABLE wst_columns PURGE;
61 DROP TABLE wst_q_ranges PURGE; 62 DROP TABLE wst_q_ranges PURGE;
62 DROP TABLE official_lines PURGE; 63 DROP TABLE official_lines PURGE;
63 DROP TABLE wsts PURGE; 64 DROP TABLE wsts PURGE;
64 DROP TABLE wst_kinds PURGE; 65 DROP TABLE wst_kinds PURGE;
66 DROP TABLE seddb_names PURGE;
65 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; 67 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
66 DROP SEQUENCE ANNOTATIONS_ID_SEQ; 68 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
67 DROP SEQUENCE ATTRIBUTES_ID_SEQ; 69 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
68 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ; 70 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
69 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ; 71 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
http://dive4elements.wald.intevation.org