From 73079a6cf366b1d1918c5099cbb9d03e5aee60ee Mon Sep 17 00:00:00 2001 From: Christoph Wurst Date: Thu, 5 Dec 2024 17:49:13 +0100 Subject: fix(db): Create the systag_by_objectid index for new installations Signed-off-by: Christoph Wurst --- core/Migrations/Version13000Date20170718121200.php | 2 ++ 1 file changed, 2 insertions(+) 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')) { -- cgit v1.2.3