allejo / bzion

 */

class BanMuteSupportIssue157 extends AbstractMigration

{

    public function up()

    {

        $bansTable = $this->table('bans');

        $bansTable

            ->removeColumn('allow_server_join')

            ->addColumn('is_soft_ban', 'boolean', [

                'after' => 'author',

                'null' => false,

                'default' => false,

                'comment' => 'A soft ban will not penalize a user on the site or servers',

            ])

            ->update()

        ;

        // Unban any currently banned players

        $this->query("UPDATE players SET status = 'active' WHERE status = 'banned';");

    }

    public function down()

    {

        $this->query("UPDATE players SET status = 'active' WHERE status = 'banned';");

    }

    public function down()

    {

        $bansTable = $this->table('bans');

        $bansTable

            ->removeColumn('is_soft_ban')

            ->addColumn('allow_server_join', 'boolean', [

                'after' => 'reason',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not to allow players to join servers while banned'

            ])

            ->update()

        ;

    }

}