m170507_131103_createUsernameTable::up() - Code Metrics - rhosocial/yii2-user - Measure and Improve Code Quality continuously with Scrutinizer

m170507_131103_createUsernameTable::up() A
last analyzed 2019-04-13 05:43 UTC

↳ Parent: m170507_131103_createUsernameTable

Complexity

Conditions	2
Paths	2

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	19
rs	9.6333
c	0
b	0
f	0
cc	2
nc	2
nop	0

<?php

/**
 *  _   __ __ _____ _____ ___  ____  _____
 * | | / // // ___//_  _//   ||  __||_   _|
 * | |/ // /(__  )  / / / /| || |     | |
 * |___//_//____/  /_/ /_/ |_||_|     |_|
 * @link https://vistart.me/
 * @copyright Copyright (c) 2016 - 2017 vistart
 * @license https://vistart.me/license/
 */
namespace rhosocial\user\models\migrations;

use rhosocial\user\migrations\Migration;
use rhosocial\user\models\Username;
use rhosocial\user\User;

/**
 * Class m170507_131103_createUsernameTable
 * @version 1.0
 * @author vistart <[email protected]>
 */
class m170507_131103_createUsernameTable extends Migration
{
    public function up()
    {
        $tableOptions = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        if ($this->db->driverName == 'mysql') {
            // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
            $tableOptions = "CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB COMMENT='Username'";
            $this->createTable(Username::tableName(), [
                'guid' => $this->varbinary(16)->notNull()->comment('User GUID'),
                'content' => $this->varchar(32)->charset('utf8mb4')->collate('utf8mb4_unicode_ci')->defaultValue('')->notNull()->comment('Username'),
                'ip' => $this->varbinary(16)->defaultValue(0)->notNull()->comment('IP Address'),
                'ip_type' => $this->smallInteger()->defaultValue(4)->notNull()->comment('IP Address Type'),
                'created_at' => $this->dateTime()->notNull()->defaultValue('1970-01-01 00:00:00')->comment('Created At'),
                'updated_at' => $this->dateTime()->notNull()->defaultValue('1970-01-01 00:00:00')->comment('Updated At'),
            ], $tableOptions);
        }
        $this->addPrimaryKey('user_username_guid_pk', Username::tableName(), 'guid');
        $this->addForeignKey('user_username_fk', Username::tableName(), 'guid', User::tableName(), 'guid', 'CASCADE', 'CASCADE');
        $this->createIndex('username_unique', Username::tableName(), 'content', true);
    }

    public function down()
    {
        $this->dropTable(Username::tableName());
    }

    /*
    // Use safeUp/safeDown to run migration code within a transaction
    public function safeUp()
    {
    }

    public function safeDown()
    {
    }
    */
}


1			<?php
2
3			/**
4			* _ __ __ _____ _____ ___ ____ _____
5			* \| \| / // // ___//_ _// \|\| __\|\|_ _\|
6			* \| \|/ // /(__ ) / / / /\| \|\| \| \| \|
7			* \|___//_//____/ /_/ /_/ \|_\|\|_\| \|_\|
8			* @link https://vistart.me/
9			* @copyright Copyright (c) 2016 - 2017 vistart
10			* @license https://vistart.me/license/
11			*/
12			namespace rhosocial\user\models\migrations;
13
14			use rhosocial\user\migrations\Migration;
15			use rhosocial\user\models\Username;
16			use rhosocial\user\User;
17
18			/**
19			* Class m170507_131103_createUsernameTable
20			* @version 1.0
21			* @author vistart <[email protected]>
22			*/
23			class m170507_131103_createUsernameTable extends Migration
24			{
25			public function up()
26			{
27			$tableOptions = null;
			0 ignored issues – show Unused Code introduced 2017-06-14 09:44 UTC by Report Bug Copy Issue Report `$tableOptions` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
28			if ($this->db->driverName == 'mysql') {
29			// http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
30			$tableOptions = "CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB COMMENT='Username'";
31			$this->createTable(Username::tableName(), [
32			'guid' => $this->varbinary(16)->notNull()->comment('User GUID'),
33			'content' => $this->varchar(32)->charset('utf8mb4')->collate('utf8mb4_unicode_ci')->defaultValue('')->notNull()->comment('Username'),
34			'ip' => $this->varbinary(16)->defaultValue(0)->notNull()->comment('IP Address'),
35			'ip_type' => $this->smallInteger()->defaultValue(4)->notNull()->comment('IP Address Type'),
36			'created_at' => $this->dateTime()->notNull()->defaultValue('1970-01-01 00:00:00')->comment('Created At'),
37			'updated_at' => $this->dateTime()->notNull()->defaultValue('1970-01-01 00:00:00')->comment('Updated At'),
38			], $tableOptions);
39			}
40			$this->addPrimaryKey('user_username_guid_pk', Username::tableName(), 'guid');
41			$this->addForeignKey('user_username_fk', Username::tableName(), 'guid', User::tableName(), 'guid', 'CASCADE', 'CASCADE');
42			$this->createIndex('username_unique', Username::tableName(), 'content', true);
43			}
44
45			public function down()
46			{
47			$this->dropTable(Username::tableName());
48			}
49
50			/*
51			// Use safeUp/safeDown to run migration code within a transaction
52			public function safeUp()
53			{
54			}
55
56			public function safeDown()
57			{
58			}
59			*/
60			}
61

rhosocial / yii2-user

m170507_131103_createUsernameTable::up() A last analyzed 2019-04-13 05:43 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

m170507_131103_createUsernameTable::up() A
last analyzed 2019-04-13 05:43 UTC