CreateSenseStatementSummariesTable::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
nc 1
nop 0
dl 0
loc 3
rs 10
c 0
b 0
f 0
1
<?php
2
3
/*
4
 * This file is part of Laravel Sense.
5
 *
6
 * (c) Anton Komarev <[email protected]>
7
 *
8
 * For the full copyright and license information, please view the LICENSE
9
 * file that was distributed with this source code.
10
 */
11
12
declare(strict_types=1);
13
14
use Illuminate\Database\Migrations\Migration;
15
use Illuminate\Database\Schema\Blueprint;
16
use Illuminate\Support\Facades\Schema;
17
18
class CreateSenseStatementSummariesTable extends Migration
19
{
20
    /**
21
     * Run the migrations.
22
     *
23
     * @return void
24
     */
25
    public function up(): void
26
    {
27
        Schema::create('sense_statement_summaries', function (Blueprint $table) {
28
            $table->bigIncrements('id');
29
            $table->unsignedBigInteger('request_id');
30
            $table->unsignedBigInteger('statement_id');
31
            $table->string('connection');
32
            $table->unsignedInteger('queries_count')->default('0');
33
            $table->double('time_total', 10, 2)->default('0');
34
            $table->double('time_min', 6, 2)->default('0');
35
            $table->double('time_max', 6, 2)->default('0');
36
            $table->timestamps();
37
38
            $table->index([
39
                'request_id',
40
                'statement_id',
41
                'connection',
42
            ], 'sense_statement_summaries_request_statement_connection_index');
43
        });
44
    }
45
46
    /**
47
     * Reverse the migrations.
48
     *
49
     * @return void
50
     */
51
    public function down(): void
52
    {
53
        Schema::dropIfExists('sense_statement_summaries');
54
    }
55
}
56