m160223_102646_add_language::safeDown()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 1
c 0
b 0
f 0
nc 1
nop 0
dl 0
loc 3
rs 10
1
<?php
2
3
use yii\db\Migration;
4
5
class m160223_102646_add_language extends Migration
6
{
7
    public $tableName = 'language';
8
9
    public function safeUp()
10
    {
11
        $this->createTable($this->tableName,[
12
            'language_id' => $this->primaryKey()->comment('ID'),
13
            'language' => $this->string(16)->notNull()->comment('language code'),
14
            'name' => $this->string(255)->notNull()->comment('Language name'),
15
16
        ]);
17
        $this->insert($this->tableName,['language_id'=>1, 'language'=>'en-US','name'=>'English']);
18
        $this->insert($this->tableName,['language_id'=>2, 'language'=>'et','name'=>'Estonian']);
19
        $this->insert($this->tableName,['language_id'=>3, 'language'=>'ru','name'=>'Russian']);
20
        $this->insert($this->tableName,['language_id'=>4, 'language'=>'fi','name'=>'Finnish']);
21
        $this->insert($this->tableName,['language_id'=>5, 'language'=>'lv','name'=>'Latvian']);
22
        $this->insert($this->tableName,['language_id'=>6, 'language'=>'lt','name'=>'Lithuanian']);
23
24
    }
25
26
    public function safeDown()
27
    {
28
        $this->dropTable($this->tableName);
29
    }
30
}
31