allejo / bzion

use Phinx\Migration\AbstractMigration;

class MapsStatusColumnConversion extends AbstractMigration

{

    public function up()

    {

        $mapsTable = $this->table('maps');

        $mapsTable

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

                'after' => 'game_mode',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this map has been marked as inactive, meaning a map is no longer in active rotation on servers',

            ])

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

                'after' => 'is_inactive',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this map has been soft deleted'

            ])

            ->update()

        ;

        $this->query("UPDATE maps SET is_inactive = 1 WHERE status = 'hidden' OR status = 'disabled';");

        $this->query("UPDATE maps SET is_deleted = 1 WHERE status = 'deleted';");

        $mapsTable

            ->removeColumn('status')

            ->update()

        ;

    }

    public function down()

    {

        $mapsTable = $this->table('maps');

        $mapsTable

            ->addColumn('status', 'set', [

                'values' => ['active', 'hidden', 'disabled', 'deleted'],

                'null' => false,

                'default' => 'active',

                'comment' => 'The status of the map',

            ])

            ->update()

        ;

        $this->query("UPDATE maps SET status = 'hidden' WHERE is_inactive = 1;");

        $this->query("UPDATE maps SET status = 'deleted' WHERE is_deleted = 1;");

        $mapsTable

            ->removeColumn('is_inactive')

            ->removeColumn('is_deleted')

        ;

    }

}

use Phinx\Migration\AbstractMigration;

class TeamStatusColumnConversion extends AbstractMigration

{

    public function up()

    {

        $teamsTable = $this->table('teams');

        $teamsTable

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

                'after' => 'members',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this team is closed',

            ])

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

                'after' => 'is_closed',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this team has been soft deleted',

            ])

            ->update()

        ;

        $this->query("UPDATE teams SET is_closed = 1 WHERE status = 'closed';");

        $this->query("UPDATE teams SET is_deleted = 1 WHERE status = 'deleted';");

        $teamsTable

            ->removeColumn('status')

            ->update()

        ;

    }

    public function down()

    {

        $teamsTable = $this->table('teams');

        $teamsTable

            ->addColumn('status', 'set', [

                'values' => ['open', 'closed', 'disabled', 'deleted'],

                'null' => false,

                'default' => 'open',

                'comment' => 'The status of the team',

            ])

            ->update()

        ;

        $this->query("UPDATE teams SET status = 'deleted' WHERE is_deleted = 1;");

        $this->query("UPDATE teams SET status = 'closed' WHERE is_closed = 1;");

        $teamsTable

            ->removeColumn('is_closed')

            ->removeColumn('is_deleted')

            ->update()

        ;

    }

}

use Phinx\Migration\AbstractMigration;

class PlayerStatusColumnConversion extends AbstractMigration

{

    public function up()

    {

        $playersTable = $this->table('players');

        $playersTable

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

                'after' => 'last_login',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this account has been disabled by an admin and cannot log in',

            ])

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

                'after' => 'is_disabled',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this player has been soft-deleted',

            ])

            ->update()

        ;

        $this->query("UPDATE players SET is_deleted = 1 WHERE status = 'deleted';");

        $this->query("UPDATE players SET is_disabled = 1 WHERE status = 'disabled';");

        $playersTable

            ->removeColumn('status')

            ->update()

        ;

    }

    public function down()

    {

        $playersTable = $this->table('players');

        $playersTable

            ->addColumn('status', 'set', [

                'values' => ['active','disabled','deleted','reported','banned','test'],

                'null' => false,

                'default' => 'active',

                'comment' => 'The status of this player',

            ])

            ->update()

        ;

        $this->query("UPDATE players SET status = 'deleted' WHERE is_deleted = 1;");

        $this->query("UPDATE players SET status = 'disabled' WHERE is_disabled = 1;");

        $playersTable

            ->removeColumn('is_disabled')

            ->removeColumn('is_deleted')

            ->update()

        ;

    }

}