Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.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 | 28748bb1b676 |
comparison
equal
deleted
inserted
replaced
| 7004:bb5bd48b80f6 | 7005:dddf633fec05 |
|---|---|
| 249 id NUMBER(38,0) NOT NULL, | 249 id NUMBER(38,0) NOT NULL, |
| 250 a NUMBER(38,10) NOT NULL, | 250 a NUMBER(38,10) NOT NULL, |
| 251 b NUMBER(38,10), | 251 b NUMBER(38,10), |
| 252 river_id NUMBER(38,0), | 252 river_id NUMBER(38,0), |
| 253 UNIQUE (river_id, a, b), | 253 UNIQUE (river_id, a, b), |
| 254 PRIMARY KEY (id) | 254 PRIMARY KEY (id), |
| 255 CHECK (a < b) | |
| 255 ); | 256 ); |
| 256 | 257 |
| 257 | 258 |
| 258 | 259 |
| 259 -- RIVERS | 260 -- RIVERS |