Laravel migration, can't create foreign key

Question

Those are the following migration files:

User migration

Schema::create('users', function (Blueprint $table) {
    $table->uuid('id');
    $table->string('name');
    $table->string('email')->unique();
    $table->timestamps();
});

Log migration

Schema::create('log', function (Blueprint $table) {
    $table->uuid('id');
    $table->boolean('statu');
    $table->timestamps();
    $table->foreign('id')->references('id')->on('users')->onDelete('cascade');
});

When I run the migrations it shows:

PDOException::("SQLSTATE[HY000]: General error: 1005 Can't create table laravel.log (errno: 150 "Foreign key constraint is incorrectly formed")")

I also tried:

Schema::create('log', function (Blueprint $table) {
    $table->uuid('id');
    $table->boolean('statu');
    $table->timestamps();
});

Schema::table('log', function($table) {
    $table->foreign('id')
        ->references('id')
        ->on('users')
        ->onDelete('cascade');
});

Schema::create('log', function (Blueprint $table) {
    $table->uuid('id')->primary();
    $table->foreignUuid('foreign_id');
    $table->boolean('statu');
    $table->timestamps();
});

Schema::table('log', function($table) {
    $table->foreign('foreign_id')
        ->references('id')
        ->on('users')
        ->onDelete('cascade');
});

But still not working.

-- I have solved this problem

User

 Schema::create('users', function (Blueprint $table) {
            $table->uuid('id')->primary();
            $table->string('name');
            $table->string('email')->unique();
            $table->timestamps();
        });

log

Schema::create('log', function (Blueprint $table) {
            $table->uuid('id')->primary();
            $table->foreignUuid('user_id');
            $table->boolean('statu');
            $table->timestamps();
        });
        Schema::table('log', function($table) {
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
    
        });

Check data type of columns used in foreign key, they must be exact same. — Insane Skull, Mar 09 '23 at 10:18
Are you sure the migration of the users table is running before the log? — Troyer, Mar 09 '23 at 10:21

Karl · Answer 1 · 2023-03-09T10:48:55.090

2

Try adding to your users table :

$table->uuid('id')->primary();

Nothing here indicate to you database that id is the primary key.

Then you should call your foreign key as "name_of_the_table"_id. For you it should be :

$table->foreignUuid('foreign_id');

And finally you can add :

$table->foreignUuid('user_id')->constrained();

The complete code is something like that :

Schema::create('users', function (Blueprint $table) {
        $table->uuid('id')->primary();
        $table->string('name');
        $table->string('email')->unique();
        $table->timestamps();
    });

 Schema::create('log', function (Blueprint $table) {
        $table->uuid('id');
        $table->boolean('statu');
        $table->timestamps();
        $table->foreignUuid('user_id')->constrained();
    });

edited Mar 09 '23 at 10:48

answered Mar 09 '23 at 10:25

Karl

79
7

Little typo: it's `constrained()` – brombeer Mar 09 '23 at 10:28
You right sorry i didn't read my post before add it ^^ – Karl Mar 09 '23 at 10:48
Thanks dude , I have solved this issue – Bin Mar 10 '23 at 03:25
if this solution is the good one can you check it for those who can need it in the future please? Explications can help someone – Karl Mar 10 '23 at 08:02

score -1 · Answer 2 · answered Mar 09 '23 at 10:23

-1

Please use $table->id(); instead of $table->uuid('id');

answered Mar 09 '23 at 10:23

Sontus chandra Anik

1
2

2

Why? How would OP use UUIDs then? – brombeer Mar 09 '23 at 10:28

Laravel migration, can't create foreign key

User migration

Log migration

2 Answers2