View file delta_framework-main/db/migrations/20230405185041_user_roles.php

File size: 746B
<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class UserRoles extends AbstractMigration
{
    private $table;
    private $data;

    public function init(): void
    {
        $this->table = 'd_user_roles';
        $this->data = [
            [
                'user_id' => 1,
                'role_id' => 1,

            ],
            [
                'user_id' => 1,
                'role_id' => 3,
            ],
        ];
    }

    public function change(): void
    {
        $table = $this->table($this->table);
        $table->addColumn('user_id', 'integer')
              ->addColumn('role_id', 'integer')
              ->create();
        $table->insert($this->data);
        $table->save();
    }
}