mysql - 如何在 Laravel 中重命名外键

Question

我想在 Laravel 中重命名外键。

我是这样创建的:

Schema::create('holidays', function (Blueprint $table) {
    $table->increments('id');
    $table->timestamps();
    $table->integer('account_id')->unsigned();
    $table->date('holiday_date');
});

if (Schema::hasTable('accounts')) {
    Schema::table(
        'holidays',
        function (Blueprint $table) {
            $table->foreign('account_id')->references('id')->on('accounts')->onDelete('cascade');
        }
    );
}

现在，我想将 account_id 更改为 engagement_id。如何做到这一点？

Answer 1

应该是这样的:

注意:重命名foreign之前，必须先删除旧的foreign并分配新的

class RenameColumn extends Migration
{

    public function up()
    {
        Schema::table('holidays', function(Blueprint $table) {
            $table->dropForeign('holidays_account_id_foreign');
            $table->renameColumn('account_id', 'engagement_id');

            $table->foreign('engagement_id')->references('id')->on('accounts')->onDelete('cascade');
        });
    }

    public function down()
    {
        Schema::table('holidays', function(Blueprint $table) {
            $table->dropForeign('holidays_engagement_id_foreign');
            $table->renameColumn('account_id', 'engagement_id');

            $table->foreign('account_id')->references('id')->on('accounts')->onDelete('cascade');
        });
    }
}