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;