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"