Completed
Push — master ( c4d057...a4831f )
by ARCANEDEV
07:52
created

CreateTrackerReferersTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 14
Code Lines 11

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 14
rs 9.4285
c 0
b 0
f 0
cc 1
eloc 11
nc 1
nop 0
1
<?php
2
3
use Arcanedev\LaravelTracker\Bases\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
6
/**
7
 * Class     CreateTrackerReferersTable
8
 *
9
 * @author   ARCANEDEV <[email protected]>
10
 */
11
class CreateTrackerReferersTable extends Migration
12
{
13
    /* ------------------------------------------------------------------------------------------------
14
     |  Properties
15
     | ------------------------------------------------------------------------------------------------
16
     */
17
    /**
18
     * The table name.
19
     *
20
     * @var string
21
     */
22
    protected $table = 'referers';
23
24
    /* ------------------------------------------------------------------------------------------------
25
     |  Main Functions
26
     | ------------------------------------------------------------------------------------------------
27
     */
28
    /**
29
     * Migrate to database.
30
     */
31
    public function up()
32
    {
33
        $this->createSchema(function (Blueprint $table) {
34
            $table->bigIncrements('id');
35
            $table->bigInteger('domain_id', false, true)->index();
36
            $table->string('url')->index();
37
            $table->string('host');
38
            $table->string('medium')->nullable()->index();
39
            $table->string('source')->nullable()->index();
40
            $table->string('search_terms_hash')->nullable()->index();
41
            $table->timestamp('created_at')->index();
42
            $table->timestamp('updated_at')->index();
43
        });
44
    }
45
}
46