Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-drop-spatial.sql @ 6048:caf9d989bd84

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix waterlevel classes and change defaults for them. If to is 0 then we create a class that goes to 9999 If step is 0 then we only have a single step >= 0 The defaults are now from 0, to 2m with a step of 0.5
author Andre Heinecke <aheinecke@intevation.de>
date Fri, 17 May 2013 17:56:20 +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;
http://dive4elements.wald.intevation.org