diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2023-01-18 19:00:14 +0000 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2023-01-18 19:00:14 +0000 |
commit | 05f0ebba3a2c8ddf39e436f412dc2ab5bf1353b2 (patch) | |
tree | 11d0f2a6ec31c7793c184106cedc2ded3d9a2cc5 /db/migrate/20210601080039_group_protected_environments_add_index_and_constraint.rb | |
parent | ec73467c23693d0db63a797d10194da9e72a74af (diff) | |
download | gitlab-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.rb | 35 |
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 |