Mercurial > dive4elements > river
changeset 5271:dac7723fb502
added missing lookup tables to drop-scripts
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 13 Mar 2013 11:48:01 +0100 |
| parents | d17e3106c910 |
| children | da3101abc9da |
| files | flys-backend/doc/schema/oracle-drop-spatial.sql flys-backend/doc/schema/oracle-drop.sql |
| diffstat | 2 files changed, 4 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-spatial.sql Wed Mar 13 11:26:59 2013 +0100 +++ b/flys-backend/doc/schema/oracle-drop-spatial.sql Wed Mar 13 11:48:01 2013 +0100 @@ -73,3 +73,5 @@ DROP TABLE fed_states; DROP TABLE axis_kinds; DROP TABLE boundary_kinds; +DROP TABLE cross_section_track_kinds; +DROP TABLE floodplain_kinds;
--- a/flys-backend/doc/schema/oracle-drop.sql Wed Mar 13 11:26:59 2013 +0100 +++ b/flys-backend/doc/schema/oracle-drop.sql Wed Mar 13 11:48:01 2013 +0100 @@ -29,6 +29,7 @@ ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts; ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges; ALTER TABLE wsts DROP CONSTRAINT cWstsRivers; +ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds; DROP TABLE annotation_types; DROP TABLE annotations; DROP TABLE attributes; @@ -57,6 +58,7 @@ DROP TABLE wst_columns; DROP TABLE wst_q_ranges; DROP TABLE wsts; +DROP TABLE wst_kinds; DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; DROP SEQUENCE ANNOTATIONS_ID_SEQ; DROP SEQUENCE ATTRIBUTES_ID_SEQ;