Edit File: 2023_10_17_012604_create_categories_table.php
<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateCategoriesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('categories', function (Blueprint $table) { $table->id(); $table->text('name'); $table->text('image')->nullable(); $table -> unsignedBigInteger( 'parent_id' ) -> unsigned() -> index()->nullable(); $table -> foreign( 'parent_id' ) -> references( 'id' ) -> on( 'categories' )-> onDelete( 'cascade' ); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('categories'); } }
Back to File Manager