migrations/Version20190606144933.php line 1

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace DoctrineMigrations;
  5. use Doctrine\DBAL\Schema\Schema;
  6. use Doctrine\Migrations\AbstractMigration;
  8. /**
  9. * Auto-generated Migration: Please modify to your needs!
  10. */
  11. final class Version20190606144933 extends AbstractMigration
  12. {
  13. public function up(Schema $schema) : void
  14. {
  15. // this up() migration is auto-generated, please modify it to your needs
  16. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  18. $this->addSql('ALTER TABLE vsabo ADD aboname_short VARCHAR(8) DEFAULT NULL, ADD max_length_vs_titel INT DEFAULT NULL, ADD max_length_vs_beschreibung INT DEFAULT NULL');
  20. $this->addSql("UPDATE vsabo SET aboname_short='K', max_length_vs_titel = 50, max_length_vs_beschreibung = 60 WHERE id=1");
  21. $this->addSql("UPDATE vsabo SET aboname_short='SO', max_length_vs_titel = 60, max_length_vs_beschreibung = 120 WHERE id=2");
  22. $this->addSql("UPDATE vsabo SET aboname_short='SM', max_length_vs_titel = 60, max_length_vs_beschreibung = 120 WHERE id=3");
  23. $this->addSql("UPDATE vsabo SET aboname_short='PO', max_length_vs_titel = 100, max_length_vs_beschreibung = 300 WHERE id=4");
  24. $this->addSql("UPDATE vsabo SET aboname_short='PM', max_length_vs_titel = 100, max_length_vs_beschreibung = 300 WHERE id=5");
  25. }
  27. public function down(Schema $schema) : void
  28. {
  29. // this down() migration is auto-generated, please modify it to your needs
  30. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  32. $this->addSql('ALTER TABLE vsabo DROP aboname_short, DROP max_length_vs_titel, DROP max_length_vs_beschreibung');
  33. }
  34. }