aboutsummaryrefslogtreecommitdiff
path: root/app/models.py
diff options
context:
space:
mode:
Diffstat (limited to 'app/models.py')
-rw-r--r--app/models.py6
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)