CreateUserQuizzesTable::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

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