Mercurial > dive4elements > river
annotate backend/doc/schema/oracle-drop-sinfo-uinfo.sql @ 9661:9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
localized vegetation type names by querying the database instead of translating by resource property,
detecting and cancelling the import of a second vegetation zone file for a river,
detecting, logging, cancelling in case of wrong column titles,
detecting, logging and ignoring lines with missing (color) values,
comparing vegetation zone name and class with the database and logging+ignoring in case of inconsistencies,
starting the most elevated zone with 0 instead of -1 overflow days
author | mschaefer |
---|---|
date | Mon, 23 Mar 2020 16:38:12 +0100 |
parents | 1f63e9d3b0ec |
children |
rev | line source |
---|---|
9019
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
1 SET AUTOCOMMIT ON; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
2 |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
3 DROP TABLE bed_mobility CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
4 DROP TABLE bed_mobility_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
5 DROP TABLE infrastructure CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
6 DROP TABLE infrastructure_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
7 DROP TABLE channel CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
8 DROP TABLE channel_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
9 DROP TABLE collision_type CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
10 DROP TABLE collision CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
11 DROP TABLE collision_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
12 DROP TABLE tkh CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
13 DROP TABLE tkh_column CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
14 DROP TABLE tkh_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
15 DROP TABLE depth_evolution CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
16 DROP TABLE depth_evolution_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
17 DROP TABLE daily_discharge CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
18 DROP TABLE daily_discharge_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
19 DROP TABLE salix CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
20 DROP TABLE salix_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
21 DROP TABLE salix_rank CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
22 DROP TABLE vegetation_type CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
23 DROP TABLE vegetation CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
24 DROP TABLE vegetation_zone CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
25 DROP TABLE flow_depth CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
26 DROP TABLE flow_depth_column CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
27 DROP TABLE flow_depth_values CASCADE CONSTRAINTS PURGE; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
28 |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
29 DROP SEQUENCE BED_MOBILITY_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
30 DROP SEQUENCE BED_MOBILITY_VALUES_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
31 DROP SEQUENCE INFRASTRUCTURE_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
32 DROP SEQUENCE INFRASTRUCTURE_VALUES_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
33 DROP SEQUENCE CHANNEL_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
34 DROP SEQUENCE CHANNEL_VALUES_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
35 DROP SEQUENCE COLLISION_TYPE_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
36 DROP SEQUENCE COLLISION_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
37 DROP SEQUENCE COLLISION_VALUES_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
38 DROP SEQUENCE TKH_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
39 DROP SEQUENCE TKH_COLUMN_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
40 DROP SEQUENCE TKH_VALUES_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
41 DROP SEQUENCE DEPTH_EVOLUTION_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
42 DROP SEQUENCE DEPTH_EVOLUTION_VALUES_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
43 DROP SEQUENCE DAILY_DISCHARGE_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
44 DROP SEQUENCE DAILY_DISCHARGE_VALUES_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
45 DROP SEQUENCE SALIX_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
46 DROP SEQUENCE SALIX_VALUES_ID_SEQ; |
9032
1f63e9d3b0ec
New columns for bed_height, tkh and depth_evolution, a few syntactic corrections for Oracle
mschaefer
parents:
9019
diff
changeset
|
47 --DROP SEQUENCE SALIX_RANK_ID_SEQ; |
1f63e9d3b0ec
New columns for bed_height, tkh and depth_evolution, a few syntactic corrections for Oracle
mschaefer
parents:
9019
diff
changeset
|
48 --DROP SEQUENCE VEGETATION_TYPE_ID_SEQ; |
9019
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
49 DROP SEQUENCE VEGETATION_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
50 DROP SEQUENCE VEGETATION_ZONE_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
51 DROP SEQUENCE FLOW_DEPTH_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
52 DROP SEQUENCE FLOW_DEPTH_COLUMN_ID_SEQ; |
5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
mschaefer
parents:
diff
changeset
|
53 DROP SEQUENCE FLOW_DEPTH_VALUES_ID_SEQ; |