From b84727b187a388fa5f37b0a87c3631822c071879 Mon Sep 17 00:00:00 2001 From: rubenwardy Date: Sun, 3 Jun 2018 01:50:14 +0100 Subject: Fix username being case-sensitive --- app/models.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'app') diff --git a/app/models.py b/app/models.py index 5780aa0..e5aafd4 100644 --- a/app/models.py +++ b/app/models.py @@ -96,15 +96,15 @@ class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) # User authentication information - username = db.Column(db.String(50), nullable=False, unique=True) + username = db.Column(db.String(50, collation="NOCASE"), nullable=False, unique=True, index=True) password = db.Column(db.String(255), nullable=True) reset_password_token = db.Column(db.String(100), nullable=False, server_default="") rank = db.Column(db.Enum(UserRank)) # Account linking - github_username = db.Column(db.String(50), nullable=True, unique=True) - forums_username = db.Column(db.String(50), nullable=True, unique=True) + github_username = db.Column(db.String(50, collation="NOCASE"), nullable=True, unique=True) + forums_username = db.Column(db.String(50, collation="NOCASE"), nullable=True, unique=True) # User email information email = db.Column(db.String(255), nullable=True, unique=True) -- cgit v1.2.3