diff backend/doc/schema/postgresql-minfo.sql @ 7352:c6825778de1f

Merged double-precision branch.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 16 Oct 2013 13:03:13 +0200
parents 63a24b4fbebf
children 5b5a2cc8210f
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-minfo.sql	Wed Oct 16 12:39:33 2013 +0200
+++ b/backend/doc/schema/postgresql-minfo.sql	Wed Oct 16 13:03:13 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
 );
@@ -247,7 +247,7 @@
     name    VARCHAR(64)    NOT NULL,
     lower   NUMERIC,
     upper   NUMERIC,
-    PRIMARY KEY (id),
+    PRIMARY KEY (id)
 );
 
 

http://dive4elements.wald.intevation.org