Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
3954:cb4fda122321 3956:4f9a1ff2c2ee
230 ) 230 )
231 231
232 CREATE TABLE password_reset_requests ( 232 CREATE TABLE password_reset_requests (
233 hash varchar(32) PRIMARY KEY, 233 hash varchar(32) PRIMARY KEY,
234 issued timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 234 issued timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
235 username varchar NOT NULL 235 username varchar NOT NULL UNIQUE
236 REFERENCES internal.user_profiles(username) 236 REFERENCES internal.user_profiles(username)
237 ON DELETE CASCADE ON UPDATE CASCADE 237 ON DELETE CASCADE ON UPDATE CASCADE
238 ) 238 )
239 239
240 -- Tables with geo data to be published with GeoServer. 240 -- Tables with geo data to be published with GeoServer.