CreateUserPermissionTable

Complexity

Total Complexity

3

Size/Duplication

Total Lines	24
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	7	1
A	up()	0	3	1
A	createPivot()	0	8	1

<?php

use Helldar\Roles\Support\Database\BaseMigration;
use Illuminate\Database\Schema\Blueprint;

class CreateUserPermissionTable extends BaseMigration
{
    public function up()
    {
        $this->createPivot($this->user_permission, $this->users, $this->permissions, 'user_id', 'permission_id');
    }

    public function down()
    {
        $this->schema()->disableForeignKeyConstraints();

        $this->dropTables($this->user_permission);

        $this->schema()->enableForeignKeyConstraints();
    }

    protected function createPivot(string $table, string $first_table, string $second_table, string $first_key, string $second_key)
    {
        $this->create($table, function (Blueprint $table) use ($first_table, $second_table, $first_key, $second_key) {
            $table->unsignedBigInteger($first_key)->index();
            $table->unsignedBigInteger($second_key);

            $table->foreign($first_key)->references('id')->on($first_table)->onDelete('cascade');
            $table->foreign($second_key)->references('id')->on($second_table)->onDelete('cascade');
        });
    }
}