Completed
Pull Request — dev (#317)
by Tristan
06:21
created

CreateReferencesTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 14
Code Lines 10

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 10
dl 0
loc 14
rs 9.9332
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 CreateReferencesTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('references', function (Blueprint $table) {
17
            $table->increments('id');
18
			$table->string('name')->nullable();
19
			$table->string('email')->nullable();
20
			$table->integer('relationship_id')->unsigned()->nullable();
21
			$table->text('description')->nullable();
22
			$table->timestamps();
23
        });
24
25
        Schema::table('references', function (Blueprint $table) {
26
            $table->foreign('relationship_id')->references('id')
27
                ->on('relationships')->onUpdate('CASCADE')->onDelete('NO ACTION');
28
        });
29
    }
30
31
    /**
32
     * Reverse the migrations.
33
     *
34
     * @return void
35
     */
36
    public function down()
37
    {
38
        Schema::dropIfExists('references');
39
    }
40
}
41