php - 如何使用具有默认值的 foreignId-constrained？

Question

刚刚从视频教程中注意到Laravel有这个foreignId-constrained。所以我尝试将我的代码从 method.1 更改为 method.2，表已迁移，但是当我尝试 db:seed 时，默认值无效(它在下面返回错误)。

(方法一)

$table->unsignedBigInteger('status_id')->default(1);

$table->foreign('status_id')
    ->references('id')
    ->on('user_statuses');

(方法二)

$table->foreignId('status_id')->constrained('user_statuses')->default(1);

(使用方法 2 返回错误)

SQLSTATE[HY000]: General error: 1364 Field 'status_id' doesn't have a defaultvalue (SQL: insert into users (username, password) values (admin, $2y$10$SZUIglBQG/HhS/18zn41GOcH8f.hZaNewmyoGJBfDQchfC6OWdx26))

Answer 1

According to the documentation ，您以错误的顺序调用方法:

Any additional column modifiers must be called before the constrained method

$table->foreignId('status_id')->default(1)->constrained('user_statuses');