1 # Copyright (C) The Arvados Authors. All rights reserved.
3 # SPDX-License-Identifier: AGPL-3.0
5 class FullTextSearchIndexes < ActiveRecord::Migration[4.2]
8 "collections" => "collections_full_text_search_idx",
9 "container_requests" => "container_requests_full_text_search_idx",
10 "groups" => "groups_full_text_search_idx",
11 "jobs" => "jobs_full_text_search_idx",
12 "pipeline_instances" => "pipeline_instances_full_text_search_idx",
13 "pipeline_templates" => "pipeline_templates_full_text_search_idx",
14 "workflows" => "workflows_full_text_search_idx",
20 t.classify.constantize.reset_column_information
21 execute "DROP INDEX IF EXISTS #{i}"
22 execute "CREATE INDEX #{i} ON #{t} USING gin(#{t.classify.constantize.full_text_tsvector})"
26 # remove existing fts indexes and create up to date ones with no
28 fts_indexes.keys.each do |t|
34 fts_indexes.each do |t, i|
35 remove_index t.to_sym, :name => i