php - 迁移 Laravel 5.8 时出错外键

Question

我在 Laravel 5.8 上有一个错误

我在外键约束上遇到错误。这是我的架构..

public function up()
{
    Schema::create('subcategories', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->integer('category_id')->unsigned();
        $table->string('name');
        $table->timestamps();

        $table->foreign('category_id')->references('id')->on('categories');
    });
}

    public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->timestamps();
        });
    }

标签： phplaravelmigrationlaravel-5.8

Answer 1

试试这个

Schema::create('subcategories', function (Blueprint $table) {
    $table->bigIncrements('id');
    $table->bigInteger('category_id')->unsigned();
    $table->foreign('category_id')->references('id')->on('categories')->onDelete('cascade');
    $table->string('name');
    $table->timestamps();
});