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

http://dive4elements.wald.intevation.org