diff options
| author | Tor Andersson <tor@ccxvii.net> | 2021-06-18 21:57:16 +0200 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2021-06-19 12:02:41 +0200 |
| commit | 7828eadaf862b6a75cb85fafcdd2d5f3b803702d (patch) | |
| tree | 41b361a492459d2c22a7bb09062bb94ae4ca2c09 /tools | |
| parent | d26b79fa0242008c01a1db379c65f3e06c603c94 (diff) | |
| download | server-7828eadaf862b6a75cb85fafcdd2d5f3b803702d.tar.gz | |
Case insensitive user name and email columns.
Diffstat (limited to 'tools')
| -rw-r--r-- | tools/sql/schema.txt | 6 |
1 files changed, 3 insertions, 3 deletions
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 |