# HG changeset patch
# User Raimund Renkert <rrenkert@intevation.de>
# Date 1352909994 -3600
# Node ID 504cd580178516374134d7641548285fd57a1d3a
# Parent  a9753f717b3dd27dc91118867129612f135a5f0f
Added new column 'year' to sediment density values in postgresql and oracle
schema.

diff -r a9753f717b3d -r 504cd5801785 flys-backend/doc/schema/oracle-minfo.sql
--- 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)
 );
diff -r a9753f717b3d -r 504cd5801785 flys-backend/doc/schema/postgresql-minfo.sql
--- 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)
 );