Mercurial > dive4elements > river
changeset 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 | a9753f717b3d |
| children | be9e28cff0c4 |
| files | flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql |
| diffstat | 2 files changed, 2 insertions(+), 0 deletions(-) [+] |
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) );
--- 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) );