Passed
Pull Request — dev (#313)
by Tristan
06:51
created

CreateSkillsTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 19
Code Lines 12

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 12
dl 0
loc 19
rs 9.8666
c 1
b 0
f 0
cc 1
nc 1
nop 0
1
<?php
2
3
use Illuminate\Support\Facades\Schema;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Database\Migrations\Migration;
6
7
class CreateSkillsTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('skills', function (Blueprint $table) {
17
            $table->increments('id');
18
            $table->integer('skill_type_id')->unsigned();
19
            $table->string('name');
20
            $table->timestamps();
21
        });
22
23
        Schema::create('skill_types', function (Blueprint $table) {
24
            $table->increments('id');
25
            $table->string('name');
26
            $table->timestamps();
27
        });
28
29
        Schema::table('skills', function(Blueprint $table)
30
		{
31
            $table->foreign('skill_type_id')->references('id')->
32
                on('skill_types')->onUpdate('CASCADE')->onDelete('NO ACTION');
33
		});
34
    }
35
36
    /**
37
     * Reverse the migrations.
38
     *
39
     * @return void
40
     */
41
    public function down()
42
    {
43
        Schema::dropIfExists('skills');
44
        Schema::dropIfExists('skill_types');
45
    }
46
}
47