[x] Create a fresh github user with no attached email user, and associate an email with capitalisation via the github login flow
[x] Check that the user's associated email in the DB is in lowercase
[x] Go to a website with a different user in email login, and try to associate the email in the above step (but capitalised in places) - this should still work
After merging
[ ] Run through the list of user entries, and search for duplicate entries using SELECT id, email FROM "users" WHERE LOWER(TRIM(email)) IN ( SELECT LOWER(TRIM(email)) FROM "users" GROUP BY LOWER(TRIM(email)) HAVING count(*) > 1 ) - we should combine the users in this list and their associated sites
v0.29.0
#785
#786
#776
#788
#783
#780
Tests
After merging
SELECT id, email FROM "users" WHERE LOWER(TRIM(email)) IN ( SELECT LOWER(TRIM(email)) FROM "users" GROUP BY LOWER(TRIM(email)) HAVING count(*) > 1 )
- we should combine the users in this list and their associated sites