diff options
Diffstat (limited to 'core')
-rw-r--r-- | core/Application.php | 4 | ||||
-rw-r--r-- | core/Command/Db/AddMissingIndices.php | 33 |
2 files changed, 37 insertions, 0 deletions
diff --git a/core/Application.php b/core/Application.php index bda271c41fe..068aa49a84a 100644 --- a/core/Application.php +++ b/core/Application.php @@ -148,6 +148,10 @@ class Application extends App { if (!$table->hasIndex('cards_abid')) { $subject->addHintForMissingSubject($table->getName(), 'cards_abid'); } + + if (!$table->hasIndex('cards_abiduri')) { + $subject->addHintForMissingSubject($table->getName(), 'cards_abiduri'); + } } if ($schema->hasTable('cards_properties')) { diff --git a/core/Command/Db/AddMissingIndices.php b/core/Command/Db/AddMissingIndices.php index d06f27e8449..49fc16b079a 100644 --- a/core/Command/Db/AddMissingIndices.php +++ b/core/Command/Db/AddMissingIndices.php @@ -200,8 +200,23 @@ class AddMissingIndices extends Command { } $output->writeln('<info>Check indices of the cards table.</info>'); + $cardsUpdated = false; if ($schema->hasTable('cards')) { $table = $schema->getTable('cards'); + + if ($table->hasIndex('addressbookid_uri_index')) { + $output->writeln('<info>Renaming addressbookid_uri_index index to to the cards table, this can take some time...</info>'); + + foreach ($table->getIndexes() as $index) { + if ($index->getColumns() === ['addressbookid', 'uri']) { + $table->renameIndex('addressbookid_uri_index', 'cards_abiduri'); + } + } + + $this->connection->migrateToSchema($schema->getWrappedSchema()); + $cardsUpdated = true; + } + if (!$table->hasIndex('cards_abid')) { $output->writeln('<info>Adding cards_abid index to the cards table, this can take some time...</info>'); @@ -213,6 +228,24 @@ class AddMissingIndices extends Command { $table->addIndex(['addressbookid'], 'cards_abid'); $this->connection->migrateToSchema($schema->getWrappedSchema()); + $cardsUpdated = true; + } + + if (!$table->hasIndex('cards_abiduri')) { + $output->writeln('<info>Adding cards_abiduri index to the cards table, this can take some time...</info>'); + + foreach ($table->getIndexes() as $index) { + if ($index->getColumns() === ['addressbookid', 'uri']) { + $table->dropIndex($index->getName()); + } + } + + $table->addIndex(['addressbookid', 'uri'], 'cards_abiduri'); + $this->connection->migrateToSchema($schema->getWrappedSchema()); + $cardsUpdated = true; + } + + if ($cardsUpdated) { $updated = true; $output->writeln('<info>cards table updated successfully.</info>'); } |