From bcc70301531b6c3118120173389f2aaa7452bf11 Mon Sep 17 00:00:00 2001
From: GitLab Bot <gitlab-bot@gitlab.com>
Date: Thu, 23 Jul 2020 18:27:09 +0000
Subject: Add latest changes from gitlab-org/gitlab@13-2-stable-ee

---
 ...00715202659_add_index_on_package_files_file_store.rb | 17 +++++++++++++++++
 db/structure.sql                                        |  3 +++
 2 files changed, 20 insertions(+)
 create mode 100644 db/migrate/20200715202659_add_index_on_package_files_file_store.rb

(limited to 'db')

diff --git a/db/migrate/20200715202659_add_index_on_package_files_file_store.rb b/db/migrate/20200715202659_add_index_on_package_files_file_store.rb
new file mode 100644
index 00000000000..92e8364d22c
--- /dev/null
+++ b/db/migrate/20200715202659_add_index_on_package_files_file_store.rb
@@ -0,0 +1,17 @@
+# frozen_string_literal: true
+
+class AddIndexOnPackageFilesFileStore < ActiveRecord::Migration[6.0]
+  include Gitlab::Database::MigrationHelpers
+
+  DOWNTIME = false
+
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_index :packages_package_files, :file_store
+  end
+
+  def down
+    remove_concurrent_index :packages_package_files, :file_store
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index 4cf825da8c9..a1b294e843d 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -19852,6 +19852,8 @@ CREATE INDEX index_packages_maven_metadata_on_package_id_and_path ON public.pack
 
 CREATE INDEX index_packages_nuget_dl_metadata_on_dependency_link_id ON public.packages_nuget_dependency_link_metadata USING btree (dependency_link_id);
 
+CREATE INDEX index_packages_package_files_on_file_store ON public.packages_package_files USING btree (file_store);
+
 CREATE INDEX index_packages_package_files_on_package_id_and_file_name ON public.packages_package_files USING btree (package_id, file_name);
 
 CREATE INDEX index_packages_packages_on_name_trigram ON public.packages_packages USING gin (name public.gin_trgm_ops);
@@ -23862,6 +23864,7 @@ COPY "schema_migrations" (version) FROM STDIN;
 20200712235622
 20200713071042
 20200713152443
+20200715202659
 20200716044023
 20200716120419
 \.
-- 
cgit v1.2.1