aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMaxence Lange <maxence@artificial-owl.com>2025-01-15 09:25:18 -0100
committerMaxence Lange <maxence@artificial-owl.com>2025-01-15 09:25:18 -0100
commit5f81fdaabc139fb67050baae7cee74943be86bea (patch)
tree0bb2e229775ae18e58e6f25b74895e57c335bf33
parent0f2dcfd0f184e05387e66515d697b54e708da887 (diff)
downloadnextcloud-server-fix/49638/update-prefs-indexes.tar.gz
nextcloud-server-fix/49638/update-prefs-indexes.zip
fix(missing-index): update preferences tablefix/49638/update-prefs-indexes
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
-rw-r--r--core/Application.php9
1 files changed, 7 insertions, 2 deletions
diff --git a/core/Application.php b/core/Application.php
index d2bcb18bafb..e2315bbf073 100644
--- a/core/Application.php
+++ b/core/Application.php
@@ -203,8 +203,13 @@ class Application extends App {
$event->addMissingIndex(
'preferences',
- 'preferences_app_key',
- ['appid', 'configkey']
+ 'prefs_uid_lazy_i',
+ ['userid', 'lazy']
+ );
+ $event->addMissingIndex(
+ 'preferences',
+ 'prefs_app_key_ind_fl_i',
+ ['appid', 'configkey', 'indexed', 'flags']
);
$event->addMissingIndex(