首页 > 解决方案 > 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 无法创建表menumenus(errno: 150 "Foreign key constraint is wrongly forms") (SQL: alter table menusadd constraint menus_created_by_user_id_foreignforeign key ( created_by_user_id) reference s users( id))

标签: laravelmigrationlaravel-7

解决方案


推荐阅读