Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-minfo.sql @ 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 | 2d16f4a0bdcc |
| children | c14e17dabf39 |
line wrap: on
line diff
--- 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),