3 namespace Application\Migrations
;
5 use Doctrine\DBAL\Schema\Schema
;
6 use Wallabag\CoreBundle\Doctrine\WallabagMigration
;
9 * Added `given_url` & `hashed_given_url` field in entry table.
11 class Version20190601125843
extends WallabagMigration
13 public function up(Schema
$schema)
15 $entryTable = $schema->getTable($this->getTable('entry'));
17 if (!$entryTable->hasColumn('given_url')) {
18 $entryTable->addColumn('given_url', 'text', [
23 if (!$entryTable->hasColumn('hashed_given_url')) {
24 $entryTable->addColumn('hashed_given_url', 'text', [
30 // 40 = length of sha1 field hashed_given_url
31 $entryTable->addIndex(['user_id', 'hashed_given_url'], 'hashed_given_url_user_id', [], ['lengths' => [null, 40]]);
34 public function down(Schema
$schema)
36 $entryTable = $schema->getTable($this->getTable('entry'));
38 if ($entryTable->hasColumn('given_url')) {
39 $entryTable->dropColumn('given_url');
42 if ($entryTable->hasColumn('hashed_given_url')) {
43 $entryTable->dropColumn('hashed_given_url');
46 $entryTable->dropIndex('hashed_given_url_user_id');