Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 8415:ffbeffe2d266
SCHEMA CHANGE: 'comment' is not acceptable as column name for Oracle.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 15 Oct 2014 19:48:20 +0200 |
| parents | 17db08570637 |
| children | 3a0522f1a532 |
comparison
equal
deleted
inserted
replaced
| 8414:8e1c9ce1c7c6 | 8415:ffbeffe2d266 |
|---|---|
| 317 measurement_type VARCHAR(64) NOT NULL, | 317 measurement_type VARCHAR(64) NOT NULL, |
| 318 riverside VARCHAR(16), | 318 riverside VARCHAR(16), |
| 319 -- store name of reference gauges here too, as not all are in gauges | 319 -- store name of reference gauges here too, as not all are in gauges |
| 320 reference_gauge_name VARCHAR(64), | 320 reference_gauge_name VARCHAR(64), |
| 321 operator VARCHAR(64), | 321 operator VARCHAR(64), |
| 322 comment VARCHAR(512), | 322 commentary VARCHAR(512), |
| 323 PRIMARY KEY (id), | 323 PRIMARY KEY (id), |
| 324 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) | 324 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) |
| 325 REFERENCES ranges(id) ON DELETE CASCADE, | 325 REFERENCES ranges(id) ON DELETE CASCADE, |
| 326 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) | 326 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) |
| 327 REFERENCES gauges(id) ON DELETE CASCADE, | 327 REFERENCES gauges(id) ON DELETE CASCADE, |