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

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');

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 keepalive配置业务服务双机单活的方法。业务服务一定是要双机单活的方式
  • ¥50 关于多次提交POST数据后,无法获取到POST数据参数的问题
  • ¥15 win10,这种情况怎么办
  • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
  • ¥100 在连接内网VPN时,如何同时保持互联网连接
  • ¥15 MATLAB中使用parfor,矩阵Removal的有效索引在parfor循环中受限制
  • ¥20 Win 10 LTSC 1809版本如何无损提升到20H1版本
  • ¥50 win10 LTSC 虚拟键盘不弹出
  • ¥30 微信小程序请求失败,网页能正常带锁访问
  • ¥15 Matlab求解微分方程,如何用fish2d进行预优?