Contents

# frozen_string_literal: true

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

Version data entries

70 entries across 70 versions & 1 rubygems

Version	Path
decidim-proposals-0.29.1	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.28.4	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.27.9	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.29.0	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.28.3	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.27.8	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.29.0.rc4	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.29.0.rc3	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.29.0.rc2	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.29.0.rc1	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.28.2	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.27.7	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.28.1	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.27.6	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.26.10	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.26.9	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.28.0	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.27.5	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.28.0.rc5	db/migrate/20190215113158_use_md5_indexes.rb
decidim-proposals-0.28.0.rc4	db/migrate/20190215113158_use_md5_indexes.rb