migrations/Version20190403135327.php line 1

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace DoctrineMigrations;
  5. use AppBundle\Entity\Artikel\ArtikelTyp;
  6. use Doctrine\DBAL\Schema\Schema;
  7. use Doctrine\Migrations\AbstractMigration;
  9. /**
  10. * Auto-generated Migration: Please modify to your needs!
  11. */
  12. final class Version20190403135327 extends AbstractMigration
  13. {
  14. public function up(Schema $schema) : void
  15. {
  16. // this up() migration is auto-generated, please modify it to your needs
  17. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  19. $this->addSql('ALTER TABLE artikel ADD typ_id VARCHAR(16) NOT NULL');
  21. // alle auf FREE setzen
  22. $this->addSql("UPDATE artikel SET typ_id ='". ArtikelTyp::ID_AT_1 ."'");
  24. // alle welche contentHTML Inhalt haben auf FREE+
  25. $this->addSql("UPDATE artikel SET typ_id ='". ArtikelTyp::ID_AT_2 ."' WHERE LENGTH(contentHtml) > 0");
  27. }
  29. public function down(Schema $schema) : void
  30. {
  31. // this down() migration is auto-generated, please modify it to your needs
  32. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  34. $this->addSql('ALTER TABLE artikel DROP typ_id');
  35. }
  36. }