Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-minfo.sql @ 4523:504cd5801785
Added new column 'year' to sediment density values in postgresql and oracle
schema.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Wed, 14 Nov 2012 17:19:54 +0100 |
| parents | f63b39799d2d |
| children | b79eb203032d |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-minfo.sql Wed Nov 14 17:18:44 2012 +0100 +++ b/flys-backend/doc/schema/postgresql-minfo.sql Wed Nov 14 17:19:54 2012 +0100 @@ -139,6 +139,7 @@ station NUMERIC NOT NULL, density NUMERIC NOT NULL, description VARCHAR(256), + year int, PRIMARY KEY(id), CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) );