/ database / migrations / 2023_12_21_082440_alter_roles_add_parents.php
2023_12_21_082440_alter_roles_add_parents.php
 1  <?php
 2  
 3  use Illuminate\Database\Migrations\Migration;
 4  use Illuminate\Database\Schema\Blueprint;
 5  use Illuminate\Support\Facades\Schema;
 6  
 7  return new class extends Migration
 8  {
 9      /**
10       * Run the migrations.
11       *
12       * @return void
13       */
14      public function up()
15      {
16          Schema::table('roles', function (Blueprint $table) {
17              $table->foreignId('parent_id')->nullable()->after('id')->references('id')->on('roles');
18          });
19      }
20  
21      /**
22       * Reverse the migrations.
23       *
24       * @return void
25       */
26      public function down()
27      {
28          Schema::table('roles', function (Blueprint $table) {
29              $table->dropForeign(['parent_id']);
30          });
31      }
32  };