diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2023-11-14 11:41:52 +0300 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2023-11-14 11:41:52 +0300 |
commit | 585826cb22ecea5998a2c2a4675735c94bdeedac (patch) | |
tree | 5b05f0b30d33cef48963609e8a18a4dff260eab3 /db/post_migrate/20231023113908_add_index_stopping_environments_on_updated_at.rb | |
parent | df221d036e5d0c6c0ee4d55b9c97f481ee05dee8 (diff) |
Add latest changes from gitlab-org/gitlab@16-6-stable-eev16.6.0-rc42
Diffstat (limited to 'db/post_migrate/20231023113908_add_index_stopping_environments_on_updated_at.rb')
-rw-r--r-- | db/post_migrate/20231023113908_add_index_stopping_environments_on_updated_at.rb | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/db/post_migrate/20231023113908_add_index_stopping_environments_on_updated_at.rb b/db/post_migrate/20231023113908_add_index_stopping_environments_on_updated_at.rb new file mode 100644 index 00000000000..01fe32d6bd7 --- /dev/null +++ b/db/post_migrate/20231023113908_add_index_stopping_environments_on_updated_at.rb @@ -0,0 +1,18 @@ +# frozen_string_literal: true + +# See https://docs.gitlab.com/ee/development/migration_style_guide.html +# for more information on how to write migrations for GitLab. + +class AddIndexStoppingEnvironmentsOnUpdatedAt < Gitlab::Database::Migration[2.1] + INDEX_NAME = 'index_environments_on_updated_at_for_stopping_state' + + disable_ddl_transaction! + + def up + add_concurrent_index :environments, :updated_at, where: "state = 'stopping'", name: INDEX_NAME + end + + def down + remove_concurrent_index_by_name :environments, name: INDEX_NAME + end +end |