diff options
| author | Christoph Wurst <ChristophWurst@users.noreply.github.com> | 2024-12-05 19:17:54 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-12-05 19:17:54 +0100 |
| commit | bca864d76d1367a978aa0185a1085b6ec54ff6dd (patch) | |
| tree | b649dfd5ec96bb2d871b639fb31f790041ba6ab0 | |
| parent | 41c53648ad18e3a94b6ba18ad0e6c7c09a520bd9 (diff) | |
| parent | 73079a6cf366b1d1918c5099cbb9d03e5aee60ee (diff) | |
| download | nextcloud-server-bca864d76d1367a978aa0185a1085b6ec54ff6dd.tar.gz nextcloud-server-bca864d76d1367a978aa0185a1085b6ec54ff6dd.zip | |
Merge pull request #49677 from nextcloud/fix/db/systag-by-objectid-index-new-installation
fix(db): Create the systag_by_objectid index for new installations
| -rw-r--r-- | core/Migrations/Version13000Date20170718121200.php | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/core/Migrations/Version13000Date20170718121200.php b/core/Migrations/Version13000Date20170718121200.php index b2db87de8fd..9e798f42b47 100644 --- a/core/Migrations/Version13000Date20170718121200.php +++ b/core/Migrations/Version13000Date20170718121200.php @@ -730,6 +730,8 @@ class Version13000Date20170718121200 extends SimpleMigrationStep { $table->setPrimaryKey(['objecttype', 'objectid', 'systemtagid'], 'som_pk'); // $table->addUniqueIndex(['objecttype', 'objectid', 'systemtagid'], 'mapping'); $table->addIndex(['systemtagid', 'objecttype'], 'systag_by_tagid'); + // systag_by_objectid was added later and might be missing in older deployments + $table->addIndex(['objectid'], 'systag_by_objectid'); } if (!$schema->hasTable('systemtag_group')) { |