Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 467:c8c09e31cdb8
Added new column 'kind' in discharge tables and wst to distinguish between different types.
flys-backend/trunk@1703 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Apr 2011 10:31:15 +0000 |
| parents | 0f0b98ef9b04 |
| children | f4afea9b7537 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Fri Apr 15 09:49:21 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Fri Apr 15 10:31:15 2011 +0000 @@ -114,7 +114,7 @@ CREATE TABLE discharge_tables ( id int PRIMARY KEY NOT NULL, gauge_id int NOT NULL REFERENCES gauges(id), - + kind int NOT NULL DEFAULT 0 time_interval_id int REFERENCES time_intervals(id), -- TODO: better checks @@ -140,6 +140,7 @@ id int PRIMARY KEY NOT NULL, river_id int NOT NULL REFERENCES rivers(id), description VARCHAR(256) NOT NULL, + kind int NOT NULL DEFAULT 0 -- TODO: more meta infos UNIQUE (river_id, description) );