Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-drop-sinfo-uinfo.sql @ 9032:1f63e9d3b0ec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
New columns for bed_height, tkh and depth_evolution, a few syntactic corrections for Oracle
author mschaefer
date Fri, 27 Apr 2018 17:35:12 +0200
parents 5974bba60e4e
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