Mercurial > gemma

comparison schema/gemma.sql @ 4728:bfbdcf67ae55 stack-polygons

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into stack-polygons branch.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 17 Oct 2019 22:37:04 +0200
parents baabc2b2f094
children 2440d2f86f4e
comparison
equal deleted inserted replaced
4727:1d48be66ce69 4728:bfbdcf67ae55
348 348
349 -- Namespace not to be accessed directly by any user 349 -- Namespace not to be accessed directly by any user
350 CREATE SCHEMA internal 350 CREATE SCHEMA internal
351 -- Profile data are only accessible via the view users.list_users. 351 -- Profile data are only accessible via the view users.list_users.
352 CREATE TABLE user_profiles ( 352 CREATE TABLE user_profiles (
353 username varchar PRIMARY KEY CHECK(octet_length(username) <= 63), 353 username varchar PRIMARY KEY
354 CHECK(octet_length(username) <= 63)
355 CHECK(to_regrole(quote_ident(username)) IS NOT NULL),
354 -- keep username length compatible with role identifier 356 -- keep username length compatible with role identifier
355 country char(2) NOT NULL REFERENCES countries, 357 country char(2) NOT NULL REFERENCES countries,
356 map_extent box2d NOT NULL, 358 map_extent box2d NOT NULL,
357 email_address varchar NOT NULL 359 email_address varchar NOT NULL
358 ) 360 )