<?php

use yii\db\Migration;

class m161110_114431_region extends Migration
{
    public function up()
    {
        $tableOptions = null;
        if ($this->db->driverName === 'mysql') {
            // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
        }

        $this->createTable('{{%region}}', [
            'id' => $this->primaryKey(),
            'ordinal' => $this->integer()->notNull(),
            'name' => $this->string()->notNull()
        ], $tableOptions);

        $this->addColumn('{{%country}}', 'regionId', $this->integer());
        $this->createIndex('IDX_country_region', '{{%country}}', 'regionId');
    }

    public function down()
    {
        $this->dropTable('{{%region}}');
        $this->dropIndex('IDX_country_region', '{{%country}}');
        $this->dropColumn('{{%country}}', 'regionId');
    }
}