Mercurial > gemma

diff schema/gemma.sql @ 3956:4f9a1ff2c2ee pwreset-rework

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Reworked password reset to be single mailed.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 16 Jul 2019 12:38:44 +0200
parents 1b11ff97c1d1
children 7b7c324b318f
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Jul 15 17:54:12 2019 +0200
+++ b/schema/gemma.sql	Tue Jul 16 12:38:44 2019 +0200
@@ -232,7 +232,7 @@
     CREATE TABLE password_reset_requests (
         hash varchar(32) PRIMARY KEY,
         issued timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-        username varchar NOT NULL
+        username varchar NOT NULL UNIQUE
             REFERENCES internal.user_profiles(username)
                 ON DELETE CASCADE ON UPDATE CASCADE
     )