diff options
| author | rubenwardy <rw@rubenwardy.com> | 2018-06-03 01:50:14 +0100 |
|---|---|---|
| committer | rubenwardy <rw@rubenwardy.com> | 2018-06-03 01:50:58 +0100 |
| commit | b84727b187a388fa5f37b0a87c3631822c071879 (patch) | |
| tree | 07bd3d05e385b59cd2d23eef8e1e521b1c8fad1a /app/models.py | |
| parent | 6fd36dbfff9935df9a4b4bcb885267a8ee903133 (diff) | |
| download | cheatdb-b84727b187a388fa5f37b0a87c3631822c071879.tar.xz | |
Fix username being case-sensitivev1.4.0
Diffstat (limited to 'app/models.py')
| -rw-r--r-- | app/models.py | 6 |
1 files changed, 3 insertions, 3 deletions
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) |