migrations/Version20230830150006.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20230830150006 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql('alter table blog_post add meta_keywords TEXT default NULL');
  23.     }
  25.     public function down(Schema $schema): void
  26.     {
  27.        $this->addSql("create table blog_post_dg_tmp
  28.         (
  29.             id                INTEGER                 not null
  30.                 primary key autoincrement,
  31.             title             VARCHAR(255)            not null,
  32.             slug              VARCHAR(255)            not null,
  33.             created_at        DATETIME                not null,
  34.             updated_at        DATETIME     default NULL,
  35.             poster            VARCHAR(255) default NULL,
  36.             page_title        VARCHAR(255) default '' not null,
  37.             meta_description  VARCHAR(255) default '' not null,
  38.             published         BOOLEAN                 not null,
  39.             description       CLOB         default NULL,
  40.             short_description CLOB         default NULL,
  41.             button_text       VARCHAR(255) default NULL,
  42.             button_link       VARCHAR(255) default NULL
  43.         )");
  45.         $this->addSql("insert into blog_post_dg_tmp(id, title, slug, created_at, updated_at, poster, page_title, meta_description, published, description, short_description, button_text, button_link)
  46.                 select id, title, slug, created_at, updated_at, poster, page_title, meta_description, published, description, short_description, button_text, button_link
  47.                 from blog_post
  48.        ");
  50.         $this->addSql("drop table blog_post");
  52.         $this->addSql("alter table blog_post_dg_tmp rename to blog_post");
  54.         $this->addSql("create unique index UNIQ_BA5AE01D989D9B62  on blog_post (slug)");
  55.     }
  56. }