migrations/Version20230621183533.php line 1

  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 Version20230621183533 extends AbstractMigration
  12. {
  13. public function getDescription(): string
  14. {
  15. return '';
  16. }
  18. public function up(Schema $schema): void
  19. {
  20. $sql = <<<'SQL'
  21. CREATE TABLE template_extension
  22. (
  23. id INT AUTO_INCREMENT NOT NULL,
  24. template_id INT NOT NULL,
  25. `order` INT DEFAULT 0,
  26. `type` VARCHAR(20) NOT NULL,
  27. initialized INT DEFAULT 0,
  28. parameter VARCHAR(255),
  29. `value` VARCHAR(255) NOT NULL,
  30. PRIMARY KEY (id),
  31. INDEX (type),
  32. FOREIGN KEY (template_id) REFERENCES template (id)
  33. ) DEFAULT CHARACTER SET utf8mb4
  34. COLLATE `utf8mb4_unicode_ci`
  35. ENGINE = InnoDB
  36. SQL;
  38. $this->addSql($sql);
  39. }
  41. public function down(Schema $schema): void
  42. {
  43. $this->addSql('DROP TABLE template_source');
  44. }
  45. }