dpepbjp126917 2019-06-10 14:24
浏览 151
已采纳

通过laravel迁移添加'on update'和'on delete'外键约束

I am making my table like this...

    Schema::create('matched_merchants', function (Blueprint $table)
    {
        $table->increments('id')->unsigned();
        $table->integer('merchant_id')->unsigned();
        $table->integer('offer_id')->unsigned();
        $table->foreign('merchant_id')->references('id')->on('merchants')->onUpdate('cascade')->onDelete('restrict');
        $table->foreign('offer_id')->references('id')->on('offers')->onUpdate('cascade')->onDelete('restrict');
    });

Im adding 2 foreign keys both have onUpdate and onDelete constraints but only the update constraint gets added.

If i delete the onUpdate, it will correctly add the onDelete constraint.

I cannot add them separately because i get the error of duplicate key.

I could add them manually with a raw sql statement but if theres a right way to do it id rather do that.

  • 写回答

1条回答 默认 最新

  • douxiaochun4964 2019-06-10 14:49
    关注

    For some reason, if you set the columns as nullable(), Laravel sets the foreign keys correctly.

    That said, I can see that causing other problems, so I recommend doing the raw SQL statement.

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

报告相同问题?

悬赏问题

  • ¥20 Yolov5训练报错
  • ¥15 Unity发布gzip压缩的webgl之后让浏览器可以正常显示画面
  • ¥15 有没有人知道这种提示怎么关?现在不做ts项目了不知道咋关了,求解,现在我以前的js项目都是这种提示了
  • ¥15 为什么mysql做了碎片化处理data_free还是很高
  • ¥15 single positional indexer is out-of-bounds
  • ¥15 LSTM 模型数据量需要多少?
  • ¥15 mysql数据抓包开发报表
  • ¥15 linux系统下安装office打不开
  • ¥20 rsync脚本分发错误,文件不齐全
  • ¥15 labview顺序结构与时间延时