<?php

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

    class OccurrencePersonality extends Migration
    {

        /**
         * Run the migrations.
         *
         * @return void
         */
        public function up()
        {
            Schema::create('occurrence_personality', function (Blueprint $table) {
                $table->unsignedInteger('personality_id');
                $table->unsignedInteger('occurrence_id');
                $table->integer('position')->nullable();
                $table->primary(['personality_id', 'occurrence_id']);

                $table->foreign('personality_id')->references('id')
                    ->on('personalities')->onDelete('CASCADE')->onUpdate('CASCADE');
                $table->foreign('occurrence_id')->references('id')
                    ->on('occurrences')->onDelete('CASCADE')->onUpdate('CASCADE');
            });
        }

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

    }