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]

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