allejo / bzion

class NewsStatusColumnConversion extends AbstractMigration

{

    public function up()

    {

        $newsTable = $this->table('news');

        $newsTable

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

                'after' => 'editor',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not the news article is a draft',

            ])

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

                'after' => 'is_draft',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not the news article has been soft deleted',

            ])

            ->update()

        ;

        $this->query("UPDATE news SET is_draft = 1 WHERE status = 'revision' OR status ='draft';");

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

        $newsTable

            ->removeColumn('parent_id')

            ->removeColumn('status')

            ->update()

        ;

    }

    public function down()

    {

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()

    {