Yii2: Создание таблиц БД

'db' => [
    'dsn' => 'mysql:host=localhost;dbname=tvh41',
    'username' => 'root',
    'password' => 'rootpasswd',
    'tablePrefix' => 'tvh_',
],

php yii migrate/create create_organization_table

Yii Migration Tool (based on Yii v2.0.7-dev)
 
Create new migration '/home/spions/Web/yii2-app-basic/migrations/m151231_064302_create_organization_table.php'? (yes|no) [no]:yes
New migration created successfully.

<?php 
use yii\db\Schema; 
use yii\db\Migration; 
class m151231_064302_create_organization_table extends Migration 
{ 
public function up() { 
            $tableOptions = null; 
            if ($this->db->driverName === 'mysql') {
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB';
        }
 
        $this->createTable('{{%organization}}', [
            'id' => $this->primaryKey(),
            'created_at' => $this->integer()->notNull(),
            'updated_at' => $this->integer()->notNull(),
            'name' => $this->string()->notNull(),
            'status' => $this->smallInteger()->notNull()->defaultValue(0),
        ], $tableOptions);
 
        $this->createIndex('idx_org_name', '{{%organization}}', 'name');
        $this->createIndex('idx_org_status', '{{%organization}}', 'status');
 
    }
 
    public function down()
    {
        echo "m151231_064302_create_organization_table cannot be reverted.\n";
        //$this->dropTable('{{%organization}}');
        return false;
    }
 
    /*
    // Use safeUp/safeDown to run migration code within a transaction
    public function safeUp()
    {
    }
 
    public function safeDown()
    {
    }
    */
}

mysql -uroot -p --execute='create database tvh41 character set utf8;'

php yii migrate/up

spions: ~/Web/yii2-app-basic $ php yii migrate/up
Yii Migration Tool (based on Yii v2.0.7-dev)
 
Creating migration history table "migration"...Done.
Total 1 new migration to be applied:
        m151231_064302_create_organization_table
 
Apply the above migration? (yes|no) [no]:yes
*** applying m151231_064302_create_organization_table
    > create table {{%organization}} ... done (time: 0.037s)
    > create index idx_org_name on {{%organization}} (name) ... done (time: 0.096s)
    > create index idx_org_status on {{%organization}} (status) ... done (time: 0.063s)
*** applied m151231_064302_create_organization_table (time: 0.241s)
 
 
1 migration was applied.
 
Migrated up successfully.

$ mysql -uroot -p --execute='use tvh41; SHOW TABLES;'
Enter password:
+-----------------+
| Tables_in_tvh41 |
+-----------------+
| migration       |
| organization    |
+-----------------+