+global\ClearDeletedTeamAvatars::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	40
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up()
    {
        $playersTable = $this->table('players');
        $playersTable
            ->changeColumn('avatar', 'string', [
                'limit' => 200,
                'null' => true,
                'comment' => "The path to the player's avatar relative to the bzion project root",
            ])
            ->update()
        ;

        $this->execute("
            UPDATE
                players
            SET
                avatar = NULL 
            WHERE
                status IN ('deleted', 'disabled')
        ");

        $teamsTable = $this->table('teams');
        $teamsTable
            ->changeColumn('avatar', 'string', [
                'limit' => 200,
                'null' => true,
                'comment' => "The path to the player's avatar relative to the bzion project root",
            ])
            ->update()
        ;

        $this->execute("
            UPDATE
                teams
            SET
                avatar = NULL
            WHERE
                status IN ('deleted', 'disabled')
        ");
    }
}