Mercurial > gemma
changeset 3971:4eaa6bca367a
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 | 32e9ae5210f9 |
children | 72473ebd9d64 7316b7e8246f |
files | schema/updates/1000/01.pwreset.sql |
diffstat | 1 files changed, 7 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1000/01.pwreset.sql Wed Jul 17 10:47:11 2019 +0200 @@ -0,0 +1,7 @@ +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;