Mercurial > dive4elements > river
diff backend/doc/schema/oracle.sql @ 8658:3531f0cee5e1
Whitespace-cleanup schema files.
author | "Tom Gottfried <tom@intevation.de>" |
---|---|
date | Thu, 02 Apr 2015 17:17:51 +0200 |
parents | b8c6cb36607e |
children | cfafe5764509 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Thu Apr 02 15:48:48 2015 +0200 +++ b/backend/doc/schema/oracle.sql Thu Apr 02 17:17:51 2015 +0200 @@ -2,7 +2,7 @@ CREATE SEQUENCE ANNOTATION_TYPES_ID_SEQ; CREATE TABLE annotation_types ( - id NUMBER(38,0) NOT NULL, + id NUMBER(38,0) NOT NULL, name VARCHAR2(255) NOT NULL UNIQUE, PRIMARY KEY (id) ); @@ -22,12 +22,12 @@ ); --- ATTRIBUTES +-- ATTRIBUTES CREATE SEQUENCE ATTRIBUTES_ID_SEQ; CREATE TABLE attributes ( - id NUMBER(38,0) NOT NULL, - value VARCHAR2(255) UNIQUE, + id NUMBER(38,0) NOT NULL, + value VARCHAR2(255) UNIQUE, primary key (id) ); -- value can not be NOT NULL in Oracle: @@ -39,7 +39,7 @@ CREATE TABLE cross_section_lines ( id NUMBER(38,0) NOT NULL, km NUMBER(38,5) NOT NULL, - cross_section_id NUMBER(38,0) NOT NULL, + cross_section_id NUMBER(38,0) NOT NULL, PRIMARY KEY (id), UNIQUE (km, cross_section_id) ); @@ -120,7 +120,7 @@ CREATE TABLE gauges ( id NUMBER(38,0) NOT NULL, aeo NUMBER(38,2) NOT NULL, - datum NUMBER(38,2) NOT NULL, + datum NUMBER(38,2) NOT NULL, name VARCHAR2(255) NOT NULL, station NUMBER(38,4) NOT NULL, official_number NUMBER(38,0), @@ -276,7 +276,7 @@ CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; CREATE TABLE time_intervals ( - id NUMBER(38,0) NOT NULL, + id NUMBER(38,0) NOT NULL, start_time TIMESTAMP NOT NULL, stop_time TIMESTAMP, PRIMARY KEY (id), @@ -429,9 +429,9 @@ -- VIEWS CREATE VIEW wst_value_table AS - SELECT + SELECT wcv.position AS position, - w, + w, q, wc.position AS column_pos, w.id AS wst_id @@ -451,9 +451,9 @@ -- view to select the w values of a WST CREATE VIEW wst_w_values AS - SELECT wcv.position AS km, - wcv.w AS w, - wc.position AS column_pos, + SELECT wcv.position AS km, + wcv.w AS w, + wc.position AS column_pos, w.id AS wst_id FROM wst_column_values wcv JOIN wst_columns wc ON wcv.wst_column_id = wc.id @@ -463,8 +463,8 @@ -- view to select the q values of a WST CREATE VIEW wst_q_values AS SELECT wc.position AS column_pos, - wqr.q AS q, - r.a AS a, + wqr.q AS q, + r.a AS a, r.b AS b, wc.wst_id AS wst_id FROM wst_column_q_ranges wcqr