Mercurial > gemma
comparison schema/updates/1000/01.pwreset.sql @ 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 | |
children | 7b7c324b318f |
comparison
equal
deleted
inserted
replaced
3970:32e9ae5210f9 | 3971:4eaa6bca367a |
---|---|
1 BEGIN; | |
2 | |
3 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin; | |
4 | |
5 ALTER TABLE sys_admin.password_reset_requests ADD CONSTRAINT password_reset_requests_username_key UNIQUE(username); | |
6 | |
7 COMMIT; |