andkon/yii2-migrate

Class to simplify the writing of migrations

1.2.2 2017-06-21 09:54 UTC

Requires

• php: >=5.4.0

proprietary

• Andrey Konenkov

README

Надстройка над стандартными миграциями, позволяющая автоматически создавать функции отката миграции.

uses:

class m000000_000000_users extends \andkon\migrate\Migration
{
    public function setTables()
    {
        return [
            'users' => [
                'id'            => $this->primaryKey(),
                'company_id'    => $this->integer()->notNull(),
                'position_id'   => $this->integer(),
                'department_id' => $this->integer(),
                'login'         => $this->string(255)->notNull(),
                'password'      => $this->string(255),
                'password_salt' => $this->string(255),
                'first_name'    => $this->string(255),
                'middle_name'   => $this->string(255),
            ]
        ];
    }
    
    public function setForeignKeys()
    {
        return [
            // user
            [
                'user'    => 'company_id',
                'company' => 'id',
            ],
            [
                'user'     => 'position_id',
                'position' => 'id',
                'delete'   => 'RESTRICT',
            ],
        ];
    }
}