Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle-drop-spatial.sql @ 4839:61ebb6fb2ac4
Fixed segments creation in calculation 4.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Wed, 23 Jan 2013 12:52:49 +0100 |
parents | 998f1a7dcfde |
children | 96d330bc40d0 |
rev | line source |
---|---|
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
1 DROP TRIGGER river_axes_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
2 DROP TABLE river_axes; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
3 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
4 DROP SEQUENCE RIVER_AXES_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
5 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
6 DROP TRIGGER river_axes_km_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
7 DROP TABLE river_axes_km; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
8 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
9 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
10 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
11 DROP TRIGGER cross_section_tracks_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
12 DROP TABLE cross_section_tracks; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
13 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
15 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
16 DROP TRIGGER lines_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
17 DROP TABLE lines; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
18 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
19 DROP SEQUENCE LINES_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
20 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
21 DROP TRIGGER buildings_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
22 DROP TABLE buildings; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
23 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
24 DROP SEQUENCE BUILDINGS_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
25 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
26 DROP TRIGGER fixpoints_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
27 DROP TABLE fixpoints; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
28 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
29 DROP SEQUENCE FIXPOINTS_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
30 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
31 DROP TRIGGER floodplain_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
32 DROP TABLE floodplain; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
33 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
34 DROP SEQUENCE FLOODPLAIN_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
35 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
36 DROP TRIGGER dem_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
37 DROP TABLE dem; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
38 DROP SEQUENCE DEM_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
39 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
40 DROP TRIGGER catchment_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
41 DROP TABLE catchment; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
43 DROP SEQUENCE CATCHMENT_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
44 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
45 DROP TRIGGER hws_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
46 DROP TABLE hws; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
47 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
48 DROP SEQUENCE HWS_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
49 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
50 DROP TRIGGER floodmaps_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
51 DROP TABLE floodmaps; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
52 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
53 DROP SEQUENCE FLOODMAPS_ID_SEQ; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
54 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
55 DROP TRIGGER hydr_boundaries_trigger; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
56 DROP TABLE hydr_boundaries; |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
57 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES'; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
58 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ; |
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
59 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
60 DROP TRIGGER hydr_boundaries_poly_trigger; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
61 DROP TABLE hydr_boundaries_poly; |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
62 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY'; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
63 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
64 |
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
65 DROP TRIGGER gauge_location_trigger; |
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
66 DROP TABLE gauge_location; |
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION'; |
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
68 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; |