Mercurial > dive4elements > river
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 );