summaryrefslogtreecommitdiff
path: root/tools/sql
diff options
context:
space:
mode:
Diffstat (limited to 'tools/sql')
-rw-r--r--tools/sql/schema.txt6
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 );