# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1391766843 -3600
# Node ID a67bd7744827d2a1f767a2e3764d32a0f2efb2c2
# Parent  869f54874c3c5002e85d2e51c856f66624f10e45
Schema correction following yesterday's brain failure.

diff -r 869f54874c3c -r a67bd7744827 backend/doc/schema/oracle.sql
--- 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,
diff -r 869f54874c3c -r a67bd7744827 backend/doc/schema/postgresql.sql
--- a/backend/doc/schema/postgresql.sql	Thu Feb 06 15:05:29 2014 +0100
+++ b/backend/doc/schema/postgresql.sql	Fri Feb 07 10:54:03 2014 +0100
@@ -12,7 +12,7 @@
 
 CREATE TABLE rivers (
     id              int PRIMARY KEY NOT NULL,
-    model_uuid      CHAR(37),
+    model_uuid      CHAR(36)        UNIQUE,
     official_number int8,
     name            VARCHAR(256)    NOT NULL UNIQUE,
     km_up           BOOLEAN         NOT NULL DEFAULT true,