Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-spatial.sql @ 5379:61bf64b102bc mapgenfix

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merge with default branch
author Christian Lins <christian.lins@intevation.de>
date Fri, 22 Mar 2013 11:25:54 +0100
parents dac7723fb502
children 91f5908c472a
comparison
equal deleted inserted replaced
5175:cfc5540a4eec 5379:61bf64b102bc
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 axis_kinds;
75 DROP TABLE boundary_kinds;
76 DROP TABLE cross_section_track_kinds;
77 DROP TABLE floodplain_kinds;
http://dive4elements.wald.intevation.org