Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-drop-sinfo-uinfo.sql @ 9019:5974bba60e4e
SQL script with table and sequence drops added for reversion of the S-INFO/U-INFO create script
| author | mschaefer |
|---|---|
| date | Mon, 23 Apr 2018 15:24:43 +0200 |
| parents | |
| children | 1f63e9d3b0ec |
comparison
equal
deleted
inserted
replaced
| 9018:aab0c2730a25 | 9019:5974bba60e4e |
|---|---|
| 1 SET AUTOCOMMIT ON; | |
| 2 | |
| 3 DROP TABLE bed_mobility CASCADE CONSTRAINTS PURGE; | |
| 4 DROP TABLE bed_mobility_values CASCADE CONSTRAINTS PURGE; | |
| 5 DROP TABLE infrastructure CASCADE CONSTRAINTS PURGE; | |
| 6 DROP TABLE infrastructure_values CASCADE CONSTRAINTS PURGE; | |
| 7 DROP TABLE channel CASCADE CONSTRAINTS PURGE; | |
| 8 DROP TABLE channel_values CASCADE CONSTRAINTS PURGE; | |
| 9 DROP TABLE collision_type CASCADE CONSTRAINTS PURGE; | |
| 10 DROP TABLE collision CASCADE CONSTRAINTS PURGE; | |
| 11 DROP TABLE collision_values CASCADE CONSTRAINTS PURGE; | |
| 12 DROP TABLE tkh CASCADE CONSTRAINTS PURGE; | |
| 13 DROP TABLE tkh_column CASCADE CONSTRAINTS PURGE; | |
| 14 DROP TABLE tkh_values CASCADE CONSTRAINTS PURGE; | |
| 15 DROP TABLE depth_evolution CASCADE CONSTRAINTS PURGE; | |
| 16 DROP TABLE depth_evolution_values CASCADE CONSTRAINTS PURGE; | |
| 17 DROP TABLE daily_discharge CASCADE CONSTRAINTS PURGE; | |
| 18 DROP TABLE daily_discharge_values CASCADE CONSTRAINTS PURGE; | |
| 19 DROP TABLE salix CASCADE CONSTRAINTS PURGE; | |
| 20 DROP TABLE salix_values CASCADE CONSTRAINTS PURGE; | |
| 21 DROP TABLE salix_rank CASCADE CONSTRAINTS PURGE; | |
| 22 DROP TABLE vegetation_type CASCADE CONSTRAINTS PURGE; | |
| 23 DROP TABLE vegetation CASCADE CONSTRAINTS PURGE; | |
| 24 DROP TABLE vegetation_zone CASCADE CONSTRAINTS PURGE; | |
| 25 DROP TABLE flow_depth CASCADE CONSTRAINTS PURGE; | |
| 26 DROP TABLE flow_depth_column CASCADE CONSTRAINTS PURGE; | |
| 27 DROP TABLE flow_depth_values CASCADE CONSTRAINTS PURGE; | |
| 28 | |
| 29 DROP SEQUENCE BED_MOBILITY_ID_SEQ; | |
| 30 DROP SEQUENCE BED_MOBILITY_VALUES_ID_SEQ; | |
| 31 DROP SEQUENCE INFRASTRUCTURE_ID_SEQ; | |
| 32 DROP SEQUENCE INFRASTRUCTURE_VALUES_ID_SEQ; | |
| 33 DROP SEQUENCE CHANNEL_ID_SEQ; | |
| 34 DROP SEQUENCE CHANNEL_VALUES_ID_SEQ; | |
| 35 DROP SEQUENCE COLLISION_TYPE_ID_SEQ; | |
| 36 DROP SEQUENCE COLLISION_ID_SEQ; | |
| 37 DROP SEQUENCE COLLISION_VALUES_ID_SEQ; | |
| 38 DROP SEQUENCE TKH_ID_SEQ; | |
| 39 DROP SEQUENCE TKH_COLUMN_ID_SEQ; | |
| 40 DROP SEQUENCE TKH_VALUES_ID_SEQ; | |
| 41 DROP SEQUENCE DEPTH_EVOLUTION_ID_SEQ; | |
| 42 DROP SEQUENCE DEPTH_EVOLUTION_VALUES_ID_SEQ; | |
| 43 DROP SEQUENCE DAILY_DISCHARGE_ID_SEQ; | |
| 44 DROP SEQUENCE DAILY_DISCHARGE_VALUES_ID_SEQ; | |
| 45 DROP SEQUENCE SALIX_ID_SEQ; | |
| 46 DROP SEQUENCE SALIX_VALUES_ID_SEQ; | |
| 47 DROP SEQUENCE SALIX_RANK_ID_SEQ; | |
| 48 DROP SEQUENCE VEGETATION_TYPE_ID_SEQ; | |
| 49 DROP SEQUENCE VEGETATION_ID_SEQ; | |
| 50 DROP SEQUENCE VEGETATION_ZONE_ID_SEQ; | |
| 51 DROP SEQUENCE FLOW_DEPTH_ID_SEQ; | |
| 52 DROP SEQUENCE FLOW_DEPTH_COLUMN_ID_SEQ; | |
| 53 DROP SEQUENCE FLOW_DEPTH_VALUES_ID_SEQ; |