diff options
author | Christoph Wurst <christoph@winzerhof-wurst.at> | 2024-12-05 17:49:13 +0100 |
---|---|---|
committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2024-12-05 18:24:06 +0000 |
commit | 9e54aa5216a1f32c5d48a3d07a7c99801260cfd6 (patch) | |
tree | 848fe109082ad35cb21b6ea773e88e25d2a6440b | |
parent | c8571e5caec6f9dbc2d05ac431ea5a8ec9a306a8 (diff) | |
download | nextcloud-server-backport/49677/stable30.tar.gz nextcloud-server-backport/49677/stable30.zip |
fix(db): Create the systag_by_objectid index for new installationsbackport/49677/stable30
Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
-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 819eb84f118..fff993f7554 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')) { |