Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-spatial.sql @ 5034:96d330bc40d0 dami

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update drop script to include the new tables and leave the old one
author Andre Heinecke <aheinecke@intevation.de>
date Tue, 19 Feb 2013 16:57:25 +0100
parents 998f1a7dcfde
children d4fdd98a04f7
comparison
equal deleted inserted replaced
5028:a5f438895a38 5034:96d330bc40d0
10 10
11 DROP TRIGGER cross_section_tracks_trigger; 11 DROP TRIGGER cross_section_tracks_trigger;
12 DROP TABLE cross_section_tracks; 12 DROP TABLE cross_section_tracks;
13 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS'; 13 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; 14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
15
16 DROP TRIGGER lines_trigger;
17 DROP TABLE lines;
18 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
19 DROP SEQUENCE LINES_ID_SEQ;
20 15
21 DROP TRIGGER buildings_trigger; 16 DROP TRIGGER buildings_trigger;
22 DROP TABLE buildings; 17 DROP TABLE buildings;
23 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS'; 18 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
24 DROP SEQUENCE BUILDINGS_ID_SEQ; 19 DROP SEQUENCE BUILDINGS_ID_SEQ;
40 DROP TRIGGER catchment_trigger; 35 DROP TRIGGER catchment_trigger;
41 DROP TABLE catchment; 36 DROP TABLE catchment;
42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT'; 37 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
43 DROP SEQUENCE CATCHMENT_ID_SEQ; 38 DROP SEQUENCE CATCHMENT_ID_SEQ;
44 39
45 DROP TRIGGER hws_trigger; 40 DROP TRIGGER hws_lines_trigger;
46 DROP TABLE hws; 41 DROP TABLE hws_lines;
47 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS'; 42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES';
48 DROP SEQUENCE HWS_ID_SEQ; 43 DROP SEQUENCE HWS_LINES_ID_SEQ;
44
45 DROP TRIGGER hws_points_trigger;
46 DROP TABLE hws_points;
47 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_POINTS';
48 DROP SEQUENCE HWS_POINTS_ID_SEQ;
49 49
50 DROP TRIGGER floodmaps_trigger; 50 DROP TRIGGER floodmaps_trigger;
51 DROP TABLE floodmaps; 51 DROP TABLE floodmaps;
52 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS'; 52 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
53 DROP SEQUENCE FLOODMAPS_ID_SEQ; 53 DROP SEQUENCE FLOODMAPS_ID_SEQ;
64 64
65 DROP TRIGGER gauge_location_trigger; 65 DROP TRIGGER gauge_location_trigger;
66 DROP TABLE gauge_location; 66 DROP TABLE gauge_location;
67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION'; 67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION';
68 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; 68 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ;
69
70 DROP TABLE hws_kinds;
71 DROP TABLE sectie_kinds;
72 DROP TABLE sobek_kinds;
73 DROP TABLE fed_states;
74 DROP TABLE boundary_kinds;
http://dive4elements.wald.intevation.org