Mercurial > dive4elements > river

diff 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
--- a/backend/doc/schema/oracle.sql	Thu Sep 12 19:15:07 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Thu Sep 12 21:12:59 2013 +0200
@@ -251,7 +251,8 @@
     b                   NUMBER(38,10),
     river_id            NUMBER(38,0),
     UNIQUE (river_id, a, b),
-    PRIMARY KEY (id)
+    PRIMARY KEY (id),
+    CHECK (a < b)
 );
author	Tom Gottfried <tom.gottfried@intevation.de>
date	Thu, 12 Sep 2013 21:12:59 +0200
parents	5ce6a3d7d632
children	28748bb1b676