summaryrefslogtreecommitdiff
path: root/db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb
diff options
context:
space:
mode:
authorGitLab Bot <gitlab-bot@gitlab.com>2023-01-18 19:00:14 +0000
committerGitLab Bot <gitlab-bot@gitlab.com>2023-01-18 19:00:14 +0000
commit05f0ebba3a2c8ddf39e436f412dc2ab5bf1353b2 (patch)
tree11d0f2a6ec31c7793c184106cedc2ded3d9a2cc5 /db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb
parentec73467c23693d0db63a797d10194da9e72a74af (diff)
downloadgitlab-ce-05f0ebba3a2c8ddf39e436f412dc2ab5bf1353b2.tar.gz
Add latest changes from gitlab-org/gitlab@15-8-stable-eev15.8.0-rc42
Diffstat (limited to 'db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb')
-rw-r--r--db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb35
1 files changed, 0 insertions, 35 deletions
diff --git a/db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb b/db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb
deleted file mode 100644
index 1109d814ee9..00000000000
--- a/db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb
+++ /dev/null
@@ -1,35 +0,0 @@
-# frozen_string_literal: true
-
-class GroupProtectedEnvironmentsAddIndexAndConstraint < ActiveRecord::Migration[6.0]
- include Gitlab::Database::MigrationHelpers
-
- INDEX_NAME = 'index_protected_environments_on_group_id_and_name'
-
- disable_ddl_transaction!
-
- def up
- add_concurrent_index :protected_environments, [:group_id, :name], unique: true,
- name: INDEX_NAME, where: 'group_id IS NOT NULL'
- add_concurrent_foreign_key :protected_environments, :namespaces, column: :group_id, on_delete: :cascade
-
- add_check_constraint :protected_environments,
- "((project_id IS NULL) != (group_id IS NULL))",
- :protected_environments_project_or_group_existence
- end
-
- def down
- remove_group_protected_environments!
-
- remove_check_constraint :protected_environments, :protected_environments_project_or_group_existence
- remove_foreign_key_if_exists :protected_environments, column: :group_id
- remove_concurrent_index_by_name :protected_environments, name: INDEX_NAME
- end
-
- private
-
- def remove_group_protected_environments!
- execute <<-SQL
- DELETE FROM protected_environments WHERE group_id IS NOT NULL
- SQL
- end
-end