+global\PlayerElo::change()

Complexity

Conditions	1
Paths	1

Size

Total Lines	49
Code Lines	38

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function change()
    {
        $players = $this->table('players');
        $players
            ->addColumn('elo', 'integer', [
                'limit' => 10,
                'signed' => false,
                'null' => false,
                'default' => 1200,
                'comment' => 'The current ELO for this player'
            ])
            ->update()
        ;

        $playerELOs = $this->table('player_elo', ['id' => false, 'primary_key' => 'id']);
        $playerELOs
            ->addColumn('id', 'integer', ['limit' => 10, 'signed' => false, 'identity' => true])
            ->addColumn('user_id', 'integer', [
                'limit' => 10,
                'signed' => false,
                'null' => false,
                'comment' => 'The player whose had their individual ELO change',
            ])
            ->addColumn('match_id', 'integer', [
                'limit' => 10,
                'signed' => false,
                'null' => false,
                'comment' => 'The match the player participated in, which resulted in this ELO change'
            ])
            ->addColumn('elo_diff', 'integer', [
                'signed' => false,
                'null' => false,
                'comment' => 'The change in ELO for this player from this match'
            ])
            ->addColumn('elo_previous', 'integer', [
                'signed' => false,
                'null' => false,
                'comment' => 'The ELO the player had prior to participating in this match'
            ])
            ->addColumn('elo_new', 'integer', [
                'signed' => false,
                'null' => false,
                'comment' => 'The new ELO for the player after participating in this match'
            ])
            ->addForeignKey('user_id', 'players', 'id', ['delete' => 'CASCADE'])
            ->addForeignKey('match_id', 'matches', 'id', ['delete' => 'CASCADE'])
            ->create()
        ;
    }
}