Store match round scores in seperate table #20

New issue

Open

opened 2023-10-04 11:45:28 +01:00 by tgpholly · 0 comments

tgpholly commented

2023-10-04 11:45:28 +01:00

(Migrated from github.com)

Right now the scores for all players are squished on to the end of a row in mp_match_rounds, this is pretty bad and we have to null any slots that didn't have a user in it. We could instead just store it in it's own table like mp_match_round_scores and store it by match_id, slot_id and user_id and exclude any slots that didn't have a user in it.

Right now the scores for all players are squished on to the end of a row in `mp_match_rounds`, this is pretty bad and we have to null any slots that didn't have a user in it. We could instead just store it in it's own table like `mp_match_round_scores` and store it by `match_id`, `slot_id` and `user_id` and exclude any slots that didn't have a user in it.