allejo / bzion

class MakeInvitationsBetter extends AbstractMigration

{

    public function change()

    {

        $invitationsTable = $this->table('invitations');

        $invitationsTable

            ->addColumn('sent', 'datetime', [

                'after' => 'team',

                'null' => true,

                'default' => null,

                'comment' => 'When the invitation was sent',

            ])

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

                'after' => 'text',

                'null' => false,

                'default' => 0,

                'signed' => true,

                'length' => 1,

                'comment' => '0: pending; 1: accepted; 2: rejected',

            ])

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

                'after' => 'status',

                'null' => false,

                'default' => false,

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

            ])

            ->update()

        ;

        $invitationsTable

            ->renameColumn('text', 'message')

            ->update()

        ;

        $invitationsTable

            ->changeColumn('message', 'text', [

                'null' => true,

                'default' => null,

                'comment' => 'The message sent when inviting a player to a team',

            ])

            ->update()

        ;

    }

}

class ServerStatusColumnConversation extends AbstractMigration

{

    public function up()

    {

        $serversTable = $this->table('servers');

        $serversTable

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

                'after' => 'updated',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this server is capable of hosting official matches',

            ])

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

                'after' => 'is_official_server',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this server is dedicated to serving replays of matches',

            ])

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

                'after' => 'is_replay_server',

                'null' => false,

                'default' => false,

                'comment' => 'Whether or not this server is no longer active but still required for historical purposes',

            ])

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

                'after' => 'is_inactive',

                'null' => false,

                'default' => false,

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

            ])

            ->update()

        ;

        // BZiON 0.10.x and below required that you soft deleted servers so they'd no longer appear on the server list.

        // For this reason and because Leagues United is the only known installation, we'll be assuming that deleted

        // servers were just meant to be marked as "inactive."

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

        $serversTable

            ->removeColumn('status')

            ->update()

        ;

    }

    public function down()

    {