app/DoctrineMigrations/Version20190401105353.php

   1 <?php
   2
   3 namespace Application\Migrations;
   4
   5 use Doctrine\DBAL\Schema\Schema;
   6 use Wallabag\CoreBundle\Doctrine\WallabagMigration;
   7
   8 /**
   9  * Add hashed_url in entry.
  10  */
  11 class Version20190401105353 extends WallabagMigration
  12 {
  13     /**
  14      * @param Schema $schema
  15      */
  16     public function up(Schema $schema)
  17     {
  18         $entryTable = $schema->getTable($this->getTable('entry'));
  19
  20         $this->skipIf($entryTable->hasColumn('hashed_url'), 'It seems that you already played this migration.');
  21
  22         $entryTable->addColumn('hashed_url', 'text', [
  23             'length' => 40,
  24             'notnull' => false,
  25         ]);
  26
  27         $entryTable->addIndex(['user_id', 'hashed_url'], 'hashed_url_user_id', [], ['lengths' => [null, 40]]);
  28     }
  29
  30     /**
  31      * @param Schema $schema
  32      */
  33     public function down(Schema $schema)
  34     {
  35         $entryTable = $schema->getTable($this->getTable('entry'));
  36
  37         $this->skipIf(!$entryTable->hasColumn('hashed_url'), 'It seems that you already played this migration.');
  38
  39         $entryTable->dropIndex('hashed_url_user_id');
  40         $entryTable->dropColumn('hashed_url');
  41     }
  42 }