Mercurial > dive4elements > river
changeset 5426:6875a9f02097
SCHEMA CHANGE! Renamed columns in sq_relation and sq_relation_value.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Tue, 26 Mar 2013 13:56:08 +0100 |
| parents | a137cbab32a8 |
| children | 473edafe4cb1 |
| files | flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql |
| diffstat | 2 files changed, 26 insertions(+), 26 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Tue Mar 26 12:26:48 2013 +0100 +++ b/flys-backend/doc/schema/oracle-minfo.sql Tue Mar 26 13:56:08 2013 +0100 @@ -319,19 +319,19 @@ CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; CREATE TABLE sq_relation_value ( - id NUMBER(38,0) NOT NULL, - sq_relation_id NUMBER(38,0) NOT NULL, - m_station_id NUMBER(38,0) NOT NULL, - parameter VARCHAR(16) NOT NULL, - fraction VARCHAR(32) NOT NULL, - a NUMBER(38,20) NOT NULL, - b NUMBER(38,20) NOT NULL, - q_max NUMBER(38,20), - r_sq NUMBER(38,3), - n_tot NUMBER(38,0), - n_outl NUMBER(38,0), - cferguson NUMBER(38,20), - cduan NUMBER(38,20), + id NUMBER(38,0) NOT NULL, + sq_relation_id NUMBER(38,0) NOT NULL, + measurement_station_id NUMBER(38,0) NOT NULL, + parameter VARCHAR(16) NOT NULL, + fraction VARCHAR(32) NOT NULL, + a NUMBER(38,20) NOT NULL, + b NUMBER(38,20) NOT NULL, + qmax NUMBER(38,20), + rsq NUMBER(38,3), + ntot NUMBER(38,0), + noutl NUMBER(38,0), + cferguson NUMBER(38,20), + cduan NUMBER(38,20), PRIMARY KEY (id), CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id), CONSTRAINT fk_mstation_id FOREIGN KEY (m_station_id) REFERENCES measurement_station(id)
--- a/flys-backend/doc/schema/postgresql-minfo.sql Tue Mar 26 12:26:48 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-minfo.sql Tue Mar 26 13:56:08 2013 +0100 @@ -319,19 +319,19 @@ CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; CREATE TABLE sq_relation_value ( - id int NOT NULL, - sq_relation_id int NOT NULL, - m_station_id int NOT NULL, - parameter VARCHAR(16) NOT NULL, - fraction VARCHAR(32) NOT NULL, - a NUMERIC NOT NULL, - b NUMERIC NOT NULL, - q_max NUMERIC, - r_sq NUMERIC, - n_tot int, - n_outl int, - cferguson NUMERIC, - cduan NUMERIC, + id int NOT NULL, + sq_relation_id int NOT NULL, + measurement_station_id int NOT NULL, + parameter VARCHAR(16) NOT NULL, + fraction VARCHAR(32) NOT NULL, + a NUMERIC NOT NULL, + b NUMERIC NOT NULL, + qmax NUMERIC, + rsq NUMERIC, + ntot int, + noutl int, + cferguson NUMERIC, + cduan NUMERIC, PRIMARY KEY (id), CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) ON DELETE CASCADE, CONSTRAINT fk_mstation_id FOREIGN KEY (m_station_id) REFERENCES measurement_station(id)