Mercurial > gemma
comparison schema/gemma.sql @ 3956:4f9a1ff2c2ee pwreset-rework
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. |