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-12 21:09:20 +0200 |
| commit | 191cc74386b04efe9f691d30d142f66384a3f266 (patch) | |
| tree | f69c6af6960ce7782fef1b844e848118958ea81e | |
| parent | 59a27ceb13b1b6d0e2ba75f921e16141a7c28623 (diff) | |
| download | nextcloud-server-191cc74386b04efe9f691d30d142f66384a3f266.tar.gz nextcloud-server-191cc74386b04efe9f691d30d142f66384a3f266.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 c80b0ba8b8e..ad6962ce06d 100644 --- a/core/Command/Db/AddMissingIndices.php +++ b/core/Command/Db/AddMissingIndices.php @@ -83,12 +83,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')) { |