CreateUserRoleTable::up() - Code Metrics - Inspection of "Merge pull request #57 from butcherman/dev4" - butcherman/Tech_Bench - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — master (2f299a)

by Ron

created 2018-12-20 16:54 UTC

CreateUserRoleTable::up() A

↳ Parent: CreateUserRoleTable

Complexity

Conditions	1
Paths	1

Size

Total Lines	11
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUserRoleTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('user_role', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned();
            $table->integer('role_id')->unsigned();
            $table->foreign('user_id')->references('user_id')->on('users')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('role_id')->references('role_id')->on('roles')->onUpdate('cascade');
        });
        
        DB::insert('INSERT INTO `user_role` (`user_id`, `role_id`) VALUES (?, ?)', [1, 1]);
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('user_role');
    }
}


1			<?php
2
3			use Illuminate\Support\Facades\Schema;
4			use Illuminate\Database\Schema\Blueprint;
5			use Illuminate\Database\Migrations\Migration;
6
7			class CreateUserRoleTable extends Migration
8			{
9			/**
10			* Run the migrations.
11			*
12			* @return void
13			*/
14			public function up()
15			{
16			Schema::create('user_role', function (Blueprint $table) {
17			$table->increments('id');
18			$table->integer('user_id')->unsigned();
19			$table->integer('role_id')->unsigned();
20			$table->foreign('user_id')->references('user_id')->on('users')->onUpdate('cascade')->onDelete('cascade');
21			$table->foreign('role_id')->references('role_id')->on('roles')->onUpdate('cascade');
22			});
23
24			DB::insert('INSERT INTO `user_role` (`user_id`, `role_id`) VALUES (?, ?)', [1, 1]);
25			}
26
27			/**
28			* Reverse the migrations.
29			*
30			* @return void
31			*/
32			public function down()
33			{
34			Schema::dropIfExists('user_role');
35			}
36			}
37

butcherman / Tech_Bench

Branch — master (2f299a)

CreateUserRoleTable::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like