Mercurial > dive4elements > river
changeset 6871:5ce6a3d7d632 double-precision
Undo misguided schema change from r5207
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 19 Aug 2013 17:29:52 +0200 |
| parents | 3aff1b00618a |
| children | f1aeb6a60380 |
| files | backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Wed Aug 14 12:54:00 2013 +0200 +++ b/backend/doc/schema/oracle.sql Mon Aug 19 17:29:52 2013 +0200 @@ -124,7 +124,7 @@ name VARCHAR2(255) NOT NULL, station NUMBER(38,2) NOT NULL, official_number NUMBER(38,0), - range_id NUMBER(38,0) NOT NULL, + range_id NUMBER(38,0), -- TODO: remove river id here because range_id references river already river_id NUMBER(38,0) NOT NULL, PRIMARY KEY (id),
--- a/backend/doc/schema/postgresql.sql Wed Aug 14 12:54:00 2013 +0200 +++ b/backend/doc/schema/postgresql.sql Mon Aug 19 17:29:52 2013 +0200 @@ -91,7 +91,7 @@ -- Pegelnullpunkt datum NUMERIC NOT NULL, -- Streckengueltigkeit - range_id int NOT NULL REFERENCES ranges (id) ON DELETE CASCADE, + range_id int REFERENCES ranges (id) ON DELETE CASCADE, UNIQUE (name, river_id), UNIQUE (official_number, river_id),