# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1563353231 -7200
# Node ID 4eaa6bca367a1026a819ecff813f734606ce7a8f
# Parent  32e9ae5210f90ddf1637d896a16d774ebe035605
Added db migration for nee password reset mechanism.

diff -r 32e9ae5210f9 -r 4eaa6bca367a schema/updates/1000/01.pwreset.sql
--- /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;