+global\RbacSetupTables::up()

Complexity

Conditions	2
Paths	2

Size

Total Lines	63
Code Lines	39

Duplication

Lines	17
Ratio	26.98 %

Importance

Changes

0

<?php
    public function up()
    {
        // Create table for admin user
        if ($this->userTable != 'users') {
            Schema::create($this->userTable, function (Blueprint $table) {

This code seems to be duplicated across your project.

                $table->engine = "InnoDB COMMENT='管理员表'";
                $table->increments('id');
                $table->string('name')->unique()->comment('名称');
                $table->string('email')->nullable()->unique()->comment('邮箱');
                $table->string('password')->nullable()->comment('密码');
                $table->rememberToken();
                $table->timestamps();
            });
        }

        // Create table for storing roles
        Schema::create('roles', function (Blueprint $table) {

This code seems to be duplicated across your project.

            $table->engine = "InnoDB COMMENT='角色表'";
            $table->increments('id');
            $table->string('name')->unique()->comment('名称');
            $table->string('display_name')->nullable()->comment('显示名');
            $table->string('description')->nullable()->comment('备注');
            $table->timestamps();
        });

        // Create table for associating roles to users (Many-to-Many)
        Schema::create('role_user', function (Blueprint $table) {
            $table->engine = "InnoDB COMMENT='角色与用户对应表'";
            $table->integer($this->userForeignKey)->unsigned()->comment('管理员ID');
            $table->integer('role_id')->unsigned()->comment('角色ID');

            /*$table->foreign('uid')->references('id')->on('users')

78% of this comment could be valid code. Did you maybe forget this after debugging?

                ->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('role_id')->references('id')->on('roles')
                ->onUpdate('cascade')->onDelete('cascade');*/

            $table->primary([$this->userForeignKey, 'role_id']);
        });

        // Create table for storing permissions
        Schema::create('permissions', function (Blueprint $table) {
            $table->engine = "InnoDB COMMENT='权限（即菜单）表'";
            $table->increments('id')->comment('主键');
            $table->integer('pid')->comment('父ID');
            $table->string('icon', 100)->comment('图标class');
            $table->string('display_name', 200)->comment('显示名称');
            $table->string('name', 100)->comment('名称');
            $table->tinyInteger('is_menu')->comment('是否作为菜单')->default('1');
            $table->tinyInteger('sort')->unsigned()->comment('排序');
            $table->string('description')->nullable()->comment('描述');
            $table->timestamps();
            $table->index('pid');
        });

        // Create table for associating permissions to roles (Many-to-Many)
        Schema::create('permission_role', function (Blueprint $table) {
            $table->engine = "InnoDB COMMENT='权限与角色对应表'";
            $table->integer('permission_id')->unsigned()->comment('权限ID');
            $table->integer('role_id')->unsigned()->comment('角色ID');

            $table->primary(['permission_id', 'role_id']);
        });
    }