Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-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 VARCHAR2(64 CHAR) NOT NULL, | 317 measurement_type VARCHAR2(64 CHAR) NOT NULL, |
318 riverside VARCHAR2(16 CHAR), | 318 riverside VARCHAR2(16 CHAR), |
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 VARCHAR2(64 CHAR), | 320 reference_gauge_name VARCHAR2(64 CHAR), |
321 operator VARCHAR2(64 CHAR), | 321 operator VARCHAR2(64 CHAR), |
322 comment VARCHAR2(512 CHAR), | 322 commentary VARCHAR2(512 CHAR), |
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, |