laravel - PHP Laravel 迁移
问题描述
这次迁移有什么问题,它仍然给我错误:
public function up()
{
Schema::create('menus', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('name');
$table->boolean('visibility');
$table->integer('priority');
$table->unsignedBigInteger('category_id');
$table->timestamps();
$table->string('tag');
$table->unsignedBigInteger('created_by_user_id')->index();
$table->foreign('created_by_user_id')->references('id')->on('users');
});
}
SQLSTATE[HY000]:一般错误:1005 无法创建表
menu
。menus
(errno: 150 "Foreign key constraint is wrongly forms") (SQL: alter tablemenus
add constraintmenus_created_by_user_id_foreign
foreign key (created_by_user_id
) reference susers
(id
))