diff options
| author | Roeland Jago Douma <roeland@famdouma.nl> | 2018-06-03 13:32:49 +0200 |
|---|---|---|
| committer | Roeland Jago Douma <roeland@famdouma.nl> | 2018-06-03 13:36:02 +0200 |
| commit | 2f59f389d2dc5bd701883f8c27b20a6bfc420519 (patch) | |
| tree | efffa478a9f5275709521e3db1d85f0daa4a3df0 | |
| parent | d9238b810a5a01bc229644d06b412025bbaee03d (diff) | |
| download | nextcloud-server-2f59f389d2dc5bd701883f8c27b20a6bfc420519.tar.gz nextcloud-server-2f59f389d2dc5bd701883f8c27b20a6bfc420519.zip | |
Add parent index to share table
Fixes #9327
Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>
| -rw-r--r-- | core/Command/Db/AddMissingIndices.php | 10 | ||||
| -rw-r--r-- | core/Migrations/Version13000Date20170718121200.php | 1 |
2 files changed, 10 insertions, 1 deletions
diff --git a/core/Command/Db/AddMissingIndices.php b/core/Command/Db/AddMissingIndices.php index 82099759366..b30fa43ab39 100644 --- a/core/Command/Db/AddMissingIndices.php +++ b/core/Command/Db/AddMissingIndices.php @@ -84,12 +84,20 @@ class AddMissingIndices extends Command { if ($schema->hasTable('share')) { $table = $schema->getTable('share'); if (!$table->hasIndex('share_with_index')) { - $output->writeln('<info>Adding additional index to the share table, this can take some time...</info>'); + $output->writeln('<info>Adding additional share_with index to the share table, this can take some time...</info>'); $table->addIndex(['share_with'], 'share_with_index'); $this->connection->migrateToSchema($schema->getWrappedSchema()); $updated = true; $output->writeln('<info>Share table updated successfully.</info>'); } + + if (!$table->hasIndex('parent_index')) { + $output->writeln('<info>Adding additional parent index to the share table, this can take some time...</info>'); + $table->addIndex(['parent'], 'parent_index'); + $this->connection->migrateToSchema($schema->getWrappedSchema()); + $updated = true; + $output->writeln('<info>Share table updated successfully.</info>'); + } } if (!$updated) { diff --git a/core/Migrations/Version13000Date20170718121200.php b/core/Migrations/Version13000Date20170718121200.php index 139129eb600..05623e435c3 100644 --- a/core/Migrations/Version13000Date20170718121200.php +++ b/core/Migrations/Version13000Date20170718121200.php @@ -401,6 +401,7 @@ class Version13000Date20170718121200 extends SimpleMigrationStep { $table->addIndex(['file_source'], 'file_source_index'); $table->addIndex(['token'], 'token_index'); $table->addIndex(['share_with'], 'share_with_index'); + $table->addIndex(['parent'], 'parent_index'); } if (!$schema->hasTable('jobs')) { |