Mercurial > dive4elements > river

diff backend/doc/schema/oracle.sql @ 7743:a67bd7744827
Schema correction following yesterday's brain failure.
author: Tom Gottfried <tom@intevation.de>
date: Fri, 07 Feb 2014 10:54:03 +0100
parents: 69c8d33a05e8
children: b8c6cb36607e
--- a/backend/doc/schema/oracle.sql	Thu Feb 06 15:05:29 2014 +0100
+++ b/backend/doc/schema/oracle.sql	Fri Feb 07 10:54:03 2014 +0100
@@ -262,7 +262,7 @@
 
 CREATE TABLE rivers (
     id                  NUMBER(38,0) NOT NULL,
-    model_uuid          CHAR(37 CHAR),
+    model_uuid          CHAR(36 CHAR) UNIQUE,
     official_number     NUMBER(38,0),
     km_up               NUMBER(38,0) DEFAULT 0 NOT NULL,
     name                VARCHAR2(255) NOT NULL UNIQUE,
author	Tom Gottfried <tom@intevation.de>
date	Fri, 07 Feb 2014 10:54:03 +0100
parents	69c8d33a05e8
children	b8c6cb36607e