Mercurial > dive4elements > river
changeset 6045:2d16f4a0bdcc
Schema change: there is only one bed height per station at a given point in time
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 16 May 2013 18:03:39 +0200 |
| parents | d12f920bbf00 |
| children | 4493ef20d357 |
| files | backend/doc/schema/oracle-minfo.sql backend/doc/schema/postgresql-minfo.sql |
| diffstat | 2 files changed, 2 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql Thu May 16 16:14:28 2013 +0200 +++ b/backend/doc/schema/oracle-minfo.sql Thu May 16 18:03:39 2013 +0200 @@ -92,6 +92,7 @@ sounding_width NUMBER(38,2), width NUMBER(38,2), PRIMARY KEY(id), + UNIQUE (station, bed_height_single_id), CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE );
--- a/backend/doc/schema/postgresql-minfo.sql Thu May 16 16:14:28 2013 +0200 +++ b/backend/doc/schema/postgresql-minfo.sql Thu May 16 18:03:39 2013 +0200 @@ -92,6 +92,7 @@ sounding_width NUMERIC, width NUMERIC, PRIMARY KEY(id), + UNIQUE (station, bed_height_single_id), CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE );