Yii Framework: Creating Migrations

console.php

<?php
return array(
    ...
    'commandMap' => array(
        'migrate' => array(
            'class' => 'system.cli.commands.MigrateCommand',
            'migrationTable' => 'migration',
            'templateFile' => 'application.migrations.template',
        ),
    ),
    ...

m130110_074533_init.php

<?php
class m130110_074533_init extends CDbMigration
{
    public function safeUp()
    {
        $options = '';
        if (Yii::app()->db->schema instanceof CMysqlSchema) {
            $options = 'ENGINE=InnoDB DEFAULT CHARSET=utf8';
        }

        // user
        $this->createTable('user', array(
            'id' => 'pk',
            'username' => 'string NOT NULL',
            'email' => 'string NOT NULL',
            'password' => 'string NOT NULL',
        ), $options);

        $this->createIndex('user_username', 'user', 'username', true);
        $this->createIndex('user_email', 'user', 'email', true);

        //word
        $this->createTable('word', array(
            'id' => 'pk',
            'userid' => 'integer NOT NULL',
            'en' => 'string NOT NULL',
            'ja' => 'string NOT NULL',
        ), $options);

        $this->addForeignKey('fk_word_userid', 'word', 'userid', 'user', 'id', 'CASCADE', 'CASCADE');
        $this->createIndex('word_en_userid', 'word', 'en, userid', false);
    }

    public function safeDown()
    {
        $this->dropTable('word');
        $this->dropTable('user');
    }
}

template.php

<?php
class {ClassName} extends CDbMigration
{
    public function safeUp()
    {
        $options = '';
        if (Yii::app()->db->schema instanceof CMysqlSchema) {
            $options = 'ENGINE=InnoDB DEFAULT CHARSET=utf8';
        }
    }

    public function safeDown()
    {
    }
}