summaryrefslogtreecommitdiff
path: root/db/migrate/20201211042306_add_deployments_finder_by_finished_at_index.rb
diff options
context:
space:
mode:
authorGitLab Bot <gitlab-bot@gitlab.com>2020-12-17 11:59:07 +0000
committerGitLab Bot <gitlab-bot@gitlab.com>2020-12-17 11:59:07 +0000
commit8b573c94895dc0ac0e1d9d59cf3e8745e8b539ca (patch)
tree544930fb309b30317ae9797a9683768705d664c4 /db/migrate/20201211042306_add_deployments_finder_by_finished_at_index.rb
parent4b1de649d0168371549608993deac953eb692019 (diff)
downloadgitlab-ce-8b573c94895dc0ac0e1d9d59cf3e8745e8b539ca.tar.gz
Add latest changes from gitlab-org/gitlab@13-7-stable-eev13.7.0-rc42
Diffstat (limited to 'db/migrate/20201211042306_add_deployments_finder_by_finished_at_index.rb')
-rw-r--r--db/migrate/20201211042306_add_deployments_finder_by_finished_at_index.rb24
1 files changed, 24 insertions, 0 deletions
diff --git a/db/migrate/20201211042306_add_deployments_finder_by_finished_at_index.rb b/db/migrate/20201211042306_add_deployments_finder_by_finished_at_index.rb
new file mode 100644
index 00000000000..f937ff7a436
--- /dev/null
+++ b/db/migrate/20201211042306_add_deployments_finder_by_finished_at_index.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class AddDeploymentsFinderByFinishedAtIndex < ActiveRecord::Migration[6.0]
+ include Gitlab::Database::MigrationHelpers
+
+ DOWNTIME = false
+ INDEX_NAME = "index_deployments_on_project_and_finished"
+
+ disable_ddl_transaction!
+
+ def up
+ add_concurrent_index :deployments,
+ [:project_id, :finished_at],
+ where: 'status = 2',
+ name: INDEX_NAME
+ end
+
+ def down
+ remove_concurrent_index :deployments,
+ [:project_id, :finished_at],
+ where: 'status = 2',
+ name: INDEX_NAME
+ end
+end