Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 7005:dddf633fec05 double-precision
SCHEMA CHANGE: a < b now enforced on ranges.
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Thu, 12 Sep 2013 21:12:59 +0200 |
| parents | 5ce6a3d7d632 |
| children | 44a9233c62eb |
comparison
equal
deleted
inserted
replaced
| 7004:bb5bd48b80f6 | 7005:dddf633fec05 |
|---|---|
| 32 CREATE TABLE ranges ( | 32 CREATE TABLE ranges ( |
| 33 id int PRIMARY KEY NOT NULL, | 33 id int PRIMARY KEY NOT NULL, |
| 34 river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, | 34 river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, |
| 35 a NUMERIC NOT NULL, | 35 a NUMERIC NOT NULL, |
| 36 b NUMERIC, | 36 b NUMERIC, |
| 37 UNIQUE (river_id, a, b) | 37 UNIQUE (river_id, a, b), |
| 38 CHECK (a < b) | |
| 38 ); | 39 ); |
| 39 | 40 |
| 40 | 41 |
| 41 -- Lage 'links', 'rechts', etc. | 42 -- Lage 'links', 'rechts', etc. |
| 42 CREATE SEQUENCE POSITIONS_ID_SEQ; | 43 CREATE SEQUENCE POSITIONS_ID_SEQ; |