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
line wrap: on
line diff
--- 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,

http://dive4elements.wald.intevation.org