Version20180227152608::up()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 5
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 0
Metric Value
eloc 3
c 0
b 0
f 0
dl 0
loc 5
ccs 0
cts 4
cp 0
rs 10
cc 1
nc 1
nop 1
crap 2
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Application\Migration;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
class Version20180227152608 extends AbstractMigration
11
{
12
    public function up(Schema $schema): void
13
    {
14
        $this->addSql('ALTER TABLE user ADD role ENUM(\'student\', \'junior\', \'senior\', \'administrator\') DEFAULT \'student\' NOT NULL COMMENT \'(DC2Type:UserRole)\'');
15
        $this->addSql('UPDATE user SET role = \'administrator\' WHERE is_administrator = 1');
16
        $this->addSql('ALTER TABLE user DROP is_administrator');
17
    }
18
}
19