debshots/db/migrate/20130808195123_add_search_index_to_packages.rb

11 lines
384 B
Ruby

class AddSearchIndexToPackages < ActiveRecord::Migration[5.0]
def up
execute "create index packages_name on packages using gin(to_tsvector('english', name))"
execute "create index packages_description on packages using gin(to_tsvector('english', description))"
end
def down
execute "drop index packages_name"
execute "drop index packages_description"
end
end