Completed
Push — master ( f2f6fa...1beb9c )
by claudio
03:43
created

CreatePivotEmployeeGroups   A

Complexity

Total Complexity 2

Size/Duplication

Total Lines 28
Duplicated Lines 0 %

Coupling/Cohesion

Components 0
Dependencies 2
Metric Value
wmc 2
lcom 0
cbo 2
dl 0
loc 28
rs 10
1
<?php
2
3
use Illuminate\Database\Schema\Blueprint;
4
use Illuminate\Database\Migrations\Migration;
5
6
class CreatePivotEmployeeGroups extends Migration
7
{
8
    /**
9
     * Run the migrations.
10
     *
11
     * @return void
12
     */
13
    public function up()
14
    {
15
        Schema::create('employee_groups', function (Blueprint $table) {
16
            $table->integer('employee_id')->unsigned();
17
            $table->foreign('employee_id')->references('id')->on('employees')->onDelete('cascade')->onUpdate('cascade');
18
            $table->integer('group_id')->unsigned();
19
            $table->foreign('group_id')->references('id')->on('groups')->onDelete('cascade')->onUpdate('cascade');
20
            $table->unique(['employee_id', 'group_id']);
21
        });
22
    }
23
24
    /**
25
     * Reverse the migrations.
26
     *
27
     * @return void
28
     */
29
    public function down()
30
    {
31
        Schema::drop('employee_groups');
32
    }
33
}
34