m180509_092225_create_articles_table::safeDown() - Code Metrics - Inspection of "Improve all project" - itstructure/yii2-template-simple - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( e41cc1...feed29 )

by Andrey

created 2020-07-26 16:47 UTC

m180509_092225_create_articles_table::safeDown() A

↳ Parent: m180509_092225_create_articles_table

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
nc	1
nop	0
dl	0
loc	24
rs	9.536
c	0
b	0
f	0

<?php

use yii\db\Migration;

/**
 * Handles the creation of table `articles`.
 */
class m180509_092225_create_articles_table extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->createTable('articles',
            [
                'id' => $this->primaryKey(),
                'pageId' => $this->integer(),
                'active' => $this->tinyInteger()->notNull()->defaultValue(0),
                'icon' => $this->string(128),
                'title' => $this->string(128),
                'description' => $this->text(),
                'content' => $this->text(),
                'metaKeys' => $this->string(128),
                'metaDescription' => $this->string(),
                'alias' => $this->string(128),
                'created_at' => $this->dateTime(),
                'updated_at' => $this->dateTime(),
            ]
        );

        $this->createIndex(
            'idx-articles-pageId',
            'articles',
            'pageId'
        );

        $this->addForeignKey(
            'fk-articles-pageId',
            'articles',
            'pageId',
            'pages',
            'id',
            'SET NULL'
        );

        $this->createIndex(
            'idx-articles-active',
            'articles',
            'active'
        );

        $this->createIndex(
            'idx-articles-alias',
            'articles',
            'alias'
        );
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        $this->dropIndex(
            'idx-articles-alias',
            'articles'
        );

        $this->dropIndex(
            'idx-articles-active',
            'articles'
        );

        $this->dropForeignKey(
            'fk-articles-pageId',
            'articles'
        );

        $this->dropIndex(
            'idx-articles-pageId',
            'articles'
        );

        $this->dropTable('articles');
    }
}


1			<?php
2
3			use yii\db\Migration;
4
5			/**
6			* Handles the creation of table `articles`.
7			*/
8			class m180509_092225_create_articles_table extends Migration
9			{
10			/**
11			* {@inheritdoc}
12			*/
13			public function safeUp()
14			{
15			$this->createTable('articles',
16			[
17			'id' => $this->primaryKey(),
18			'pageId' => $this->integer(),
19			'active' => $this->tinyInteger()->notNull()->defaultValue(0),
20			'icon' => $this->string(128),
21			'title' => $this->string(128),
22			'description' => $this->text(),
23			'content' => $this->text(),
24			'metaKeys' => $this->string(128),
25			'metaDescription' => $this->string(),
26			'alias' => $this->string(128),
27			'created_at' => $this->dateTime(),
28			'updated_at' => $this->dateTime(),
29			]
30			);
31
32			$this->createIndex(
33			'idx-articles-pageId',
34			'articles',
35			'pageId'
36			);
37
38			$this->addForeignKey(
39			'fk-articles-pageId',
40			'articles',
41			'pageId',
42			'pages',
43			'id',
44			'SET NULL'
45			);
46
47			$this->createIndex(
48			'idx-articles-active',
49			'articles',
50			'active'
51			);
52
53			$this->createIndex(
54			'idx-articles-alias',
55			'articles',
56			'alias'
57			);
58			}
59
60			/**
61			* {@inheritdoc}
62			*/
63			public function safeDown()
64			{
65			$this->dropIndex(
66			'idx-articles-alias',
67			'articles'
68			);
69
70			$this->dropIndex(
71			'idx-articles-active',
72			'articles'
73			);
74
75			$this->dropForeignKey(
76			'fk-articles-pageId',
77			'articles'
78			);
79
80			$this->dropIndex(
81			'idx-articles-pageId',
82			'articles'
83			);
84
85			$this->dropTable('articles');
86			}
87			}
88

itstructure / yii2-template-simple

Push — master ( e41cc1...feed29 )

m180509_092225_create_articles_table::safeDown() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like