migrations/Version20240808122954.php line 1

Open in your IDE?
  1. <?php
  3. namespace DoctrineMigrations;
  5. use Doctrine\Migrations\AbstractMigration;
  6. use Doctrine\DBAL\Schema\Schema;
  8. /**
  9. * Spez. Blogpost Keywordindex Tabellen
  10. */
  11. class Version20240808122954 extends AbstractMigration
  12. {
  13. /**
  14. * @param Schema $schema
  15. */
  16. public function up(Schema $schema) : void
  17. {
  18. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  20. $this->addSql('CREATE TABLE artikelkeyword (id INT AUTO_INCREMENT NOT NULL, keyword VARCHAR(64) NOT NULL, INDEX keyword (keyword), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  21. $this->addSql('CREATE TABLE artikelkeywordlink (artikel_id CHAR(36) NOT NULL, artikelkeyword_id INT NOT NULL, scope VARCHAR(16) NOT NULL, INDEX IDX_ARTIKELID (artikel_id), INDEX IDX_ARTIKELKEYWORDID (artikelkeyword_id), INDEX IDX_SCOPE (scope)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  22. $this->addSql('ALTER TABLE artikelkeywordlink ADD CONSTRAINT FK_ARTIKELID FOREIGN KEY (artikel_id) REFERENCES artikel (id)');
  23. $this->addSql('ALTER TABLE artikelkeywordlink ADD CONSTRAINT FK_ARTIKELKEYWORDID FOREIGN KEY (artikelkeyword_id) REFERENCES artikelkeyword (id)');
  24. }
  26. /**
  27. * @param Schema $schema
  28. */
  29. public function down(Schema $schema) : void
  30. {
  31. // this down() migration is auto-generated, please modify it to your needs
  32. }
  33. }