doutu7123
2018-08-03 09:56
浏览 110
已采纳

Laravel将外键添加到表中

I am trying to add a permission_id foreign key to my users table which shall reference the id in my permissions table. Currently I built following Migration:

<?php
class AddPermissionIdForeignKeyToUsersTable extends Migration
{
    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->unsignedInteger('permission_id')->after('id');
            $table->foreign('permission_id')->references('id')->on('permissions')->onDelete('cascade');
        });
    }

    public function down()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->dropColumn('permission_id');
        });
    }
}

But I get following error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (eyes.#sql-22f0_3dd, CONSTRAINT users_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES p ermissions (id) ON DELETE CASCADE) (SQL: alter table users add constraint users_permission_id_foreign foreign key (permission_id) references permissions (id) on delete cascade)

In PDOStatement.php line 144:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (eyes.#sql-22f0_3dd, CONSTRAINT users_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES p ermissions (id) ON DELETE CASCADE)

In PDOStatement.php line 142:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (eyes.#sql-22f0_3dd, CONSTRAINT users_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES p ermissions (id) ON DELETE CASCADE)

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongshan7708 2018-08-03 10:27
    已采纳

    If you have already data in your table users you need to declare your field permission_id as nullable.

    $table->unsignedInteger('permission_id')->nullable()->after('id');

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题