debian-mirror-gitlab/db/migrate/20230313014038_add_search_index_foreign_key_to_search_namespace_index_assignments.rb
2023-06-20 00:43:36 +05:30

19 lines
543 B
Ruby

# frozen_string_literal: true
class AddSearchIndexForeignKeyToSearchNamespaceIndexAssignments < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
FK_NAME = 'fk_search_index_id_and_type'
def up
add_concurrent_foreign_key :search_namespace_index_assignments, :search_indices,
name: FK_NAME, column: [:search_index_id, :index_type], target_column: [:id, :type], on_delete: :cascade
end
def down
with_lock_retries do
remove_foreign_key :search_namespace_index_assignments, name: FK_NAME
end
end
end