mardi 15 octobre 2019

How to pass foreign key laravel

I'm trying to pass the foreign key but am stuck with this error Base table or view already exists: 1050 Table 'favorites' already exists" how can I pass them all the foreign keys and the normal id like $table->bigInteger('user_id')->unsigned();

tables

 public function up()
{

    Schema::create('favorites', function (Blueprint $table) {
        $table->Increments('id');
        $table->bigInteger('user_id')->unsigned();
        $table->bigInteger('product_id')->unsigned();
        $table->timestamps();

    });

    Schema::create('favorites', function (Blueprint $table){

        $table->bigInteger('user_id')->unsigned()->index();
        $table->foreign('user_id')->references('id')->on('users');

        $table->bigInteger('product_id')->unsigned()->index();
        $table->foreign('product_id')->references('id')->on('products');
    });

}

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


from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2Bg5IXv
via IFTTT

Aucun commentaire:

Enregistrer un commentaire