]> git.immae.eu Git - github/wallabag/wallabag.git/blame - app/DoctrineMigrations/Version20170127093841.php
Fixed migrations with dash into db name
[github/wallabag/wallabag.git] / app / DoctrineMigrations / Version20170127093841.php
CommitLineData
b564d350
NL
1<?php
2
3namespace Application\Migrations;
4
b564d350 5use Doctrine\DBAL\Schema\Schema;
bfe7a692 6use Wallabag\CoreBundle\Doctrine\WallabagMigration;
b564d350
NL
7
8/**
01736b5a 9 * Added indexes on wallabag_entry.is_starred and wallabag_entry.is_archived.
b564d350 10 */
bfe7a692 11class Version20170127093841 extends WallabagMigration
b564d350 12{
b564d350
NL
13 private $indexStarredName = 'IDX_entry_starred';
14 private $indexArchivedName = 'IDX_entry_archived';
15
b564d350
NL
16 /**
17 * @param Schema $schema
18 */
19 public function up(Schema $schema)
20 {
21 $entryTable = $schema->getTable($this->getTable('entry'));
01e76069 22 $this->skipIf($entryTable->hasIndex($this->indexStarredName) && $entryTable->hasIndex($this->indexArchivedName), 'It seems that you already played this migration.');
b564d350
NL
23
24 $entryTable->addIndex(['is_starred'], $this->indexStarredName);
25 $entryTable->addIndex(['is_archived'], $this->indexArchivedName);
26 }
27
28 /**
29 * @param Schema $schema
30 */
31 public function down(Schema $schema)
32 {
33 $entryTable = $schema->getTable($this->getTable('entry'));
01e76069 34 $this->skipIf(false === $entryTable->hasIndex($this->indexStarredName) && false === $entryTable->hasIndex($this->indexArchivedName), 'It seems that you already played this migration.');
b564d350
NL
35
36 $entryTable->dropIndex($this->indexStarredName);
37 $entryTable->dropIndex($this->indexArchivedName);
38 }
39}