Laravel 11仓库系统迁移报错：外键约束格式不正确

错误信息 #

SQLSTATE[HY000]: General error: 1005 Can't create table `dbwarehourse`.`order_products` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `order_products` add constraint `order_products_order_id_foreign` foreign key (`order_id`) references `orders` (`id`))

各表迁移代码 #

Product表迁移代码 #

Schema::create('products', function (Blueprint $table) {
    $table->id();
    $table->string('productcode');

    $table->foreignId('category_id')->constrained('categories');
    $table->string('productname');
    $table->decimal('price', 8, 2);
    $table->integer('stock');
    $table->integer('stock_level'); // Add this line
    $table->boolean('status')->default(0);

    $table->timestamps();
});

Order表迁移代码 #

Schema::create('orders', function (Blueprint $table) {
    $table->id();
    $table->interger('invoicenumber');
    $table->foreignId('client_id')->constrained('clients');
    $table->decimal('total_amount', 10, 2);
    $table->boolean('status')->default(0);
    $table->timestamps();
});

Order_products表迁移代码 #

Schema::create('order_products', function (Blueprint $table) {
    $table->id();
    $table->foreignId('product_id')->constrained('products');
    $table->foreignId('order_id')->constrained('orders');
    $table->integer('quantity');
    $table->decimal('price', 8, 2);
    $table->timestamps();
});

问题排查与解决步骤 #

• 修复Order表拼写错误：Order表迁移代码中$table->interger('invoicenumber');存在拼写错误，正确写法是$table->integer('invoicenumber');。这个错误会导致orders表无法正常创建，进而让order_products的外键约束找不到关联表。
• 调整迁移文件执行顺序：确保order_products的迁移文件时间戳晚于orders、products、clients、categories的迁移文件。Laravel按迁移文件名的时间戳顺序执行，若依赖表未创建，外键约束会直接失败。
• 确认依赖表存在：检查categories和clients表的迁移是否已成功执行，products依赖categories、orders依赖clients，若这两个表不存在，会导致products或orders创建失败，进而引发order_products的外键错误。
• 验证字段类型匹配：外键字段order_id、product_id为foreignId类型，对应关联表的id字段（Laravel默认是unsigned bigint），类型匹配无需调整；若手动修改过字段类型，需确保关联字段类型完全一致。

完成以上操作后，重新运行php artisan migrate即可解决问题。

内容的提问来源于stack exchange，提问作者Vasantha Kalyani