annotate .svn/pristine/b2/b2da07c5b59f5a76f7942979d584cb5b875f39ed.svn-base @ 1295:622f24f53b42 redmine-2.3

Update to Redmine SVN revision 11972 on 2.3-stable branch
author Chris Cannam
date Fri, 14 Jun 2013 09:02:21 +0100
parents
children
rev   line source
Chris@1295 1 class AddUniqueIndexToIssueRelations < ActiveRecord::Migration
Chris@1295 2 def self.up
Chris@1295 3
Chris@1295 4 # Remove duplicates
Chris@1295 5 IssueRelation.connection.select_values("SELECT r.id FROM #{IssueRelation.table_name} r" +
Chris@1295 6 " 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|
Chris@1295 7 IssueRelation.delete_all(["id = ?", i])
Chris@1295 8 end
Chris@1295 9
Chris@1295 10 add_index :issue_relations, [:issue_from_id, :issue_to_id], :unique => true
Chris@1295 11 end
Chris@1295 12
Chris@1295 13 def self.down
Chris@1295 14 remove_index :issue_relations, :column => [:issue_from_id, :issue_to_id]
Chris@1295 15 end
Chris@1295 16 end