]> git.immae.eu Git - github/wallabag/wallabag.git/blame - app/DoctrineMigrations/Version20171120163128.php
Add index on starred entries
[github/wallabag/wallabag.git] / app / DoctrineMigrations / Version20171120163128.php
CommitLineData
8a219854
NL
1<?php
2
3namespace Application\Migrations;
4
8a219854 5use Doctrine\DBAL\Schema\Schema;
bfe7a692 6use Wallabag\CoreBundle\Doctrine\WallabagMigration;
8a219854
NL
7
8/**
9 * Add store_article_headers in craue_config_setting.
10 */
bfe7a692 11class Version20171120163128 extends WallabagMigration
8a219854 12{
8a219854
NL
13 /**
14 * @param Schema $schema
15 */
16 public function up(Schema $schema)
17 {
18 $storeArticleHeaders = $this->container
19 ->get('doctrine.orm.default_entity_manager')
20 ->getConnection()
21 ->fetchArray('SELECT * FROM ' . $this->getTable('craue_config_setting') . " WHERE name = 'store_article_headers'");
22
23 $this->skipIf(false !== $storeArticleHeaders, 'It seems that you already played this migration.');
24
25 $this->addSql('INSERT INTO ' . $this->getTable('craue_config_setting') . " (name, value, section) VALUES ('store_article_headers', '0', 'entry')");
26 }
27
28 /**
29 * @param Schema $schema
30 */
31 public function down(Schema $schema)
32 {
33 $this->addSql('DELETE FROM ' . $this->getTable('craue_config_setting') . " WHERE name = 'store_article_headers';");
34 }
8a219854 35}