diff options
| author | Jeremy Benoist <jeremy.benoist@gmail.com> | 2019-04-01 15:45:17 +0200 |
|---|---|---|
| committer | Jeremy Benoist <jeremy.benoist@gmail.com> | 2019-04-01 15:45:17 +0200 |
| commit | 5cc0646e66f52448f83a7a458e0b60b4580e83e5 (patch) | |
| tree | f6c7386b426112fb682699caa7944a580286f0ba | |
| parent | c579ce2306297674c56376a2ab5c8ba66a272253 (diff) | |
| download | wallabag-5cc0646e66f52448f83a7a458e0b60b4580e83e5.tar.gz wallabag-5cc0646e66f52448f83a7a458e0b60b4580e83e5.tar.zst wallabag-5cc0646e66f52448f83a7a458e0b60b4580e83e5.zip | |
Fix index on MySQL
| -rw-r--r-- | app/DoctrineMigrations/Version20190401105353.php | 2 | ||||
| -rw-r--r-- | src/Wallabag/CoreBundle/Entity/Entry.php | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/app/DoctrineMigrations/Version20190401105353.php b/app/DoctrineMigrations/Version20190401105353.php index 94ebb1ab..d27962db 100644 --- a/app/DoctrineMigrations/Version20190401105353.php +++ b/app/DoctrineMigrations/Version20190401105353.php | |||
| @@ -24,7 +24,7 @@ class Version20190401105353 extends WallabagMigration | |||
| 24 | 'notnull' => false, | 24 | 'notnull' => false, |
| 25 | ]); | 25 | ]); |
| 26 | 26 | ||
| 27 | $entryTable->addIndex(['user_id', 'hashed_url'], 'hashed_url_user_id'); | 27 | $entryTable->addIndex(['user_id', 'hashed_url'], 'hashed_url_user_id', [], ['lengths' => [null, 40]]); |
| 28 | } | 28 | } |
| 29 | 29 | ||
| 30 | /** | 30 | /** |
diff --git a/src/Wallabag/CoreBundle/Entity/Entry.php b/src/Wallabag/CoreBundle/Entity/Entry.php index faf4d259..c3fb87d2 100644 --- a/src/Wallabag/CoreBundle/Entity/Entry.php +++ b/src/Wallabag/CoreBundle/Entity/Entry.php | |||
| @@ -26,7 +26,7 @@ use Wallabag\UserBundle\Entity\User; | |||
| 26 | * indexes={ | 26 | * indexes={ |
| 27 | * @ORM\Index(name="created_at", columns={"created_at"}), | 27 | * @ORM\Index(name="created_at", columns={"created_at"}), |
| 28 | * @ORM\Index(name="uid", columns={"uid"}), | 28 | * @ORM\Index(name="uid", columns={"uid"}), |
| 29 | * @ORM\Index(name="hashed_url_user_id", columns={"user_id", "hashed_url"}) | 29 | * @ORM\Index(name="hashed_url_user_id", columns={"user_id", "hashed_url"}, options={"lengths"={null, 40}}) |
| 30 | * } | 30 | * } |
| 31 | * ) | 31 | * ) |
| 32 | * @ORM\HasLifecycleCallbacks() | 32 | * @ORM\HasLifecycleCallbacks() |