vendor/boldr/cms-bundle/migrations/Version__1_16_0.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Boldr\Cms\CmsBundle\Migrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Boldr\Cms\CmsBundle\BoldrCmsMigration;
  10. final class Version1__16_0 extends BoldrCmsMigration
  11. {
  13. public function getBundle(): string { return 'boldr/cms-bundle'; }
  14. public function getVersion(): ?string { return '1.16.0'; }
  16. public function up(Schema $schema): void
  17. {
  18. // this up() migration is auto-generated, please modify it to your needs
  19. $this->addSql('ALTER TABLE cms_page_translation ADD draft_sections LONGTEXT DEFAULT NULL');
  20. $this->addSql('ALTER TABLE cms_page_translation CHANGE sections sections LONGTEXT DEFAULT NULL');
  21. $this->addSql('UPDATE cms_page_translation pt LEFT JOIN cms_page p ON p.id = pt.page_id SET draft_sections = sections, sections = NULL WHERE p.published = 0');
  22. $this->addSql('ALTER TABLE cms_page DROP published');
  23. }
  25. }