hi so I'm trying to add things to my database to check if it works but even though I've created the tables and have added things to the genres table it wont add to the products able
the top shows the error im having whiles the bottom shows all available tables in the datebase
Schema::create('product', function (Blueprint $table) {
$table->increments('id');
$table->timestamps();
$table->string('title');
$table->double('price');
$table->integer('quantity')->unsigned();
$table->integer('genres_id')->unsigned();
$table->integer('company_id')->unsigned();
$table->foreign('company_id')->references('id')->on('users')->onUpdate('cascade')->onDelete('cascade');
$table->foreign('genres_id')->references('id')->on('genres')->onUpdate('cascade')->onDelete('cascade');
});
this is the code for the database and all its columns needed.
Any help solving this would be very appreciated thanks
The table is called product
but in your query you are using products
you have an extra s