Sha256: 9c0d08b7177e1b28b0fd987ebc24b43f3718ee976bedf3d7e92b00da447946e8
Contents?: true
Size: 610 Bytes
Versions: 34
Compression:
Stored size: 610 Bytes
Contents
class AddUniqueIndexToIssueRelations < ActiveRecord::Migration
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|
IssueRelation.delete_all(["id = ?", i])
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
Version data entries
34 entries across 34 versions & 1 rubygems