migrations/Version20230911150011.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 Version20230911150011 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 module_page add meta_keywords TEXT default NULL');
  23.     }
  25.     public function down(Schema $schema): void
  26.     {
  27.        $this->addSql("create table module_page_dg_tmp
  28. (
  29.     id               INTEGER                                not null
  30.         primary key autoincrement,
  31.     slug             VARCHAR(255)                           not null,
  32.     title            VARCHAR(255)                           not null,
  33.     description      CLOB                                   not null,
  34.     capability_title VARCHAR(255) default NULL,
  35.     capability_text  CLOB         default NULL,
  36.     configure_title  VARCHAR(255) default NULL,
  37.     configure_text   CLOB         default NULL,
  38.     tariffs          CLOB                                   not null,
  39.     feature_text     CLOB         default NULL,
  40.     feature_image    VARCHAR(255) default NULL,
  41.     created_at       DATETIME     default CURRENT_TIMESTAMP not null,
  42.     updated_at       DATETIME     default NULL,
  43.     feature_btn_text VARCHAR(255) default NULL,
  44.     active           BOOLEAN                                not null,
  45.     page_title       VARCHAR(255) default ''                not null,
  46.     meta_description VARCHAR(255) default ''                not null,
  47.     feature_you_tube VARCHAR(255) default NULL,
  48.     pos              INTEGER      default NULL
  49. )
  50. ");
  52.         $this->addSql("
  53. insert into module_page_dg_tmp(id, slug, title, description, capability_title, capability_text, configure_title,
  54.                                configure_text, tariffs, feature_text, feature_image, created_at, updated_at,
  55.                                feature_btn_text, active, page_title, meta_description, feature_you_tube, pos)
  56.             select id, slug, title, description, capability_title, capability_text, configure_title, configure_text,
  57.                    tariffs, feature_text, feature_image, created_at, updated_at, feature_btn_text, active, page_title,
  58.                    meta_description, feature_you_tube, pos
  59.             from module_page
  60.        ");
  62.         $this->addSql("drop table module_page");
  64.         $this->addSql("alter table module_page_dg_tmp rename to module_page");
  66.         $this->addSql("create unique index UNIQ_AE36F32C989D9B62 on module_page (slug)");
  67.     }
  68. }