m160706_223500_vote_updates::up()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 4
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 2
dl 0
loc 4
rs 10
c 1
b 0
f 0
cc 1
nc 1
nop 0
1
<?php
2
3
use hauntd\vote\migrations\Migration;
4
5
/**
6
 * @author Alexander Kononenko <[email protected]>
7
 */
8
class m160706_223500_vote_updates extends Migration
9
{
10
    public function up()
11
    {
12
        $this->createIndex('vote_target_user_idx', '{{%vote}}', ['entity', 'target_id', 'user_id'], false);
13
        $this->alterColumn('{{%vote}}', 'value', $this->boolean()->notNull());
14
15
        //TODO: check these command and fix migration
16
        //$this->execute('ALTER TABLE vote ALTER COLUMN value TYPE boolean USING CASE value WHEN 0 THEN false ELSE true END');
17
    }
18
19
    public function down()
20
    {
21
        $this->dropIndex('vote_target_user_idx', '{{%vote}}');
22
        $this->alterColumn('{{%vote}}', 'value', $this->smallInteger(1)->notNull());
23
    }
24
}
25