Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-spatial.sql @ 5838:5aa05a7a34b7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rename modules to more fitting names.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 25 Apr 2013 15:23:37 +0200
parents flys-backend/doc/schema/oracle-drop-spatial.sql@8b29a94ebdd8
children 97145ec4e33c
comparison
equal deleted inserted replaced
5837:d9901a08d0a6 5838:5aa05a7a34b7
1 DROP TRIGGER river_axes_trigger;
2 DROP TABLE river_axes;
3 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
4 DROP SEQUENCE RIVER_AXES_ID_SEQ;
5
6 DROP TRIGGER river_axes_km_trigger;
7 DROP TABLE river_axes_km;
8 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
9 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
10
11 DROP TRIGGER cross_section_tracks_trigger;
12 DROP TABLE cross_section_tracks;
13 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
15
16 DROP TRIGGER buildings_trigger;
17 DROP TABLE buildings;
18 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
19 DROP SEQUENCE BUILDINGS_ID_SEQ;
20
21 DROP TRIGGER fixpoints_trigger;
22 DROP TABLE fixpoints;
23 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
24 DROP SEQUENCE FIXPOINTS_ID_SEQ;
25
26 DROP TRIGGER floodplain_trigger;
27 DROP TABLE floodplain;
28 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
29 DROP SEQUENCE FLOODPLAIN_ID_SEQ;
30
31 DROP TRIGGER dem_trigger;
32 DROP TABLE dem;
33 DROP SEQUENCE DEM_ID_SEQ;
34
35 DROP TRIGGER catchment_trigger;
36 DROP TABLE catchment;
37 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
38 DROP SEQUENCE CATCHMENT_ID_SEQ;
39
40 DROP TRIGGER hws_lines_trigger;
41 DROP TABLE hws_lines;
42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES';
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
50 DROP TRIGGER floodmaps_trigger;
51 DROP TABLE floodmaps;
52 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
53 DROP SEQUENCE FLOODMAPS_ID_SEQ;
54
55 DROP TRIGGER hydr_boundaries_trigger;
56 DROP TABLE hydr_boundaries;
57 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES';
58 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
59
60 DROP TRIGGER hydr_boundaries_poly_trigger;
61 DROP TABLE hydr_boundaries_poly;
62 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY';
63 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;
64
65 DROP TRIGGER gauge_location_trigger;
66 DROP TABLE gauge_location;
67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION';
68 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ;
69
70 DROP TRIGGER jetties_trigger;
71 DROP TABLE jetties;
72 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES';
73 DROP SEQUENCE JETTIES_ID_SEQ;
74
75 DROP TRIGGER flood_marks_trigger;
76 DROP TABLE flood_marks;
77 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS';
78 DROP SEQUENCE FLOOD_MARKS_ID_SEQ;
79
80 DROP TABLE hws_kinds;
81 DROP TABLE sectie_kinds;
82 DROP TABLE sobek_kinds;
83 DROP TABLE fed_states;
84 DROP TABLE axis_kinds;
85 DROP TABLE boundary_kinds;
86 DROP TABLE cross_section_track_kinds;
87 DROP TABLE floodplain_kinds;
88 DROP TABLE building_kinds;
http://dive4elements.wald.intevation.org