Mercurial > gemma

diff 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 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;