Mercurial > dive4elements > river
annotate backend/doc/schema/oracle-drop-spatial.sql @ 6653:ca80f61370ab
Add some useful debug output.
With debug level info the datacage is so verbose that those
lines should not hurt but having a variable dump at hand
can be increadibly useful
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Wed, 24 Jul 2013 17:34:48 +0200 |
parents | 5aa05a7a34b7 |
children | 97145ec4e33c |
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 buildings_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
17 DROP TABLE buildings; |
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 = 'BUILDINGS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
19 DROP SEQUENCE BUILDINGS_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 fixpoints_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
22 DROP TABLE fixpoints; |
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 = 'FIXPOINTS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
24 DROP SEQUENCE FIXPOINTS_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 floodplain_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
27 DROP TABLE floodplain; |
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 = 'FLOODPLAIN'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
29 DROP SEQUENCE FLOODPLAIN_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 dem_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
32 DROP TABLE dem; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
33 DROP SEQUENCE DEM_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
34 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
35 DROP TRIGGER catchment_trigger; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
36 DROP TABLE catchment; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
37 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
|
38 DROP SEQUENCE CATCHMENT_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
39 |
5034
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
40 DROP TRIGGER hws_lines_trigger; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
41 DROP TABLE hws_lines; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES'; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
43 DROP SEQUENCE HWS_LINES_ID_SEQ; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
44 |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
45 DROP TRIGGER hws_points_trigger; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
46 DROP TABLE hws_points; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
47 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_POINTS'; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
48 DROP SEQUENCE HWS_POINTS_ID_SEQ; |
2854
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; |
5034
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
69 |
5409
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
70 DROP TRIGGER jetties_trigger; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
71 DROP TABLE jetties; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
72 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES'; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
73 DROP SEQUENCE JETTIES_ID_SEQ; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
74 |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
75 DROP TRIGGER flood_marks_trigger; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
76 DROP TABLE flood_marks; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
77 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS'; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
78 DROP SEQUENCE FLOOD_MARKS_ID_SEQ; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
79 |
5034
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
80 DROP TABLE hws_kinds; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
81 DROP TABLE sectie_kinds; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
82 DROP TABLE sobek_kinds; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
83 DROP TABLE fed_states; |
5146
d4fdd98a04f7
Add kind_id to river_axes table and add AxisKind object to model
Andre Heinecke <aheinecke@intevation.de>
parents:
5034
diff
changeset
|
84 DROP TABLE axis_kinds; |
5034
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
85 DROP TABLE boundary_kinds; |
5271
dac7723fb502
added missing lookup tables to drop-scripts
Tom Gottfried <tom@intevation.de>
parents:
5146
diff
changeset
|
86 DROP TABLE cross_section_track_kinds; |
dac7723fb502
added missing lookup tables to drop-scripts
Tom Gottfried <tom@intevation.de>
parents:
5146
diff
changeset
|
87 DROP TABLE floodplain_kinds; |
5408
91f5908c472a
Add building_kinds to drop script and fix syntax of buildings table
Andre Heinecke <aheinecke@intevation.de>
parents:
5271
diff
changeset
|
88 DROP TABLE building_kinds; |