andkon/yii2-migrate

简化迁移编写的类

维护者

详细信息

github.com/andkon13/yii2-migrate

源代码

问题

安装量: 8,827

依赖项: 0

建议者: 0

安全性: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

1.2.2 2017-06-21 09:54 UTC

Requires

  • php: >=5.4.0

proprietary 8f6396f96672cca7728e6aae90f8640bc55c9213

  • Andrey Konenkov <andkon13.woop@gmail.com>

This package is not auto-updated.

Last update: 2024-09-14 18:36:44 UTC

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',
            ],
        ];
    }
}