Add password reset via email token.

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 );