changeset 6369:7fb0e755e4fa double-precision

Minimal schema change: allow longer names in discharge zones
author Tom Gottfried <tom.gottfried@intevation.de>
date Tue, 18 Jun 2013 19:32:31 +0200
parents cc21c197d204
children 55a2f9e0d6ab
files backend/doc/schema/oracle-minfo.sql backend/doc/schema/postgresql-minfo.sql
diffstat 2 files changed, 4 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Tue Jun 18 16:05:10 2013 +0200
+++ b/backend/doc/schema/oracle-minfo.sql	Tue Jun 18 19:32:31 2013 +0200
@@ -179,8 +179,8 @@
     river_id                NUMBER(38,0) NOT NULL,
     gauge_name              VARCHAR(64)  NOT NULL, -- this is not very proper, but there are gauges with no db instance
     value                   NUMBER(38,3) NOT NULL,
-    lower_discharge         VARCHAR(16)  NOT NULL,
-    upper_discharge         VARCHAR(16),
+    lower_discharge         VARCHAR(64)  NOT NULL,
+    upper_discharge         VARCHAR(64),
     PRIMARY KEY(id),
     CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE
 );
--- a/backend/doc/schema/postgresql-minfo.sql	Tue Jun 18 16:05:10 2013 +0200
+++ b/backend/doc/schema/postgresql-minfo.sql	Tue Jun 18 19:32:31 2013 +0200
@@ -179,8 +179,8 @@
     river_id                int NOT NULL,
     gauge_name              VARCHAR(64)  NOT NULL, -- this is not very proper, but there are gauges with no db instance
     value                   NUMERIC NOT NULL,
-    lower_discharge         VARCHAR(16)  NOT NULL,
-    upper_discharge         VARCHAR(16),
+    lower_discharge         VARCHAR(64)  NOT NULL,
+    upper_discharge         VARCHAR(64),
     PRIMARY KEY(id),
     CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE
 );

http://dive4elements.wald.intevation.org