DoctrineMigrations\Version20210109113511::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines

43

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up(Schema $schema) : void
    {
        $this->addSql('
            ALTER TABLE employees 
            ADD staff 
                ENUM(\'art-core\', \'art-production\', \'administrative\', \'creative\', \'invited\') 
                DEFAULT \'creative\' NOT NULL COMMENT \'(DC2Type:EmployeeStaffEnum)\'
        ');

        $this->addSql('
            UPDATE employees 
            SET `staff` = \'art-core\'
            WHERE `position` IN (
                \'acting_artistic_director\',
                \'conductor\',
                \'costumer\',
                \'head_of_the_literary_and_dramatic_part\'
            )
        ');

        $this->addSql('
            UPDATE employees 
            SET `staff` = \'art-production\'
            WHERE `position` IN (
                \'art_director\',
                \'costumer\',
                \'leading_artist_scene\',
                \'main_artist\',
                \'main_choreographer\',
                \'stage_manager\',
                \'head_of_the_literary_and_dramatic_part\'
            )
        ');

        $this->addSql('
            UPDATE employees 
            SET `staff` = \'administrative\'
            WHERE `position` IN (
                \'theatre_director\',
                \'theatre_director_art_director\'
            )
        ');
    }