CreateProfilesTable::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 1
c 0
b 0
f 0
nc 1
nop 0
dl 0
loc 3
rs 10
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Support\Facades\Schema;
6
7
class CreateProfilesTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('fg_profiles', function (Blueprint $table) {
17
            $table->string('id', 150)->primary();
18
            $table->string('ministry_id', 150)->index();
19
            $table->text('about_us')->nullable();
20
            $table->text('mission')->nullable();
21
            $table->text('vision')->nullable();
22
            $table->json('phones')->nullable();
23
            $table->json('emails')->nullable();
24
            $table->string('website')->nullable();
25
            $table->string('facebook')->nullable();
26
            $table->string('youtube')->nullable();
27
            $table->string('twitter')->nullable();
28
            $table->string('instagram')->nullable();
29
            $table->json('location')->nullable();
30
            $table->string('color')->default('#8a043c');
31
            $table->timestamps();
32
33
            $table->foreign('ministry_id')->references('id')->on('fg_ministries')->onDelete('cascade');
34
        });
35
    }
36
37
    /**
38
     * Reverse the migrations.
39
     *
40
     * @return void
41
     */
42
    public function down()
43
    {
44
        Schema::dropIfExists('fg_profiles');
45
    }
46
}
47