2018_12_04_173358_create_pelicula_categoria.php

<?php

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

class CreatePeliculaCategoria extends Migration
{
    use SoftDeletes;
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('pelicula_categoria', function (Blueprint $table) {
            $table->increments('id_pelicula_categoria');


            $table->integer('id_pelicula')->unsigned();
            $table->integer('id_categoria')->unsigned();


            $table->foreign('id_pelicula')
                ->references('id_pelicula')->on('pelicula')
                ->onDelete('cascade');

            $table->foreign('id_categoria')
                ->references('id_categoria')->on('categoria')
                ->onDelete('cascade');


            $table->timestamps();
        });
    }

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