Mercurial > dive4elements > river

diff backend/doc/schema/postgresql.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/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,
author	Tom Gottfried <tom@intevation.de>
date	Fri, 07 Feb 2014 10:54:03 +0100
parents	69c8d33a05e8
children	b8c6cb36607e