php - 迁移时表中的 FK 不起作用

Question

当我当时为表创建迁移时，其通过以下错误存在问题。

Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1005 Can't create table yourwebs_veridocedu。#sql-2c46_8e (errno: 150 "Foreign key constraint is wrongly forms") (SQL: alter table user_role_mappingsadd constraint user_role_mappings_user_id_foreignforeign key ( user_id) references users( id) on delete cascade)

迁移用户角色映射表：

public function up()
    {
        Schema::create('user_role_mappings', function (Blueprint $table) {
            $table->increments('id');

            $table->integer('user_id');
            $table->integer('group_id');
            $table->integer('roleid');
            $table->integer('status');
            $table->integer('createdby');
            $table->integer('modifiedby');
            $table->string('publicguid');
            $table->string('privateguid');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
            $table->foreign('group_id')->references('id')->on('groups')->onDelete('cascade');
        });
    }

角色表迁移：

public function up()
{
    Schema::create('userroles', function (Blueprint $table) {
        $table->increments('id');
        $table->string('rolename');
         $table->integer('status')->default(1);
        $table->integer('createdby')->default(1);
        $table->integer('modifiedby')->default(1);
        $table->string('publicguid');
        $table->string('privateguid');
        $table->timestamps(); 

    });
}

用户表迁移：

    <?php

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

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->engine = 'InnoDB';
            $table->increments('id');


            $table->string('name');
            $table->string('email',150)->unique();
            $table->string('password');
            $table->integer('roleid')->unsigned();
            $table->rememberToken();

            /*Common Fields*/
            $table->integer('status');
            $table->integer('createdby');
            $table->integer('modifiedby');
            $table->string('publicguid');
            $table->string('privateguid');
            $table->timestamps();

           /*From other table */
            $table->foreign('roleid') ->references('id')->on('userroles')->onDelete('cascade');

        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */

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

表中的 FK 无法迁移。

标签： phplaravellaravel-5

Answer 1

increments列未签名，您的外键列需要具有相同的签名。因此，您应该像这样更改列：

$table->integer('user_id')->unsigned();
$table->integer('group_id')->unsigned();