Schema Changes

[clxxiii]

Here are the things that need to be considered:

Choose between one or more of the following database hosts:

• Privately hosted server kono server
• AWS Postgres server
• Turso
• Redis
• Supabase
• Neon

Choose between the two ORMs

• Drizzle
• Prisma

Other changes to the schema should be specified in replies.

[clxxiii]

• [x] Remove Global table
• [x] Remove OsuBadge table
• [x] Remove UserTitle table
• [x] Edit Tournament table
  • [x] Remove mod_multipliers property
• [x] Edit TournamentSettings table
  • [x] Add mod_multipliers property
• [x] Remove DiscordAccount table
• [x] Remove TwitchAccount table
• [x] Remove DiscordOauth table
• [x] Remove TwitchOauth table
• [x] Remove UserSession table
• [x] Remove Guild table
• [x] Edit Round table
  • [x] Remove is_qualifier property
• [x] Remove RoundSettings table
• [x] Edit Mappool table
  • [x] Remove description property
• [x] Edit MapInPool table
  • [x] Remove mod_priority property
  • [x] Add optional tournament_settings property
• [x] Edit Map table
  • [x] Remove diff_mapper_user_id property
  • [x] Remove *_difficulty properties
  • [x] Remove count_* properties
  • [x] Remove hit_length
  • [x] Remove all beatmapset attribute besides slim_cover_2x_url (renamed to cover_url), artist, and title
• [x] Edit Team table
  • [x] Remove scrim property
• [x] Edit Match table
  • [x] Remove message_id property
  • [x] Remove channel_id property
  • [x] Split state into current_section: Int and block_in_section: Int
• [x] Add BlockSection property
  • [x] action_string: String
  • [x] blocks: MatchBlock[]
• [x] Edit MapInMatch table
  • [x] Rename to MatchBlock
  • [x] Remove all (picked, protected, etc.)_by properties
  • [x] Add acted_on_by?: Team property
• [x] Edit TeamInMatch table
  • [x] Use primary autoincrementing key
  • [x] Make team and foreign key properties optional
  • [x] Remove pick_order property
  • [x] Remove ban_order property
  • [x] Remove warmed_up property
• [x] Add a MappoolInRound intermediary table
• [x] Remove QualifierMatch table
• [x] Remove TeamInQualifierMatch table