Passed
Push — scrutinizer-migrate-to-new-eng... ( 58afd6 )
by Alexander
18:11
created

m160313_153426_session_init   A

Complexity

Total Complexity 6

Size/Duplication

Total Lines 36
Duplicated Lines 0 %

Test Coverage

Coverage 90.48%

Importance

Changes 0
Metric Value
eloc 19
dl 0
loc 36
ccs 19
cts 21
cp 0.9048
rs 10
c 0
b 0
f 0
wmc 6

2 Methods

Rating   Name   Duplication   Size   Complexity  
A down() 0 3 1
A up() 0 23 5
1
<?php
2
/**
3
 * @link http://www.yiiframework.com/
4
 * @copyright Copyright (c) 2008 Yii Software LLC
5
 * @license http://www.yiiframework.com/license/
6
 */
7
8
use yii\db\Migration;
9
10
/**
11
 * Initializes Session tables.
12
 *
13
 * @author Misbahul D Munir <[email protected]>
14
 * @since 2.0.8
15
 */
16
class m160313_153426_session_init extends Migration
17
{
18
    /**
19
     * {@inheritdoc}
20
     */
21 21
    public function up()
22
    {
23 21
        $dataType = $this->binary();
24 21
        $tableOptions = null;
25
26 21
        switch ($this->db->driverName) {
27 21
            case 'mysql':
28
                // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
29 7
                $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
30 7
                break;
31 14
            case 'sqlsrv':
32 14
            case 'mssql':
33 14
            case 'dblib':
34
                $dataType = $this->text();
35
                break;
36
        }
37
38 21
        $this->createTable('{{%session}}', [
39 21
            'id' => $this->string()->notNull(),
40 21
            'expire' => $this->integer(),
41 21
            'data' => $dataType,
42 21
            'PRIMARY KEY ([[id]])',
43 21
        ], $tableOptions);
44 21
    }
45
46
    /**
47
     * {@inheritdoc}
48
     */
49 21
    public function down()
50
    {
51 21
        $this->dropTable('{{%session}}');
52 21
    }
53
}
54