diff backend/doc/schema/oracle-drop.sql @ 6300:0711ce5ca701

Backend: Modified schema for a better model of official lines.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 12 Jun 2013 16:36:34 +0200
parents 5aa05a7a34b7
children 97145ec4e33c
line wrap: on
line diff
--- a/backend/doc/schema/oracle-drop.sql	Wed Jun 12 14:28:37 2013 +0200
+++ b/backend/doc/schema/oracle-drop.sql	Wed Jun 12 16:36:34 2013 +0200
@@ -57,6 +57,7 @@
 DROP TABLE wst_column_values;
 DROP TABLE wst_columns;
 DROP TABLE wst_q_ranges;
+DROP TABLE official_lines;
 DROP TABLE wsts;
 DROP TABLE wst_kinds;
 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
@@ -86,11 +87,9 @@
 DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
 DROP SEQUENCE WST_COLUMNS_ID_SEQ;
 DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
+DROP SEQUENCE OFFICIAL_LINES_ID_SEQ;
 DROP SEQUENCE WSTS_ID_SEQ;
 DROP VIEW wst_value_table;
 DROP VIEW wst_w_values ;
 DROP VIEW wst_q_values;
-DROP VIEW official_lines;
-DROP VIEW q_main_values;
-DROP VIEW official_q_values;
 DROP VIEW wst_ranges;

http://dive4elements.wald.intevation.org