CreateWidgetsTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	62
Duplicated Lines	11.29 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	up()	7	40	1
A	down()	0	8	1

<?php

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

class CreateWidgetsTable extends Migration

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        DB::transaction(function () {
            Schema::create('widgets', function (Blueprint $table) {

The method create() does not exist on Illuminate\Support\Facades\Schema. Did you maybe mean createFreshMockInstance()?

                $table->increments('id');
                $table->unsignedInteger('extension_id')->index();
                $table->string('title')->index();
                $table->string('position', 20)->index();
                $table->string('template', 100)->default('default')->index();
                $table->string('custom_template', 100)->nullable()->index();
                $table->unsignedSmallInteger('order')->default(1);
                $table->boolean('published')->default(true)->index();
                $table->boolean('show_title')->default(true)->index();
                $table->boolean('authenticated')->default(false)->index();
                $table->text('body')->nullable();
                $table->text('parameters')->nullable();
                $table->string('authorization', 20)->default('can');
                $table->unsignedInteger('created_by')->nullable()->index();
                $table->unsignedInteger('updated_by')->nullable()->index();
                $table->timestamps();

                $table->foreign('extension_id')->references('id')->on('extensions');
            });

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

The method create() does not exist on Illuminate\Support\Facades\Schema. Did you maybe mean createFreshMockInstance()?

This code seems to be duplicated across your project.

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

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

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

The method create() does not exist on Illuminate\Support\Facades\Schema. Did you maybe mean createFreshMockInstance()?

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

                $table->foreign('widget_id')->references('id')->on('widgets')->onDelete('cascade');
            });
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        DB::transaction(function () {
            Schema::drop('widget_menu');
            Schema::drop('widget_permission');
            Schema::drop('widgets');
        });
    }
}