changeset 5455:45c5b8b08ffd

Schema Change: use parameter instead of fraction in sq_relation_value
author Tom Gottfried <tom.gottfried@intevation.de>
date Wed, 27 Mar 2013 12:45:52 +0100
parents 662bcb3bdfd7
children e47c4e9b050e
files flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 12:23:41 2013 +0100
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 12:45:52 2013 +0100
@@ -321,7 +321,7 @@
     id                       NUMBER(38,0) NOT NULL,
     sq_relation_id           NUMBER(38,0) NOT NULL,
     measurement_station_id   NUMBER(38,0) NOT NULL,
-    fraction                 VARCHAR(32)  NOT NULL,
+    parameter                VARCHAR(1) NOT NULL,
     a                        NUMBER(38,20) NOT NULL,
     b                        NUMBER(38,20) NOT NULL,
     qmax                     NUMBER(38,20),
--- a/flys-backend/doc/schema/postgresql-minfo.sql	Wed Mar 27 12:23:41 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-minfo.sql	Wed Mar 27 12:45:52 2013 +0100
@@ -321,7 +321,7 @@
     id                     int NOT NULL,
     sq_relation_id         int NOT NULL,
     measurement_station_id int NOT NULL,
-    fraction               VARCHAR(32)  NOT NULL,
+    parameter              VARCHAR(1) NOT NULL,
     a                      NUMERIC NOT NULL,
     b                      NUMERIC NOT NULL,
     qmax                   NUMERIC,

http://dive4elements.wald.intevation.org