Closes #19 add single column primary key to league_season_score

FAForever / faf-league-service

The league service of Forged Alliance Forever

GNU General Public License v3.0

0 stars 0 forks source link

Closes #19 add single column primary key to league_season_score #20

Closed bukajsytlos closed 3 years ago

bukajsytlos commented 3 years ago

Closes #19

cleborys commented 3 years ago

The problem was that we were relying on the pair (login_id, league_season_id) to have a UNIQUE constraint so that we could do a single query upsert (INSERT on duplicate key UPDATE) when writing score updates and removing that constrained caused duplicate score entries.