CreateMedFormFieldValuesTables::up()   A
last analyzed

Complexity

Conditions 3
Paths 4

Size

Total Lines 29
Code Lines 22

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 22
c 1
b 0
f 0
dl 0
loc 29
rs 9.568
cc 3
nc 4
nop 0
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Support\Facades\Schema;
6
7
class CreateMedFormFieldValuesTables extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
17
        if (!Schema::hasTable('med_form_field_values')) {
18
            Schema::create('med_form_field_values', function (Blueprint $table) {
19
                $table->id();
20
                $table->unsignedBigInteger('form_field_id')->nullable();
21
                $table->foreign('form_field_id')
22
                    ->references('id')
23
                    ->on('med_form_fields')
24
                    ->onDelete('set null');
25
                $table->boolean('default_selected')->default(0);
26
                $table->timestamps();
27
            });
28
        }
29
30
        if (!Schema::hasTable('med_form_field_value_translations')) {
31
            Schema::create('med_form_field_value_translations', function (Blueprint $table) {
32
                $table->id();
33
                $table->string('value');
34
                $table->text('text')->nullable();
35
36
                $table->unsignedBigInteger('field_value_id')->nullable();
37
                $table->foreign('field_value_id')
38
                    ->references('id')
39
                    ->on('med_form_field_values')
40
                    ->onDelete('set null');
41
                $table->text('description')->nullable();
42
                $table->timestamps();
43
            });
44
        }
45
    }
46
47
    /**
48
     * Reverse the migrations.
49
     *
50
     * @return void
51
     */
52
    public function down()
53
    {
54
        Schema::dropIfExists('med_entries');
55
        Schema::dropIfExists('med_form_translations');
56
        Schema::dropIfExists('med_forms');
57
    }
58
}
59