OpenFusionProject/OpenFusion

Disable case-sensitivity on Login column

CakeLancelot opened this issue · 1 comments

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.

Implemented in 2eb6454.