From 3548bde384bbd112ffb9d2198856610cb7db12a5 Mon Sep 17 00:00:00 2001
From: Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com>
Date: Thu, 13 Feb 2025 10:35:13 +0100
Subject: chore(filecache): remove index fs_id_storage_size

Index is outdated by PR 50781

Signed-off-by: Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com>
---
 core/Application.php                               |  6 +---
 core/Migrations/Version31000Date20250213102442.php | 37 ++++++++++++++++++++++
 2 files changed, 38 insertions(+), 5 deletions(-)
 create mode 100644 core/Migrations/Version31000Date20250213102442.php

(limited to 'core')

diff --git a/core/Application.php b/core/Application.php
index 79021a46e81..cfd0f90ef24 100644
--- a/core/Application.php
+++ b/core/Application.php
@@ -1,4 +1,5 @@
 <?php
+
 /**
  * SPDX-FileCopyrightText: 2016-2024 Nextcloud GmbH and Nextcloud contributors
  * SPDX-FileCopyrightText: 2016 ownCloud, Inc.
@@ -85,11 +86,6 @@ class Application extends App {
 				'fs_size',
 				['size']
 			);
-			$event->addMissingIndex(
-				'filecache',
-				'fs_id_storage_size',
-				['fileid', 'storage', 'size']
-			);
 			$event->addMissingIndex(
 				'filecache',
 				'fs_storage_path_prefix',
diff --git a/core/Migrations/Version31000Date20250213102442.php b/core/Migrations/Version31000Date20250213102442.php
new file mode 100644
index 00000000000..d267e867129
--- /dev/null
+++ b/core/Migrations/Version31000Date20250213102442.php
@@ -0,0 +1,37 @@
+<?php
+
+/**
+ * SPDX-FileCopyrightText: 2025 Nextcloud GmbH and Nextcloud contributors
+ * SPDX-License-Identifier: AGPL-3.0-or-later
+ */
+namespace OC\Core\Migrations;
+
+use Closure;
+use OCP\DB\ISchemaWrapper;
+use OCP\Migration\Attributes\DropIndex;
+use OCP\Migration\Attributes\IndexType;
+use OCP\Migration\IOutput;
+use OCP\Migration\SimpleMigrationStep;
+
+/**
+ * Drop index fs_id_storage_size
+ *
+ * Added in https://github.com/nextcloud/server/pull/29118
+ * Matching request changed in https://github.com/nextcloud/server/pull/50781
+ */
+#[DropIndex(table: 'filecache', type: IndexType::INDEX, description: 'remove index fs_id_storage_size (concurrent with PRIMARY KEY)')]
+class Version31000Date20250213102442 extends SimpleMigrationStep {
+	public function changeSchema(IOutput $output, Closure $schemaClosure, array $options): ?ISchemaWrapper {
+		/** @var ISchemaWrapper $schema */
+		$schema = $schemaClosure();
+
+		$table = $schema->getTable('filecache');
+
+		// Index added in Version13000Date20170718121200
+		if ($table->hasIndex('fs_id_storage_size')) {
+			$table->dropIndex('fs_id_storage_size');
+		}
+
+		return $schema;
+	}
+}
-- 
cgit v1.2.3