Create Order Table issue with migration

[rossi99]

I am on part 18 of the series and I am having issues with the migration of the orders table and the order products table.

My '2020_07_10_134530_create_orders_table.php' look like this:

`<?php

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

class CreateOrdersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('orders', function (Blueprint $table) {
$table->increments('id');
$table->integer('user_id')->unsigned()->nullable();
$table->foreign('user_id')->references('id')->on('users')
->onUpdate('cascade')->onDelete('set null');
$table->string('billing_email')->nullable();
$table->string('billing_name')->nullable();
$table->string('billing_address')->nullable();
$table->string('billing_city')->nullable();
$table->string('billing_province')->nullable();
$table->string('billing_postalcode')->nullable();
$table->string('billing_phone')->nullable();
$table->string('billing_name_on_card')->nullable();
$table->integer('billing_discount')->default(0);
$table->string('billing_discount_code')->nullable();
$table->integer('billing_subtotal');
$table->integer('billing_tax');
$table->integer('billing_total');
$table->string('payment_gateway')->default('stripe');
$table->boolean('shipped')->default(false);
$table->string('error')->nullable();
$table->timestamps();
});
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::dropIfExists('orders');
}

}

And my '2020_07_10_135517_create_order_product_table.php' looks like:

`<?php

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

class CreateOrderProductTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('order_product', function (Blueprint $table) {
$table->increments('id');
$table->integer('order_id')->unsigned()->nullable();
$table->foreign('order_id')->references('id')
->on('orders')->onUpdate('cascade')->onDelete('set null');

        $table->integer('product_id')->unsigned()->nullable();
        $table->foreign('product_id')->references('id')
            ->on('products')->onUpdate('cascade')->onDelete('set null');

        $table->integer('quantity')->unsigned();
        $table->timestamps();
    });
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::dropIfExists('order_product');
}

}
`

When I run:

php artisan migrate

I get the following error:

SQLSTATE[HY000]: General error: 3780 Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'orders_user_id_foreign' are incompatible. (SQL: alter tableordersadd constraintorders_user_id_foreign foreign key (user_id) references users (id) on delete set null on update cascade)

Someone help me please?

[GuerfiHamza]

hey, check your users table