laravel - 无法创建表外键约束的格式不正确

Question

我已经创建了用户和角色表，并尝试了 unsigned 和 biginteger unsigned 这两种方法，但仍然遇到问题，请帮忙

尝试了 unsigned 和 big unsigned

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


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




     public function up()
         {
             Schema::create('users', function (Blueprint $table) {
                $table->increments('id');
                  $table->unsignedBigInteger('role_id');
                    $table->string('name');
                      $table->string('username');
                      $table->string('email',100)->unique();
                     $table->string('password');
                     $table->rememberToken();
                     $table->boolean('active');
                      $table->timestamps();
                    $table->foreign('role_id')->references('id')- 
          >on('roles');
         });
     }

无法创建表

标签： laravelforeign-keys