Edit File - File Manager

Edit File: 2021_06_22_112207_create_permissions_table.php

<?php

use App\Models\Permission;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePermissionsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('permissions', function (Blueprint $table) {
            $table -> increments( 'id' );
            $table -> string( 'permission' );

$table -> integer( 'role_id' ) -> unsigned() -> index();
            $table -> foreign( 'role_id' ) -> references( 'id' ) -> on( 'roles' )
                   -> onUpdate( 'cascade' ) -> onDelete( 'cascade' );

$table -> timestamps();
        } );

$routes_data    = [];
        foreach (Route::getRoutes() as $route) {
            if ($route->getName()){
                $routes_data []   = [ 'role_id' => 1, 'permission' => $route->getName() ];
            }
        }
        Permission ::insert( $routes_data );
    }

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

Back to File Manager