Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 6720:1e2dfd91274d | 6721:df402b3e0281 |
|---|---|
| 258 river_id int NOT NULL, | 258 river_id int NOT NULL, |
| 259 grain_fraction_id int, | 259 grain_fraction_id int, |
| 260 unit_id int NOT NULL, | 260 unit_id int NOT NULL, |
| 261 time_interval_id int NOT NULL, | 261 time_interval_id int NOT NULL, |
| 262 description VARCHAR(256), | 262 description VARCHAR(256), |
| 263 kind int, | |
| 263 PRIMARY KEY (id), | 264 PRIMARY KEY (id), |
| 264 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, | 265 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, |
| 265 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), | 266 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), |
| 266 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), | 267 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), |
| 267 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) | 268 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) |