Laravel多对一同一表迁移

Question

我有这个迁移代码

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateAvatarsTable extends Migration
{

    public function up()
    {
        Schema::create('avatars', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name', 100)->nullable();
            $table->string('filename', 255)->nullable();
            $table->text('detail')->nullable();
            $table->text('pos_x')->nullable();
            $table->text('pos_y')->nullable();

            $table->integer('avatars_id')->nullable();
              $table->foreign('avatars_id')->references('id')->on('avatars')->onUpdate('cascade')->onDelete('cascade');

            $table->softDeletes();
            $table->timestamps();
        });
    }


    public function down()
    {
        Schema::dropIfExists('avatars');
    }
}

当我运行生成迁移的代码时

php artisan migrate:refresh

我得到了这个结果：

[照明\Database\QueryException]SQLSTATE[42000]：语法错误或访问冲突：1103不正确的表名"（SQL：更改表头像添加con straintavatars_avatars_id_foreign外键（avatars_id）引用"（id）删除级联）

[条令\DBAL\Driver\PDOException]SQLSTATE[42000]：语法错误或访问冲突：1103不正确的表名“”

[PDOException]SQLSTATE[42000]：语法错误或访问冲突：1103不正确的表名“”

Answer 1

您正试图在尚不存在的表上设置引用；按以下方式尝试：

public function up() {
  Schema::create('avatars', function(Blueprint $table) {
    $table - > increments('id');
    $table - > string('name', 100) - > nullable();
    $table - > string('filename', 255) - > nullable();
    $table - > text('detail') - > nullable();
    $table - > text('pos_x') - > nullable();
    $table - > text('pos_y') - > nullable();
    $table - > integer('avatars_id') - > nullable();
    $table - > softDeletes();
    $table - > timestamps();
  })

  Schema::table('avatars', function($table) {
    $table - > foreign('avatars_id') - > references('id') - > on('avatars') - > onUpdate('cascade') - > onDelete('cascade');
  });

}

Answer 2

字段id使用无符号整数数据类型

$table->unsignedInteger('avatars_id')->nullable();

Answer 3

更改以下行

$table->integer('avatars_id')->nullable();

到

$table->integer('avatars_id')->unsigned();

因为外键id应该是无符号整数