CreateMenusTable::up() - Code Metrics - yajra/cms-core - Measure and Improve Code Quality continuously with Scrutinizer

CreateMenusTable::up() A
last analyzed 2017-02-08 14:31 UTC

↳ Parent: CreateMenusTable

Complexity

Conditions	1
Paths	1

Size

Total Lines	48
Code Lines	37

Duplication

Lines	7
Ratio	14.58 %

Importance

Changes

Metric	Value
cc	1
eloc	37
nc	1
nop	0
dl	7
loc	48
rs	9.125
c	0
b	0
f	0

<?php

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

class CreateMenusTable extends Migration
namespace YourVendor;

class YourClass { }
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        DB::transaction(function () {
            Schema::create('navigation', function (Blueprint $table) {
                $table->increments('id');
                $table->string('title');
                $table->string('type')->unique()->index();
                $table->boolean('published')->default(true)->index();
                $table->unsignedInteger('created_by')->nullable()->index();
                $table->unsignedInteger('updated_by')->nullable()->index();
                $table->timestamps();
            });

            Schema::create('menus', function (Blueprint $table) {
                $table->increments('id');
                $table->unsignedInteger('navigation_id')->nullable()->index();
                $table->unsignedInteger('extension_id')->nullable()->index();
                $table->string('title');
                $table->string('url');
                $table->unsignedInteger('parent_id')->nullable()->index();
                $table->unsignedInteger('lft')->nullable()->index();
                $table->unsignedInteger('rgt')->nullable()->index();
                $table->unsignedInteger('depth')->nullable();
                $table->string('icon')->default('link');
                $table->boolean('published')->default(false)->index();
                $table->boolean('authenticated')->default(false)->index();
                $table->string('authorization', 20)->default('can');
                $table->tinyInteger('order')->default(1);
                $table->tinyInteger('target')->default(0);
                $table->text('parameters')->nullable();

                $table->unsignedInteger('created_by')->nullable()->index();
                $table->unsignedInteger('updated_by')->nullable()->index();
                $table->timestamps();

                $table->foreign('navigation_id')->references('id')->on('navigation')->onDelete('cascade');
                $table->foreign('extension_id')->references('id')->on('extensions')->onDelete('cascade');
            });

            Schema::create('menu_permission', function (Blueprint $table) {

                $table->unsignedInteger('menu_id')->index();
                $table->unsignedInteger('permission_id')->index();

                $table->foreign('menu_id')->references('id')->on('menus')->onDelete('cascade');
                $table->foreign('permission_id')->references('id')->on('permissions')->onDelete('cascade');
            });
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        DB::transaction(function () {
            Schema::drop('menu_permission');
            Schema::drop('menus');
            Schema::drop('navigation');
        });
    }
}


1		<?php
2
3		use Illuminate\Database\Migrations\Migration;
4		use Illuminate\Database\Schema\Blueprint;
5		use Illuminate\Support\Facades\DB;
6
7		class CreateMenusTable extends Migration
		0 ignored issues – show Coding Style Compatibility introduced 2016-11-19 06:49 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
8		{
9		/**
10		* Run the migrations.
11		*
12		* @return void
13		*/
14		public function up()
15		{
16		DB::transaction(function () {
17		Schema::create('navigation', function (Blueprint $table) {
18		$table->increments('id');
19		$table->string('title');
20		$table->string('type')->unique()->index();
21		$table->boolean('published')->default(true)->index();
22		$table->unsignedInteger('created_by')->nullable()->index();
23		$table->unsignedInteger('updated_by')->nullable()->index();
24		$table->timestamps();
25		});
26
27		Schema::create('menus', function (Blueprint $table) {
28		$table->increments('id');
29		$table->unsignedInteger('navigation_id')->nullable()->index();
30		$table->unsignedInteger('extension_id')->nullable()->index();
31		$table->string('title');
32		$table->string('url');
33		$table->unsignedInteger('parent_id')->nullable()->index();
34		$table->unsignedInteger('lft')->nullable()->index();
35		$table->unsignedInteger('rgt')->nullable()->index();
36		$table->unsignedInteger('depth')->nullable();
37		$table->string('icon')->default('link');
38		$table->boolean('published')->default(false)->index();
39		$table->boolean('authenticated')->default(false)->index();
40		$table->string('authorization', 20)->default('can');
41		$table->tinyInteger('order')->default(1);
42		$table->tinyInteger('target')->default(0);
43		$table->text('parameters')->nullable();
44
45		$table->unsignedInteger('created_by')->nullable()->index();
46		$table->unsignedInteger('updated_by')->nullable()->index();
47		$table->timestamps();
48
49		$table->foreign('navigation_id')->references('id')->on('navigation')->onDelete('cascade');
50		$table->foreign('extension_id')->references('id')->on('extensions')->onDelete('cascade');
51		});
52
53	View Code Duplication	Schema::create('menu_permission', function (Blueprint $table) {
		0 ignored issues – show Duplication introduced 2016-11-19 06:49 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
54		$table->unsignedInteger('menu_id')->index();
55		$table->unsignedInteger('permission_id')->index();
56
57		$table->foreign('menu_id')->references('id')->on('menus')->onDelete('cascade');
58		$table->foreign('permission_id')->references('id')->on('permissions')->onDelete('cascade');
59		});
60		});
61		}
62
63		/**
64		* Reverse the migrations.
65		*
66		* @return void
67		*/
68		public function down()
69		{
70		DB::transaction(function () {
71		Schema::drop('menu_permission');
72		Schema::drop('menus');
73		Schema::drop('navigation');
74		});
75		}
76		}
77

yajra / cms-core

CreateMenusTable::up() A last analyzed 2017-02-08 14:31 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CreateMenusTable::up() A
last analyzed 2017-02-08 14:31 UTC