diff options
| author | Tor Andersson <tor@ccxvii.net> | 2021-06-18 17:53:14 +0200 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2021-06-19 12:02:41 +0200 |
| commit | d26b79fa0242008c01a1db379c65f3e06c603c94 (patch) | |
| tree | 2cdbb47ff87676ec5b54976a1a51f52fb2a20a33 /tools/sql | |
| parent | bbf5e1573384707c9389cc1f5ea731d87767ce0f (diff) | |
| download | server-d26b79fa0242008c01a1db379c65f3e06c603c94.tar.gz | |
Add password reset via email token.
Diffstat (limited to 'tools/sql')
| -rw-r--r-- | tools/sql/schema.txt | 6 |
1 files changed, 6 insertions, 0 deletions
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 ); |