m151031_160731_taxonomy

Complexity

Total Complexity

5

Size/Duplication

Total Lines	44
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getTableOptions()	0	8	2
A	up()	0	26	2
A	down()	0	5	1

<?php

use nkostadinov\taxonomy\models\TaxonomyDef;
use nkostadinov\taxonomy\models\TaxonomyTerms;
use yii\db\Migration;

class m151031_160731_taxonomy extends Migration
{
    public function getTableOptions()
    {
        if ($this->db->driverName === 'mysql') {
            // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
            return 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
        } else
            throw new Exception('Unsupported database.');
    }

    public function up()
    {
        $this->createTable(TaxonomyDef::tableName(), [
            'id' => $this->primaryKey(),
            'name' => $this->string()->notNull()->unique(),
            'class' => $this->string()->notNull(),
            'created_at' => $this->timestamp(),
            'total_count' => $this->bigInteger()->defaultValue(0),
            'data_table' => $this->string()->notNull(),
            'ref_table' => $this->string()->notNull(),
            'migration' => $this->string()
        ], $this->getTableOptions());

        $this->createTable(TaxonomyTerms::tableName(), [
            'id' => $this->bigPrimaryKey(),
            'taxonomy_id' => $this->integer()->notNull(),
            'term' => $this->string(),
            'total_count' => $this->bigInteger()->defaultValue(0),
            'parent_id' => $this->bigInteger(),
        ], $this->getTableOptions());

        if ($this->db->driverName === 'mysql') {
            $this->addForeignKey('fk_TaxonomyTerm_Taxonomy', TaxonomyTerms::tableName(), 'taxonomy_id',
                TaxonomyDef::tableName(), 'id');
        }
    }

    public function down()
    {
        $this->dropTable(TaxonomyTerms::tableName());
        $this->dropTable(TaxonomyDef::tableName());
    }
}