-- TODO: do we need `player_penalty`?? For the tie-breaker we keep track of it
-- in `player_score_aux`. For the UI we have the position of the token.
ALTER TABLE `player` ADD `player_penalty` tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `player` ADD `player_penalty` tinyint(1) NOT NULL DEFAULT 0;

-- To calculate the winnable points for players solving later then others.

        // Set initial scores. `player_score_aux` is (investigators_remaining *
        // 100 - penalty_points).
        self::DbQuery("UPDATE player SET player_score = 0, player_score_aux = 500");

        // Adjust the tiebreaker score.
        self::DbQuery("UPDATE player SET player_score_aux = player_score_aux - 100 WHERE player_id = $player_id");

                    player_penalty = player_penalty - 2

                    player_score_aux = player_score_aux - 2,
                    player_penalty = player_penalty - 2,