Passed
Push — master ( fde606...0af3c0 )
by Armando
08:21
created

AddForeignKeysToCallbackQueryTable::down()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 5
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 3
c 1
b 0
f 0
nc 1
nop 0
dl 0
loc 5
rs 10
1
<?php
2
3
declare(strict_types=1);
4
5
use Illuminate\Database\Migrations\Migration;
6
use Illuminate\Database\Schema\Blueprint;
7
use Illuminate\Support\Facades\Schema;
8
9
class AddForeignKeysToCallbackQueryTable extends Migration
10
{
11
    public function up(): void
12
    {
13
        Schema::table('callback_query', static function (Blueprint $table) {
14
            $table->foreign('user_id', 'callback_query_ibfk_1')->references('id')->on('user')->onUpdate('RESTRICT')->onDelete('RESTRICT');
15
            $table->foreign('chat_id', 'callback_query_ibfk_2')->references('chat_id')->on('message')->onUpdate('RESTRICT')->onDelete('RESTRICT');
16
        });
17
    }
18
19
    public function down(): void
20
    {
21
        Schema::table('callback_query', static function (Blueprint $table) {
22
            $table->dropForeign('callback_query_ibfk_1');
23
            $table->dropForeign('callback_query_ibfk_2');
24
        });
25
    }
26
}
27