Mercurial > gemma

diff schema/gemma.sql @ 363:45d4399f6c15

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merge
author Thomas Junk <thomas.junk@intevation.de>
date Wed, 08 Aug 2018 18:14:31 +0200
parents f5087cebc740
children 78588014ad0a
line wrap: on
line diff
--- a/schema/gemma.sql	Wed Aug 08 18:14:16 2018 +0200
+++ b/schema/gemma.sql	Wed Aug 08 18:14:31 2018 +0200
@@ -40,7 +40,8 @@
 CREATE SCHEMA internal
     -- Profile data are only accessible via the view users.list_users.
     CREATE TABLE user_profiles (
-        username varchar PRIMARY KEY,
+        username varchar PRIMARY KEY CHECK(octet_length(username) <= 63),
+        -- keep username length compatible with role identifier
         map_extent box2d NOT NULL,
         email_address varchar NOT NULL
     )