Completed
Pull Request — master (#191)
by Serhii
02:32
created

Version20210119213931::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 8

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 8
rs 10
c 0
b 0
f 0
cc 1
nc 1
nop 1
1
<?php
2
3
declare(strict_types=1);
4
5
namespace DoctrineMigrations;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
final class Version20210119213931 extends AbstractMigration
11
{
12
    public function getDescription() : string
13
    {
14
        return 'Added new enum value: art-director';
15
    }
16
17
    public function up(Schema $schema) : void
18
    {
19
        $this->addSql('
20
            ALTER TABLE employees  
21
            CHANGE staff staff ENUM(\'administrative\', \'art-director\', \'art-production\', \'art-core\', \'creative\', \'invited\') 
22
            DEFAULT \'creative\' NOT NULL COMMENT \'(DC2Type:EmployeeStaffEnum)\'
23
        ');
24
    }
25
26
    public function down(Schema $schema) : void
27
    {
28
        $this->addSql('
29
            ALTER TABLE employees  
30
            CHANGE staff staff ENUM(\'administrative\', \'art-production\', \'art-core\', \'creative\', \'invited\') 
31
            DEFAULT \'creative\' NOT NULL COMMENT \'(DC2Type:EmployeeStaffEnum)\'
32
        ');
33
    }
34
}
35