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 };