Disable case-sensitivity on Login column
CakeLancelot opened this issue · 1 comments
CakeLancelot commented
As it stands, the Login
column in the Accounts
table is case sensitive. This leads to some unwanted interactions when logging in: the user would capitalize one or more letter of their already existing username and create a new account.
For this, a database migration will be needed to change the column to COLLATE NOCASE
- but there may also be duplicate accounts that need to be merged or deleted. We should be able to provide some sort of script to solve the majority of these issues.
Note: be sure to modify all known public server owners so that they can run the script and upgrade smoothly.
dongresource commented
Implemented in 2eb6454.