m161031_110050_create_device_table::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 4
rs 10
c 0
b 0
f 0
cc 1
nc 1
nop 0
1
<?php
2
3
use yii\db\Migration;
4
5
/**
6
 * Handles the creation of table `device`.
7
 */
8
// @codingStandardsIgnoreLine
9
class m161031_110050_create_device_table extends Migration
10
{
11
    /**
12
     * {@inheritdoc}
13
     */
14
    public function up()
15
    {
16
        $tableOptions = null;
17
        if ($this->db->driverName === 'mysql') {
18
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
19
        }
20
21
        $this->createTable('device', [
22
            'id' => $this->primaryKey()->notNull()->append('AUTO_INCREMENT'),
23
            'name' => $this->string(64)->notNull(),
24
            'description' => $this->string(1024),
25
            'last_auth' => $this->timestamp()->null(),
26
            'enabled' => $this->boolean()->notNull()->defaultValue(false),
27
        ], $tableOptions);
28
    }
29
30
    /**
31
     * {@inheritdoc}
32
     */
33
    public function down()
34
    {
35
        $this->dropTable('device');
36
    }
37
}
38