diff options
| author | Christoph Wurst <christoph@winzerhof-wurst.at> | 2021-12-23 11:34:51 +0100 |
|---|---|---|
| committer | Christoph Wurst <christoph@winzerhof-wurst.at> | 2021-12-23 15:51:50 +0100 |
| commit | ed84f07784c2b991cd5adc95f94b04908564afd3 (patch) | |
| tree | 8ac271208d4d2d0fdf70e6aa762117f32a1bff7f /core/Migrations | |
| parent | 29dffd7e7fc84faa6a4317c691c6cac9eaf42f42 (diff) | |
| download | nextcloud-server-ed84f07784c2b991cd5adc95f94b04908564afd3.tar.gz nextcloud-server-ed84f07784c2b991cd5adc95f94b04908564afd3.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')) { |