migrations/Version20191204062616.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 Version20191204062616 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\'.');
  19. // delete existing data
  20. $this->addSql("DELETE FROM abonnenttoken");
  21. $this->addSql("DELETE FROM abonnent");
  24. $this->addSql('ALTER TABLE abonnenttoken DROP FOREIGN KEY FK_CAFF3B53F85E0677');
  25. $this->addSql('DROP INDEX IDX_CAFF3B53F85E0677 ON abonnenttoken');
  26. $this->addSql('ALTER TABLE abonnent DROP PRIMARY KEY');
  27. $this->addSql('ALTER TABLE abonnent ADD id INT NOT NULL, DROP password');
  28. $this->addSql('ALTER TABLE abonnent ADD PRIMARY KEY (id)');
  29. $this->addSql('ALTER TABLE abonnenttoken ADD abonnent_id INT DEFAULT NULL, DROP username');
  30. $this->addSql('ALTER TABLE abonnenttoken ADD CONSTRAINT FK_CAFF3B53B19B9B31 FOREIGN KEY (abonnent_id) REFERENCES abonnent (id)');
  31. $this->addSql('CREATE INDEX IDX_CAFF3B53B19B9B31 ON abonnenttoken (abonnent_id)');
  32. }
  34. public function down(Schema $schema) : void
  35. {
  36. // this down() migration is auto-generated, please modify it to your needs
  37. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  39. }
  40. }