Completed
Push — develop ( cc9a49...c1329f )
by Abdelrahman
09:49
created

CreateAbilitiesTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 18
Code Lines 12

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 12
nc 1
nop 0
dl 0
loc 18
rs 9.4285
c 0
b 0
f 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 CreateAbilitiesTable extends Migration
0 ignored issues
show
Coding Style Compatibility introduced by
PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

You can fix this by adding a namespace to your class:

namespace YourVendor;

class YourClass { }

When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries.

Loading history...
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create(config('cortex.fort.tables.abilities'), function (Blueprint $table) {
17
            // Columns
18
            $table->increments('id');
19
            $table->string('name', 150);
20
            $table->{$this->jsonable()}('title')->nullable();
21
            $table->integer('entity_id')->unsigned()->nullable();
22
            $table->string('entity_type', 150)->nullable();
23
            $table->boolean('only_owned')->default(false);
24
            $table->integer('scope')->nullable();
25
            $table->auditable();
26
            $table->timestamps();
27
28
            // Indexes
29
            $table->index(['scope']);
30
        });
31
    }
32
33
    /**
34
     * Reverse the migrations.
35
     *
36
     * @return void
37
     */
38
    public function down()
39
    {
40
        Schema::drop(config('cortex.fort.tables.abilities'));
41
    }
42
43
    /**
44
     * Get jsonable column data type.
45
     *
46
     * @return string
47
     */
48
    protected function jsonable(): string
49
    {
50
        return DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME) === 'mysql'
51
               && version_compare(DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION), '5.7.8', 'ge')
52
            ? 'json' : 'text';
53
    }
54
}
55