m200505_091520_add_localname::safeUp()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 10
Code Lines 8

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 8
nc 1
nop 0
dl 0
loc 10
rs 10
c 0
b 0
f 0
1
<?php
2
3
use yii\db\Migration;
4
5
/**
6
 * Class m200505_091520_add_localname
7
 */
8
class m200505_091520_add_localname extends Migration
9
{
10
    /**
11
     * {@inheritdoc}
12
     */
13
    public function safeUp()
14
    {
15
        $this->addColumn('language', 'native_name', $this->string(255)->after('name')->null()->comment('Language name in local'));
16
        $this->update('language', ['native_name' => new \yii\db\Expression('name')]);
17
        $this->alterColumn('language', 'native_name', $this->string(255)->notNull()->comment('Language name in local'));
18
        $this->update('language', ['native_name' => 'Eesti'], ['language_id' => 2]);
19
        $this->update('language', ['native_name' => 'Русский'], ['language_id' => 3]);
20
        $this->update('language', ['native_name' => 'Suomi'], ['language_id' => 4]);
21
        $this->update('language', ['native_name' => 'Latviešu'], ['language_id' => 5]);
22
        $this->update('language', ['native_name' => 'Lietuvių'], ['language_id' => 6]);
23
24
    }
25
26
    /**
27
     * {@inheritdoc}
28
     */
29
    public function safeDown()
30
    {
31
        $this->dropColumn('language', 'native_name');
32
    }
33
}
34