CreateProPlayers

Complexity

Total Complexity

1

Size/Duplication

Total Lines	17
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	change()	0	14	1

<?php

use Phinx\Migration\AbstractMigration;

class CreateProPlayers extends AbstractMigration

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    public function change()
    {
        $pro_players = $this->table('pro_players', ['id' => 'pro_player_id', 'engine' => 'MyISAM']);
        
        $pro_players->addColumn('league', 'text')
                ->addColumn('first_name', 'text')
                ->addColumn('last_name', 'text')
                ->addColumn('position', 'text')
                ->addColumn('team', 'text')
                ->addIndex('league', ['limit' => 4, 'name' => 'league_idx'])
                ->addIndex('first_name', ['type' => 'fulltext', 'name' => 'firstname_idx'])
                ->addIndex('last_name', ['type' => 'fulltext', 'name' => 'lastname_idx'])
                ->create();
    }
}