dimanche 28 juillet 2019

PDOException::("SQLSTATE[HY000]: General error: 1005 Can't create table `dandelion`

Whenever I try to migrate my database to Laravel I have that problem.

I tried several options but none of them seem to work. Thanks in advance!

Users table:

Schema::create('users', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->string('name');
        $table->string('avatar',100)->nullable();
        $table->string('country',100)->nullable();
        $table->string('email')->unique();
        $table->timestamp('email_verified_at')->nullable();
        $table->string('password');
        $table->unsignedBigInteger('product_id')->unsigned();
        $table->foreign('product_id')->references('id')->on('products');
        $table->rememberToken();
        $table->timestamps();
    });
}

Create Products table:

enter code here:

 Schema::create('products', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->string('name', 100);
        $table->decimal('price', 8, 2);
        $table->string('image', 100);
        $table->unsignedBigInteger('user_id')->unsigned();
        $table->foreign('user_id')->references('id')->on('users');
        $table->timestamps();
    });
}

Add Category id to Column Products:

enter code here:
Schema::table('products', function (Blueprint $table) {
      $table->unsignedBigInteger('category_id')->nullable();
      $table->foreign('category_id')->references('id')->on('categories');
    });
}

Interest Table:

enter code here:
  Schema::create('interests', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->string('name',100)->nullable();
        $table->timestamps();
    });
}

Brands table:

enter code here:
     Schema::create('brands', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->string('name')->nullable();
        $table->timestamps();
    });
}

Add Brand id to Products Table:

enter code here:
   Schema::table('products', function (Blueprint $table) {
      $table->unsignedBigInteger('brand_id')->nullable();
      $table->foreign('brand_id')->references('id')->on('brands');
    });
}

Create Category Interest:

enter code here:
     Schema::table('products', function (Blueprint $table) {
      $table->unsignedBigInteger('brand_id')->nullable();
      $table->foreign('brand_id')->references('id')->on('brands');
    });
}

2 enter code here:

PDOStatement::execute() /Users/Ezequiel/Desktop/dandelion/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire