diff options
Diffstat (limited to 'db/migrate/20210521073920_drop_devops_adoption_namespace_uniqueness.rb')
| -rw-r--r-- | db/migrate/20210521073920_drop_devops_adoption_namespace_uniqueness.rb | 23 |
1 files changed, 0 insertions, 23 deletions
diff --git a/db/migrate/20210521073920_drop_devops_adoption_namespace_uniqueness.rb b/db/migrate/20210521073920_drop_devops_adoption_namespace_uniqueness.rb deleted file mode 100644 index d255ce844e2..00000000000 --- a/db/migrate/20210521073920_drop_devops_adoption_namespace_uniqueness.rb +++ /dev/null @@ -1,23 +0,0 @@ -# frozen_string_literal: true - -class DropDevopsAdoptionNamespaceUniqueness < ActiveRecord::Migration[6.0] - include Gitlab::Database::MigrationHelpers - - disable_ddl_transaction! - - INDEX_NAME = 'index_analytics_devops_adoption_segments_on_namespace_id' - NEW_INDEX_NAME = 'idx_analytics_devops_adoption_segments_on_namespace_id' - - def up - add_concurrent_index :analytics_devops_adoption_segments, :namespace_id, name: NEW_INDEX_NAME - remove_concurrent_index_by_name :analytics_devops_adoption_segments, INDEX_NAME - end - - def down - # Clean up duplicated records - execute "DELETE FROM analytics_devops_adoption_segments WHERE id NOT IN (SELECT MIN(id) FROM analytics_devops_adoption_segments GROUP BY namespace_id)" - - add_concurrent_index :analytics_devops_adoption_segments, :namespace_id, name: INDEX_NAME, unique: true - remove_concurrent_index_by_name :analytics_devops_adoption_segments, NEW_INDEX_NAME - end -end |