app/DoctrineMigrations/Version20190806130304.php

   1 <?php declare(strict_types=1);
   2
   3 namespace Application\Migrations;
   4
   5 use Doctrine\DBAL\Schema\Schema;
   6 use Doctrine\Migrations\AbstractMigration;
   7
   8 /**
   9  * Auto-generated Migration: Please modify to your needs!
  10  */
  11 final class Version20190806130304 extends AbstractMigration
  12 {
  13     public function up(Schema $schema) : void
  14     {
  15         $this->addSql('ALTER TABLE wallabag_entry CHANGE language language VARCHAR(20) DEFAULT NULL');
  16         $this->addSql('CREATE INDEX user_language ON wallabag_entry (language, user_id)');
  17     }
  18
  19     public function down(Schema $schema) : void
  20     {
  21         $this->addSql('DROP INDEX user_language ON `wallabag_entry`');
  22         $this->addSql('ALTER TABLE `wallabag_entry` CHANGE language language LONGTEXT DEFAULT NULL COLLATE utf8mb4_unicode_ci');
  23     }
  24 }