Mercurial > dive4elements > river
changeset 8658:3531f0cee5e1
Whitespace-cleanup schema files.
| author | "Tom Gottfried <tom@intevation.de>" |
|---|---|
| date | Thu, 02 Apr 2015 17:17:51 +0200 |
| parents | 4054c7fce43e |
| children | af415396d9ca |
| files | backend/doc/schema/oracle-minfo.sql backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql |
| diffstat | 3 files changed, 22 insertions(+), 21 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql Thu Apr 02 15:48:48 2015 +0200 +++ b/backend/doc/schema/oracle-minfo.sql Thu Apr 02 17:17:51 2015 +0200 @@ -348,7 +348,7 @@ REFERENCES sediment_load_kinds(id), CONSTRAINT fk_sl_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), - CONSTRAINT fk_sl_time_interval_id FOREIGN KEY (time_interval_id) + CONSTRAINT fk_sl_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id), CONSTRAINT fk_sl_sq_time_interval_id FOREIGN KEY (sq_time_interval_id) REFERENCES time_intervals(id)
--- 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
--- a/backend/doc/schema/postgresql.sql Thu Apr 02 15:48:48 2015 +0200 +++ b/backend/doc/schema/postgresql.sql Thu Apr 02 17:17:51 2015 +0200 @@ -257,9 +257,9 @@ ); 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 @@ -279,9 +279,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 @@ -291,8 +291,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