Passed
Push — feature/review_applications ( 18f610...a1a1bf )
by Tristan
08:57
created

up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 8
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 4
c 1
b 0
f 0
dl 0
loc 8
rs 10
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 DropApplicationReviewDecisionAndReviewColumns extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::table('application_reviews', function (Blueprint $table) {
17
            $table->dropColumn('reviewer');
18
            $table->dropColumn( 'review_decision_id');
19
        });
20
21
        Schema::dropIfExists( 'review_decisions');
22
23
24
    }
25
26
    /**
27
     * Reverse the migrations.
28
     *
29
     * @return void
30
     */
31
    public function down()
32
    {
33
        Schema::table('application_reviews', function (Blueprint $table) {
34
            $table->integer('review_decision_id')->unsigned();
35
            $table->string('reviewer')->nullable();
36
        });
37
38
        Schema::create('review_decisions', function (Blueprint $table) {
39
            $table->increments('id');
40
            $table->string('name');
41
            $table->timestamps();
42
        });
43
44
        Schema::table('application_reviews', function (Blueprint $table) {
45
            $table->foreign('review_decision_id')->references('id')->on('review_decisions')->onUpdate('CASCADE')->onDelete('NO ACTION');
46
        });
47
    }
48
}
49