changeset 6721:df402b3e0281

minfo-schema-change/issue1393: add kind column to sediment_yield table. To change existing databases, issue following sql command: ALTER TABLE sediment_yield ADD kind INT DEFAULT 0; For oracles it might look like ALTER TABLE sediment_yield ADD kind NUMBER(38,0) DEFAULT 0; .
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Wed, 31 Jul 2013 11:10:11 +0200
parents 1e2dfd91274d
children 078d56dffc8c
files backend/doc/schema/oracle-minfo.sql backend/doc/schema/postgresql-minfo.sql
diffstat 2 files changed, 2 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Wed Jul 31 11:07:48 2013 +0200
+++ b/backend/doc/schema/oracle-minfo.sql	Wed Jul 31 11:10:11 2013 +0200
@@ -260,6 +260,7 @@
     unit_id             NUMBER(38,0) NOT NULL,
     time_interval_id    NUMBER(38,0) NOT NULL,
     description         VARCHAR(256),
+    kind                NUMBER(38,0),
     PRIMARY KEY (id),
     CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE,
     CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),
--- a/backend/doc/schema/postgresql-minfo.sql	Wed Jul 31 11:07:48 2013 +0200
+++ b/backend/doc/schema/postgresql-minfo.sql	Wed Jul 31 11:10:11 2013 +0200
@@ -260,6 +260,7 @@
     unit_id             int NOT NULL,
     time_interval_id    int NOT NULL,
     description         VARCHAR(256),
+    kind                int,
     PRIMARY KEY (id),
     CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE,
     CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),

http://dive4elements.wald.intevation.org