m140602_111327_create_menu_table::down() - Code Metrics - toir427/yii2-admin - Measure and Improve Code Quality continuously with Scrutinizer

m140602_111327_create_menu_table::down() A
last analyzed 2020-10-27 09:18 UTC

↳ Parent: m140602_111327_create_menu_table

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	1
dl	0
loc	3
c	1
b	0
f	0
rs	10
cc	1
nc	1
nop	0

<?php

use toir427\admin\components\Configs;

/**
 * Migration table of table_menu
 * 
 * @author Misbahul D Munir <[email protected]>
 * @since 1.0
 */
class m140602_111327_create_menu_table extends \yii\db\Migration
{

    /**
     * @inheritdoc
     */
    public function up()
    {
        $menuTable = Configs::instance()->menuTable;
        $tableOptions = null;
        if ($this->db->driverName === 'mysql') {
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB';
        }

        $this->createTable($menuTable, [
            'id' => $this->primaryKey(),
            'name' => $this->string(128)->notNull(),
            'parent' => $this->integer(),
            'route' => $this->string(),
            'order' => $this->integer(),
            'data' => $this->binary(),
            "FOREIGN KEY ([[parent]]) REFERENCES {$menuTable}([[id]]) ON DELETE SET NULL ON UPDATE CASCADE",
        ], $tableOptions);
    }

    /**
     * @inheritdoc
     */
    public function down()
    {
        $this->dropTable(Configs::instance()->menuTable);
    }
}


1			<?php
2
3			use toir427\admin\components\Configs;
4
5			/**
6			* Migration table of table_menu
7			*
8			* @author Misbahul D Munir <[email protected]>
9			* @since 1.0
10			*/
11			class m140602_111327_create_menu_table extends \yii\db\Migration
12			{
13
14			/**
15			* @inheritdoc
16			*/
17			public function up()
18			{
19			$menuTable = Configs::instance()->menuTable;
20			$tableOptions = null;
21			if ($this->db->driverName === 'mysql') {
22			$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB';
23			}
24
25			$this->createTable($menuTable, [
26			'id' => $this->primaryKey(),
27			'name' => $this->string(128)->notNull(),
28			'parent' => $this->integer(),
29			'route' => $this->string(),
30			'order' => $this->integer(),
31			'data' => $this->binary(),
32			"FOREIGN KEY ([[parent]]) REFERENCES {$menuTable}([[id]]) ON DELETE SET NULL ON UPDATE CASCADE",
33			], $tableOptions);
34			}
35
36			/**
37			* @inheritdoc
38			*/
39			public function down()
40			{
41			$this->dropTable(Configs::instance()->menuTable);
42			}
43			}
44

toir427 / yii2-admin

m140602_111327_create_menu_table::down() A last analyzed 2020-10-27 09:18 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

m140602_111327_create_menu_table::down() A
last analyzed 2020-10-27 09:18 UTC