Mercurial > gemma

annotate 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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
3971
4eaa6bca367a Added db migration for nee password reset mechanism.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 BEGIN;
4eaa6bca367a Added db migration for nee password reset mechanism.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2
4eaa6bca367a Added db migration for nee password reset mechanism.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin;
4eaa6bca367a Added db migration for nee password reset mechanism.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4
4eaa6bca367a Added db migration for nee password reset mechanism.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 ALTER TABLE sys_admin.password_reset_requests ADD CONSTRAINT password_reset_requests_username_key UNIQUE(username);
4eaa6bca367a Added db migration for nee password reset mechanism.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6
4eaa6bca367a Added db migration for nee password reset mechanism.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7 COMMIT;