db/migrate/20190622161299_use_md5_indexes.decidim_proposals.rb
# frozen_string_literal: true
# This migration comes from decidim_proposals (originally 20190215113158)
class UseMd5Indexes < ActiveRecord::Migration[5.2]
def up
remove_index :decidim_proposals_proposals, name: "decidim_proposals_proposal_title_search"
remove_index :decidim_proposals_proposals, name: "decidim_proposals_proposal_body_search"
execute "CREATE INDEX decidim_proposals_proposal_title_search ON decidim_proposals_proposals(md5(title::text))"
execute "CREATE INDEX decidim_proposals_proposal_body_search ON decidim_proposals_proposals(md5(body::text))"
end
def down
remove_index :decidim_proposals_proposals, name: "decidim_proposals_proposal_title_search"
remove_index :decidim_proposals_proposals, name: "decidim_proposals_proposal_body_search"
add_index :decidim_proposals_proposals, :title, name: "decidim_proposals_proposal_title_search"
add_index :decidim_proposals_proposals, :body, name: "decidim_proposals_proposal_body_search"
end
end