Mercurial > gemma

view schema/updates/1000/01.pwreset.sql @ 3971:4eaa6bca367a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added db migration for nee password reset mechanism.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 17 Jul 2019 10:47:11 +0200
parents
children 7b7c324b318f
line wrap: on
line source

BEGIN;

GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin;

ALTER TABLE sys_admin.password_reset_requests ADD CONSTRAINT password_reset_requests_username_key UNIQUE(username);

COMMIT;