summaryrefslogtreecommitdiff
path: root/db/post_migrate/20230116090852_add_index_for_project_activity_events.rb
diff options
context:
space:
mode:
authorGitLab Bot <gitlab-bot@gitlab.com>2023-01-17 18:07:17 +0000
committerGitLab Bot <gitlab-bot@gitlab.com>2023-01-17 18:07:17 +0000
commit3fbd6ba74ee268ad739599ae14dcf5c9b6acfc2c (patch)
treeeea3db86df012fd59b4db8c4ec132e494bdac8fb /db/post_migrate/20230116090852_add_index_for_project_activity_events.rb
parentd41edc2e93480db35e48ad770ebe95075fbca871 (diff)
downloadgitlab-ce-3fbd6ba74ee268ad739599ae14dcf5c9b6acfc2c.tar.gz
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'db/post_migrate/20230116090852_add_index_for_project_activity_events.rb')
-rw-r--r--db/post_migrate/20230116090852_add_index_for_project_activity_events.rb15
1 files changed, 15 insertions, 0 deletions
diff --git a/db/post_migrate/20230116090852_add_index_for_project_activity_events.rb b/db/post_migrate/20230116090852_add_index_for_project_activity_events.rb
new file mode 100644
index 00000000000..f0d757ad885
--- /dev/null
+++ b/db/post_migrate/20230116090852_add_index_for_project_activity_events.rb
@@ -0,0 +1,15 @@
+# frozen_string_literal: true
+
+class AddIndexForProjectActivityEvents < Gitlab::Database::Migration[2.1]
+ disable_ddl_transaction!
+
+ INDEX_NAME = 'index_events_for_project_activity'
+
+ def up
+ add_concurrent_index :events, %i[project_id target_type action id], name: INDEX_NAME
+ end
+
+ def down
+ remove_concurrent_index_by_name :events, INDEX_NAME
+ end
+end