From 7828eadaf862b6a75cb85fafcdd2d5f3b803702d Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Fri, 18 Jun 2021 21:57:16 +0200 Subject: Case insensitive user name and email columns. --- tools/sql/schema.txt | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'tools/sql/schema.txt') diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt index bd695f7..57e369e 100644 --- a/tools/sql/schema.txt +++ b/tools/sql/schema.txt @@ -1,7 +1,7 @@ CREATE TABLE IF NOT EXISTS users ( user_id INTEGER PRIMARY KEY, - name TEXT UNIQUE, - mail TEXT UNIQUE, + name TEXT UNIQUE COLLATE NOCASE, + mail TEXT UNIQUE COLLATE NOCASE, password TEXT, salt TEXT, ctime TIMESTAMP, @@ -18,7 +18,7 @@ CREATE TABLE IF NOT EXISTS notifications ( UNIQUE ( user_id, game_id ) ); -CREATE TABLE IF NOT EXISTS forgot_password ( +CREATE TABLE IF NOT EXISTS tokens ( user_id INTEGER PRIMARY KEY, token TEXT, time TIMESTAMP -- cgit v1.2.3