geekhub-php / CheTheatre

        return '';

    }

    public function up(Schema $schema) : void

    {

        // this up() migration is auto-generated, please modify it to your needs

        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE media__media ADD cdn_flush_identifier VARCHAR(64) DEFAULT NULL');

        $this->addSql('ALTER TABLE media__gallery_media DROP FOREIGN KEY FK_80D4C5414E7AF8F');

        $this->addSql('ALTER TABLE media__gallery_media DROP FOREIGN KEY FK_80D4C541EA9FDD75');

        $this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C5414E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id) ON DELETE CASCADE');

        $this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C541EA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id) ON DELETE CASCADE');

    }

    public function down(Schema $schema) : void

    {

        $this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C541EA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id) ON DELETE CASCADE');

    }

    public function down(Schema $schema) : void

    {

        // this down() migration is auto-generated, please modify it to your needs

        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE media__gallery_media DROP FOREIGN KEY FK_80D4C5414E7AF8F');

        $this->addSql('ALTER TABLE media__gallery_media DROP FOREIGN KEY FK_80D4C541EA9FDD75');

        $this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C5414E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id)');

        $this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C541EA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id)');

        $this->addSql('ALTER TABLE media__media DROP cdn_flush_identifier');

    }

}

        return '';

    }

    public function up(Schema $schema) : void

    {

        // this up() migration is auto-generated, please modify it to your needs

        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE RepertoireSeason (id INT AUTO_INCREMENT NOT NULL, startDate DATETIME NOT NULL, endDate DATETIME NOT NULL, number INT NOT NULL, UNIQUE INDEX UNIQ_C9FDBB996901F54 (number), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');

        $this->addSql('CREATE TABLE performance_repertoireseason (performance_id INT NOT NULL, repertoireseason_id INT NOT NULL, INDEX IDX_58AE5ABFB91ADEEE (performance_id), INDEX IDX_58AE5ABFAC76615 (repertoireseason_id), PRIMARY KEY(performance_id, repertoireseason_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');

        $this->addSql('ALTER TABLE performance_repertoireseason ADD CONSTRAINT FK_58AE5ABFB91ADEEE FOREIGN KEY (performance_id) REFERENCES performances (id) ON DELETE CASCADE');

        $this->addSql('ALTER TABLE performance_repertoireseason ADD CONSTRAINT FK_58AE5ABFAC76615 FOREIGN KEY (repertoireseason_id) REFERENCES RepertoireSeason (id) ON DELETE CASCADE');

        $this->insertSeasons();

        $this->addSeasonsToPerformances();

    }

    protected function addSeasonsToPerformances()

    {