From d26b79fa0242008c01a1db379c65f3e06c603c94 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Fri, 18 Jun 2021 17:53:14 +0200 Subject: Add password reset via email token. --- tools/sql/schema.txt | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'tools/sql/schema.txt') diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt index a75ce1d..bd695f7 100644 --- a/tools/sql/schema.txt +++ b/tools/sql/schema.txt @@ -18,6 +18,12 @@ CREATE TABLE IF NOT EXISTS notifications ( UNIQUE ( user_id, game_id ) ); +CREATE TABLE IF NOT EXISTS forgot_password ( + user_id INTEGER PRIMARY KEY, + token TEXT, + time TIMESTAMP +); + CREATE TABLE IF NOT EXISTS blacklist_ip ( ip TEXT PRIMARY KEY ); CREATE TABLE IF NOT EXISTS blacklist_mail ( mail TEXT PRIMARY KEY ); -- cgit v1.2.3