1 # Copyright (C) The Arvados Authors. All rights reserved.
3 # SPDX-License-Identifier: AGPL-3.0
5 class AddOutputNameToCrFtsIndex < ActiveRecord::Migration[4.2]
7 t = "container_requests"
8 i = "container_requests_full_text_search_idx"
9 t.classify.constantize.reset_column_information
10 ActiveRecord::Base.connection.indexes(t).each do |idx|
12 remove_index t.to_sym, :name => i
16 # By now, container_request should have the new column "output_name" so full_text_tsvector
17 # would include it on its results
18 execute "CREATE INDEX #{i} ON #{t} USING gin(#{t.classify.constantize.full_text_tsvector});"
22 t = "container_requests"
23 i = "container_requests_full_text_search_idx"
24 remove_index t.to_sym, :name => i