AddRoleUsersTable20210717100434::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 4
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 1
c 1
b 0
f 0
nc 1
nop 0
dl 0
loc 4
rs 10
1
<?php
2
3
namespace Platine\Framework\Migration;
4
5
use Platine\Database\Schema\CreateTable;
6
use Platine\Framework\Migration\AbstractMigration;
7
8
class AddRoleUsersTable20210717100434 extends AbstractMigration
9
{
10
    public function up(): void
11
    {
12
      //Action when migrate up
13
        $this->create('roles_users', function (CreateTable $table) {
14
            $table->integer('user_id');
15
            $table->integer('role_id');
16
17
            $table->primary(['user_id', 'role_id']);
18
19
            $table->foreign('user_id')
20
                ->references('users', 'id')
21
                ->onDelete('CASCADE');
22
23
            $table->foreign('role_id')
24
                ->references('roles', 'id')
25
                ->onDelete('CASCADE');
26
27
            $table->engine('INNODB');
28
        });
29
    }
30
31
    public function down(): void
32
    {
33
      //Action when migrate down
34
        $this->drop('roles_users');
35
    }
36
}
37