migrations/Version20191129130459.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 Version20191129130459 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('CREATE TABLE abonnent (username VARCHAR(128) NOT NULL, password VARCHAR(128) NOT NULL, is_active TINYINT(1) NOT NULL, create_at DATETIME NOT NULL, PRIMARY KEY(username)) DEFAULT CHARACTER SET UTF8 COLLATE `UTF8_unicode_ci` ENGINE = InnoDB');
  19. $this->addSql('CREATE TABLE abonnenttoken (token VARCHAR(128) NOT NULL, username VARCHAR(128) DEFAULT NULL, create_at DATETIME NOT NULL, INDEX IDX_CAFF3B53F85E0677 (username), PRIMARY KEY(token)) DEFAULT CHARACTER SET UTF8 COLLATE `UTF8_unicode_ci` ENGINE = InnoDB');
  20. $this->addSql('ALTER TABLE abonnenttoken ADD CONSTRAINT FK_CAFF3B53F85E0677 FOREIGN KEY (username) REFERENCES abonnent (username)');
  21. }
  23. public function down(Schema $schema) : void
  24. {
  25. // this down() migration is auto-generated, please modify it to your needs
  26. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  28. $this->addSql('ALTER TABLE abonnenttoken DROP FOREIGN KEY FK_CAFF3B53F85E0677');
  29. $this->addSql('DROP TABLE abonnent');
  30. $this->addSql('DROP TABLE abonnenttoken');
  31. }
  32. }