Manually fixed a ton of inconsistencies in legacy DB
I came across a few problems in the production DB of our multiplayer card game. I have inherited the DB and was shocked to find out that it didn't have proper uniqueness validation (for emails and such) enforced at the DB level. There was apparently a function in the old API that did that check manually, but nothing in the DB itself. Hence I have now a bunch of users with the same username.
Fixed them all manually this morning.. It wasn't how I imagined my morning to turn out, but that sometimes how it goes. :)
Fixed them all manually this morning.. It wasn't how I imagined my morning to turn out, but that sometimes how it goes. :)