Skip to content
Yii2 migration command upgrade
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore
PowerMigration.php
README.md
composer.json
composer.lock
template.php

README.md

Migration Extension for Yii2

Features

Installation

In composer.json:

{
    "require": {
        "rmrevin/yii2-power-migration": "~1.1"
    }
}

Configuration

/config/console.php

<?
return [
	// ...
	'controllerMap' => [
		// ...
		'migrate' => [
            'class' => yii\console\controllers\MigrateController::class,
            'templateFile' => '@vendor/rmrevin/yii2-power-migration/template.php',
        ],
	],
	// ...
];

Usage

<?

use yii\db\Schema;
use rmrevin\yii\db\migration;

class m140317_055355_file extends migration\PowerMigration
{

    public function instructions()
    {
        return [
            'createTableFile',
            'createTableFileLink',
        ];
    }

    public function createTableFile_up()
    {
        $this->createTable('{{%file}}', [
            'id' => Schema::TYPE_PK,
            'mime' => Schema::TYPE_STRING . ' NOT NULL',
            'size' => Schema::TYPE_BIGINT . ' NOT NULL DEFAULT 0',
            'name' => Schema::TYPE_STRING . ' NOT NULL',
            'origin_name' => Schema::TYPE_STRING . ' NOT NULL',
            'sha1' => Schema::TYPE_STRING . '(40) NOT NULL',
            'image_bad' => Schema::TYPE_BOOLEAN . ' NOT NULL DEFAULT 0',
        ]);
    }

    public function createTableFile_down()
    {
        $this->dropTable('{{%file}}');
    }
    
    public function createTableFileLink_up()
    {
        $this->createTable('{{%file_link}}', [
            'file_id' => Schema::TYPE_PK,
            'url' => Schema::TYPE_STRING . ' NOT NULL',
        ]);
    }

    public function createTableFileLink_down()
    {
        $this->dropTable('{{%file_link}}');
    }
}
You can’t perform that action at this time.