Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
362:2c58906649be 363:45d4399f6c15
38 38
39 -- Namespace not to be accessed directly by any user 39 -- Namespace not to be accessed directly by any user
40 CREATE SCHEMA internal 40 CREATE SCHEMA internal
41 -- Profile data are only accessible via the view users.list_users. 41 -- Profile data are only accessible via the view users.list_users.
42 CREATE TABLE user_profiles ( 42 CREATE TABLE user_profiles (
43 username varchar PRIMARY KEY, 43 username varchar PRIMARY KEY CHECK(octet_length(username) <= 63),
44 -- keep username length compatible with role identifier
44 map_extent box2d NOT NULL, 45 map_extent box2d NOT NULL,
45 email_address varchar NOT NULL 46 email_address varchar NOT NULL
46 ) 47 )
47 -- Columns referencing user-visible schemas added below. 48 -- Columns referencing user-visible schemas added below.
48 ; 49 ;