diff options
| author | Christoph Wurst <christoph@winzerhof-wurst.at> | 2021-12-23 11:34:51 +0100 |
|---|---|---|
| committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2021-12-29 09:16:28 +0000 |
| commit | 3cf98b75e2802149c39c66bff455c7bd8246fcd2 (patch) | |
| tree | eb412fe97cf07202c30650ae9cfee19b3060d16d /core/Migrations | |
| parent | 394915d2e47d231cfd9ba956da35c9770a057749 (diff) | |
| download | nextcloud-server-3cf98b75e2802149c39c66bff455c7bd8246fcd2.tar.gz nextcloud-server-3cf98b75e2802149c39c66bff455c7bd8246fcd2.zip | |
Add missing index for propertypath only queries against properties
Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
Diffstat (limited to 'core/Migrations')
| -rw-r--r-- | core/Migrations/Version13000Date20170718121200.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/core/Migrations/Version13000Date20170718121200.php b/core/Migrations/Version13000Date20170718121200.php index 3d97ee1de39..02864830b2c 100644 --- a/core/Migrations/Version13000Date20170718121200.php +++ b/core/Migrations/Version13000Date20170718121200.php @@ -363,6 +363,7 @@ class Version13000Date20170718121200 extends SimpleMigrationStep { $table->setPrimaryKey(['id']); $table->addIndex(['userid'], 'property_index'); $table->addIndex(['userid', 'propertypath'], 'properties_path_index'); + $table->addIndex(['propertypath'], 'properties_pathonly_index'); } else { $table = $schema->getTable('properties'); if ($table->hasColumn('propertytype')) { |