Completed
Push — master ( b6e961...8692a9 )
by Abdelrahman
15:05 queued 12:57
created

CreateAbilitiesTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 17
Code Lines 11

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 11
nc 1
nop 0
dl 0
loc 17
rs 9.4285
c 0
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
use Illuminate\Support\Facades\Schema;
6
use Illuminate\Database\Schema\Blueprint;
7
use Illuminate\Database\Migrations\Migration;
8
9
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...
10
{
11
    /**
12
     * Run the migrations.
13
     *
14
     * @return void
15
     */
16
    public function up()
17
    {
18
        Schema::create(config('rinvex.fort.tables.abilities'), function (Blueprint $table) {
19
            // Columns
20
            $table->increments('id');
21
            $table->string('action');
22
            $table->string('resource');
23
            $table->string('policy')->nullable();
24
            $table->{$this->jsonable()}('name');
25
            $table->{$this->jsonable()}('description')->nullable();
26
            $table->timestamps();
27
            $table->softDeletes();
28
29
            // Indexes
30
            $table->unique(['action', 'resource']);
31
        });
32
    }
33
34
    /**
35
     * Reverse the migrations.
36
     *
37
     * @return void
38
     */
39
    public function down()
40
    {
41
        Schema::dropIfExists(config('rinvex.fort.tables.abilities'));
42
    }
43
44
    /**
45
     * Get jsonable column data type.
46
     *
47
     * @return string
48
     */
49
    protected function jsonable()
50
    {
51
        return DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME) === 'mysql'
52
               && version_compare(DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION), '5.7.8', 'ge')
53
            ? 'json' : 'text';
54
    }
55
}
56