Completed
Pull Request — master (#24)
by Anton
02:57 queued 39s
created

CreateLoveReactantReactionTotalsTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 16
Code Lines 12

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 1 Features 0
Metric Value
eloc 12
dl 0
loc 16
rs 9.8666
c 1
b 1
f 0
cc 1
nc 1
nop 0
1
<?php
2
3
/*
4
 * This file is part of Laravel Love.
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
final class CreateLoveReactantReactionTotalsTable extends Migration
19
{
20
    /**
21
     * Run the migrations.
22
     *
23
     * @return void
24
     */
25
    public function up(): void
26
    {
27
        Schema::create('love_reactant_reaction_totals', function (Blueprint $table) {
28
            $table->bigIncrements('id');
29
            $table->unsignedBigInteger('reactant_id');
30
            $table->unsignedBigInteger('count')->default(0);
31
            $table->bigInteger('weight')->default(0);
32
            $table->timestamps();
33
34
            $table->index('reactant_id');
35
36
            $table
37
                ->foreign('reactant_id')
38
                ->references('id')
39
                ->on('love_reactants')
40
                ->onDelete('cascade');
41
        });
42
    }
43
44
    /**
45
     * Reverse the migrations.
46
     *
47
     * @return void
48
     */
49
    public function down(): void
50
    {
51
        Schema::dropIfExists('love_reactant_reaction_totals');
52
    }
53
}
54