20111201201315_add_unique_index_to_issue_relations.rb 621 Bytes
Newer Older
1
class AddUniqueIndexToIssueRelations < ActiveRecord::Migration[4.2]
2 3 4 5 6
  def self.up

    # Remove duplicates
    IssueRelation.connection.select_values("SELECT r.id FROM #{IssueRelation.table_name} r" +
      " WHERE r.id > (SELECT min(r1.id) FROM #{IssueRelation.table_name} r1 WHERE r1.issue_from_id = r.issue_from_id AND r1.issue_to_id = r.issue_to_id)").each do |i|
7
        IssueRelation.where(["id = ?", i]).delete_all
8 9 10 11 12 13 14 15 16
    end

    add_index :issue_relations, [:issue_from_id, :issue_to_id], :unique => true
  end

  def self.down
    remove_index :issue_relations, :column => [:issue_from_id, :issue_to_id]
  end
end