Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-spatial.sql @ 2862:998f1a7dcfde

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
New shape importers and schema modifications. flys-backend/trunk@4345 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 04 May 2012 06:58:00 +0000
parents b0132e1b9719
children 96d330bc40d0
comparison
equal deleted inserted replaced
2861:b0132e1b9719 2862:998f1a7dcfde
1 DROP TRIGGER river_axes_trigger;
1 DROP TABLE river_axes; 2 DROP TABLE river_axes;
2 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES'; 3 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
3 DROP TRIGGER river_axes_trigger;
4 DROP SEQUENCE RIVER_AXES_ID_SEQ; 4 DROP SEQUENCE RIVER_AXES_ID_SEQ;
5 5
6 DROP TRIGGER river_axes_km_trigger;
6 DROP TABLE river_axes_km; 7 DROP TABLE river_axes_km;
7 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM'; 8 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
8 DROP TRIGGER river_axes_km_trigger;
9 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; 9 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
10 10
11 DROP TRIGGER cross_section_tracks_trigger;
11 DROP TABLE cross_section_tracks; 12 DROP TABLE cross_section_tracks;
12 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';
13 DROP TRIGGER cross_section_tracks_trigger;
14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; 14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
15 15
16 DROP TRIGGER lines_trigger;
16 DROP TABLE lines; 17 DROP TABLE lines;
17 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES'; 18 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
18 DROP TRIGGER lines_trigger;
19 DROP SEQUENCE LINES_ID_SEQ; 19 DROP SEQUENCE LINES_ID_SEQ;
20 20
21 DROP TRIGGER buildings_trigger;
21 DROP TABLE buildings; 22 DROP TABLE buildings;
22 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS'; 23 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
23 DROP TRIGGER buildings_trigger;
24 DROP SEQUENCE BUILDINGS_ID_SEQ; 24 DROP SEQUENCE BUILDINGS_ID_SEQ;
25 25
26 DROP TRIGGER fixpoints_trigger;
26 DROP TABLE fixpoints; 27 DROP TABLE fixpoints;
27 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS'; 28 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
28 DROP TRIGGER fixpoints_trigger;
29 DROP SEQUENCE FIXPOINTS_ID_SEQ; 29 DROP SEQUENCE FIXPOINTS_ID_SEQ;
30 30
31 DROP TRIGGER floodplain_trigger;
31 DROP TABLE floodplain; 32 DROP TABLE floodplain;
32 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN'; 33 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
33 DROP TRIGGER floodplain_trigger;
34 DROP SEQUENCE FLOODPLAIN_ID_SEQ; 34 DROP SEQUENCE FLOODPLAIN_ID_SEQ;
35 35
36 DROP TRIGGER dem_trigger;
36 DROP TABLE dem; 37 DROP TABLE dem;
37 DROP TRIGGER dem_trigger;
38 DROP SEQUENCE DEM_ID_SEQ; 38 DROP SEQUENCE DEM_ID_SEQ;
39 39
40 DROP TRIGGER catchment_trigger;
40 DROP TABLE catchment; 41 DROP TABLE catchment;
41 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT'; 42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
42 DROP TRIGGER catchment_trigger;
43 DROP SEQUENCE CATCHMENT_ID_SEQ; 43 DROP SEQUENCE CATCHMENT_ID_SEQ;
44 44
45 DROP TRIGGER hws_trigger;
45 DROP TABLE hws; 46 DROP TABLE hws;
46 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS'; 47 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS';
47 DROP TRIGGER hws_trigger;
48 DROP SEQUENCE HWS_ID_SEQ; 48 DROP SEQUENCE HWS_ID_SEQ;
49 49
50 DROP TRIGGER floodmaps_trigger;
50 DROP TABLE floodmaps; 51 DROP TABLE floodmaps;
51 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS'; 52 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
52 DROP TRIGGER floodmaps_trigger;
53 DROP SEQUENCE FLOODMAPS_ID_SEQ; 53 DROP SEQUENCE FLOODMAPS_ID_SEQ;
54 54
55 DROP TRIGGER hydr_boundaries_trigger;
55 DROP TABLE hydr_boundaries; 56 DROP TABLE hydr_boundaries;
56 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'hydr_boundaries'; 57 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES';
57 DROP TRIGGER hydr_boundaries_trigger;
58 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ; 58 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
59 59
60 DROP TRIGGER hydr_boundaries_poly_trigger;
60 DROP TABLE hydr_boundaries_poly; 61 DROP TABLE hydr_boundaries_poly;
61 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'hydr_boundaries_poly'; 62 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY';
62 DROP TRIGGER hydr_boundaries_poly_trigger;
63 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; 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;
http://dive4elements.wald.intevation.org