Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-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 | f63b39799d2d |
| children | b79eb203032d |
comparison
equal
deleted
inserted
replaced
| 4522:a9753f717b3d | 4523:504cd5801785 |
|---|---|
| 137 id int NOT NULL, | 137 id int NOT NULL, |
| 138 sediment_density_id int NOT NULL, | 138 sediment_density_id int NOT NULL, |
| 139 station NUMERIC NOT NULL, | 139 station NUMERIC NOT NULL, |
| 140 density NUMERIC NOT NULL, | 140 density NUMERIC NOT NULL, |
| 141 description VARCHAR(256), | 141 description VARCHAR(256), |
| 142 year int, | |
| 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 |