Laravel Table Migration: Cannot add foreign key constraint

Question

I'm trying to create foreign keys in Laravel however when I migrate my table using artisan I am thrown the following error:

Modules migration table:

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateModulesTable extends Migration {
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up() {
        Schema::create('modules', function (Blueprint $table) {
            $table->id();
            $table->string('module_name');

            // foreign key

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down() {
        Schema::dropIfExists('modules');
    }
}

Lesson migration table:

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateLessonTable extends Migration {
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up() {
        Schema::create('lesson', function (Blueprint $table) {
            $table->id();
            $table->string('title');
            $table->integer('module_id')->unsigned();
            $table->text('content');
            $table->integer('created_by')->unsigned();
            $table->integer('updated_by');
            $table->string('enabled');
            $table->string('position');
            $table->timestamps();
        });

        Schema::table('lesson', function(Blueprint $table) {
            $table->foreign('module_id')->references('id')->on('modules');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down() {
        Schema::dropIfExists('lesson');
    }
}

Any ideas as to what I've done wrong, I want to get this right now, as I've got a lot of tables I need to create e.g. Users, Clients, Projects, Tasks, Statuses, Priorities, Types, Teams. Ideally, I want to create tables that hold this data with the foreign keys, i..e clients_project and project_tasks, etc.

Hope someone can help me to get started.

In which migration you are getting error? $table->unsignedBigInteger('module_id'); try this — Jayant
– Jayant, Commented Jun 14, 2021 at 4:52
Does this answer your question? Migration: Cannot add foreign key constraint — zahid hasan emon
– zahid hasan emon, Commented Jun 14, 2021 at 5:14

Biswajit Biswas · Accepted Answer · 2021-06-14 05:23:41Z

2

Add unsignedBigInteger for module_id column

Schema::create('lesson', function (Blueprint $table) {
  $table->id();
  $table->string('title');
  $table->unsignedBigInteger('module_id');
  $table->text('content');
  $table->integer('created_by')->unsigned();
  $table->integer('updated_by');
  $table->string('enabled');
  $table->string('position');
  $table->timestamps();
  $table->foreign('module_id')->references('id')->on('modules');
});

edited Jun 14, 2021 at 5:23

Biswajit Biswas

1,07512 silver badges22 bronze badges

answered Jun 14, 2021 at 5:07

mk23

1,4131 gold badge14 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hedayatullah Sarwary · Accepted Answer · 2021-06-14 08:38:09Z

1

Your foreign_key field and your id should be of the same type, for example, if modules.id is bigIncrements, your foreign_key inside your Lesson table also should be bigInteger.

Lesson Migration File

Schema::create('lesson', function (Blueprint $table) {
    $table->id();
    $table->string('title');
    $table->integer('module_id')->unsigned()->nullable();
    $table->foreign('module_id')->references('id')->on('modules')->onDelete('cascade');
    $table->text('content');
    $table->integer('created_by')->unsigned();
    $table->integer('updated_by');
    $table->string('enabled');
    $table->string('position');
    $table->timestamps();
});

Note: You should make sure, your Modules table migration is running before Lesson table migration.

edited Jun 14, 2021 at 8:38

answered Jun 14, 2021 at 5:13

Hedayatullah Sarwary

2,8483 gold badges27 silver badges40 bronze badges

Collectives™ on Stack Overflow

Laravel Table Migration: Cannot add foreign key constraint

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related