Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 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 | 63a24b4fbebf |
| children | dddf633fec05 |
comparison
equal
deleted
inserted
replaced
| 6825:3aff1b00618a | 6871:5ce6a3d7d632 |
|---|---|
| 89 official_number int8, | 89 official_number int8, |
| 90 | 90 |
| 91 -- Pegelnullpunkt | 91 -- Pegelnullpunkt |
| 92 datum NUMERIC NOT NULL, | 92 datum NUMERIC NOT NULL, |
| 93 -- Streckengueltigkeit | 93 -- Streckengueltigkeit |
| 94 range_id int NOT NULL REFERENCES ranges (id) ON DELETE CASCADE, | 94 range_id int REFERENCES ranges (id) ON DELETE CASCADE, |
| 95 | 95 |
| 96 UNIQUE (name, river_id), | 96 UNIQUE (name, river_id), |
| 97 UNIQUE (official_number, river_id), | 97 UNIQUE (official_number, river_id), |
| 98 UNIQUE (river_id, station) | 98 UNIQUE (river_id, station) |
| 99 ); | 99 ); |