Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-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 | fc32a4955087 |
| children | 8667f629d238 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Nov 14 17:18:44 2012 +0100 +++ b/flys-backend/doc/schema/oracle-minfo.sql Wed Nov 14 17:19:54 2012 +0100 @@ -139,6 +139,7 @@ station NUMBER(38,2) NOT NULL, density NUMBER(38,2) NOT NULL, description VARCHAR(256), + year NUMBER(38,0), PRIMARY KEY(id), CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) );