Skip to content Skip to sidebar Skip to footer

Laravel Migration Can't Create Foreign Key

I'm trying to create a foreign key, artisan does not show me any errors, just does not create my foreign key, it's probably my code: 1° table: Schema::create('cooperados', functio

Solution 1:

Change your code from

$table->integer('id_coop')->unsigned;
$table->foreign('id_coop')->references('id')->on('cooperados');

To:

$table->unsignedBigInteger('id_coop')->index();
$table->foreign('id_coop')->references('id')->on('cooperados')->onDelete('cascade');

Or you can also use below code

$table->integer('id_coop')->unsigned()->index();
 $table->foreign('id_coop')->references('id')->on('cooperados')->onDelete('cascade');

Or also you can use below

$table->bigInteger('id_coop')->unsigned()->index();
$table->foreign('id_coop')->references('id')->on('cooperados')->onDelete('cascade');

Post a Comment for "Laravel Migration Can't Create Foreign Key"