]>
Commit | Line | Data |
---|---|---|
ebe0787e JB |
1 | <?php |
2 | ||
3 | namespace Application\Migrations; | |
4 | ||
ebe0787e | 5 | use Doctrine\DBAL\Schema\Schema; |
bfe7a692 | 6 | use Wallabag\CoreBundle\Doctrine\WallabagMigration; |
ebe0787e | 7 | |
b87f1712 | 8 | /** |
01736b5a | 9 | * Added pocket_consumer_key field on wallabag_config. |
b87f1712 | 10 | */ |
bfe7a692 | 11 | class Version20160916201049 extends WallabagMigration |
ebe0787e | 12 | { |
ebe0787e JB |
13 | /** |
14 | * @param Schema $schema | |
15 | */ | |
16 | public function up(Schema $schema) | |
17 | { | |
597755b8 | 18 | $configTable = $schema->getTable($this->getTable('config')); |
18d7bc3a | 19 | |
597755b8 NL |
20 | $this->skipIf($configTable->hasColumn('pocket_consumer_key'), 'It seems that you already played this migration.'); |
21 | ||
3ad4061d | 22 | $configTable->addColumn('pocket_consumer_key', 'string', ['notnull' => false]); |
f808b016 | 23 | $this->addSql('DELETE FROM ' . $this->getTable('craue_config_setting') . " WHERE name = 'pocket_consumer_key';"); |
ebe0787e JB |
24 | } |
25 | ||
26 | /** | |
27 | * @param Schema $schema | |
28 | */ | |
29 | public function down(Schema $schema) | |
30 | { | |
597755b8 | 31 | $configTable = $schema->getTable($this->getTable('config')); |
d79b3adb | 32 | $configTable->dropColumn('pocket_consumer_key'); |
f808b016 JB |
33 | $this->addSql('INSERT INTO ' . $this->getTable('craue_config_setting') . " (name, value, section) VALUES ('pocket_consumer_key', NULL, 'import')"); |
34 | } | |
ebe0787e | 35 | } |