Mercurial > gemma

comparison schema/gemma.sql @ 5323:eec88a166251 extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added report_reciever column to user_profiles table.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sat, 29 May 2021 17:19:03 +0200
parents f11b9b50fcc9
children ac1986c23889
comparison
equal deleted inserted replaced
5322:80d9fd782f00 5323:eec88a166251
382 CHECK(octet_length(username) <= 63) 382 CHECK(octet_length(username) <= 63)
383 CHECK(to_regrole(quote_ident(username)) IS NOT NULL), 383 CHECK(to_regrole(quote_ident(username)) IS NOT NULL),
384 -- keep username length compatible with role identifier 384 -- keep username length compatible with role identifier
385 country char(2) NOT NULL REFERENCES countries, 385 country char(2) NOT NULL REFERENCES countries,
386 map_extent box2d NOT NULL, 386 map_extent box2d NOT NULL,
387 email_address varchar NOT NULL 387 email_address varchar NOT NULL,
388 report_reciever boolean NOT NULL DEFAULT false
388 ) 389 )
389 ; 390 ;
390 391
391 392
392 -- Namespace to be accessed by sys_admin only 393 -- Namespace to be accessed by sys_admin only
490 r.rolname, 491 r.rolname,
491 p.username, 492 p.username,
492 CAST('' AS varchar) AS pw, 493 CAST('' AS varchar) AS pw,
493 p.country, 494 p.country,
494 p.map_extent, 495 p.map_extent,
495 p.email_address 496 p.email_address,
497 p.report_reciever
496 FROM internal.user_profiles p 498 FROM internal.user_profiles p
497 JOIN pg_roles u ON p.username = u.rolname 499 JOIN pg_roles u ON p.username = u.rolname
498 JOIN pg_auth_members a ON u.oid = a.member 500 JOIN pg_auth_members a ON u.oid = a.member
499 JOIN pg_roles r ON a.roleid = r.oid 501 JOIN pg_roles r ON a.roleid = r.oid
500 WHERE p.username = current_user 502 WHERE p.username = current_user