Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 4523:504cd5801785
Added new column 'year' to sediment density values in postgresql and oracle
schema.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Wed, 14 Nov 2012 17:19:54 +0100 |
| parents | fc32a4955087 |
| children | 8667f629d238 |
comparison
equal
deleted
inserted
replaced
| 4522:a9753f717b3d | 4523:504cd5801785 |
|---|---|
| 137 id NUMBER(38,0) NOT NULL, | 137 id NUMBER(38,0) NOT NULL, |
| 138 sediment_density_id NUMBER(38,0) NOT NULL, | 138 sediment_density_id NUMBER(38,0) NOT NULL, |
| 139 station NUMBER(38,2) NOT NULL, | 139 station NUMBER(38,2) NOT NULL, |
| 140 density NUMBER(38,2) NOT NULL, | 140 density NUMBER(38,2) NOT NULL, |
| 141 description VARCHAR(256), | 141 description VARCHAR(256), |
| 142 year NUMBER(38,0), | |
| 142 PRIMARY KEY(id), | 143 PRIMARY KEY(id), |
| 143 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) | 144 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) |
| 144 ); | 145 ); |
| 145 | 146 |
| 146 | 147 |