aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorChristoph Wurst <christoph@winzerhof-wurst.at>2024-12-05 17:49:13 +0100
committerbackportbot[bot] <backportbot[bot]@users.noreply.github.com>2024-12-05 18:24:06 +0000
commit9e54aa5216a1f32c5d48a3d07a7c99801260cfd6 (patch)
tree848fe109082ad35cb21b6ea773e88e25d2a6440b
parentc8571e5caec6f9dbc2d05ac431ea5a8ec9a306a8 (diff)
downloadnextcloud-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.php2
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')) {