Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-drop-sinfo-uinfo.sql @ 9657:a79881a892c9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Importer (s/u-info) extensions: depth-evolution: corrected directory name Bezug_aktueller_GlW, detecting and logging of wrong units, then cancelling, various checks of the plausibility of the meta data year values and cancelling in case of errors, detecting and logging missing change values, skipping those lines
author mschaefer
date Mon, 23 Mar 2020 15:26:50 +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;
http://dive4elements.wald.intevation.org