Database Ideas

[clxxiii]

While making the site, a load of ideas for the future came to me so I'm gonna use them:

• [x] Use a osu_id for the User table, so users can link multiple discord accounts, and so the URLs are shorter
• [x] Add a DiscordAccount table and move all the discord_ properties to there, so a user can have multiple accounts
• [x] Add a TournamentBadges table for a player's earned tournament badges to display on their profile
• [x] Add a CustomBadges table for things like supporter, early bird, developer, etc.
• [x] Add a banner_url column in the Tournament table
• [x] Remove multiplier_** and replace it with a dedicated ModMultiplier table
• [x] Add a private column to the Tournament table that hides a tournament from the tournament list
• [x] Add a Hosts property that links to a Userobject, by default the person who made the table that made the tournament, and an array so other people can be invited to the host team.
• [x] Add a description column to the Tournament table

[clxxiii]

Ok there's basically no way to do most of this without a massive wipe of the database, so instead of trying to fight with migrations, I'm just going to start from 0

[clxxiii]

I still need to refactor a load of functions from the bot side of things, I am too lazy and too tired to do that tonight so main branch is broken for the time being :)

[clxxiii]

• [ ] Add avg_rank column to Team table
• [ ] Add avatar_url column to User table

[clxxiii]

• [ ] Add operating_system, and device_type, and last_used columns to Session table