diff options
Diffstat (limited to 'db/migrate')
| -rw-r--r-- | db/migrate/20090312194159_add_projects_trackers_unique_index.rb | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/db/migrate/20090312194159_add_projects_trackers_unique_index.rb b/db/migrate/20090312194159_add_projects_trackers_unique_index.rb new file mode 100644 index 000000000..02a8fa68e --- /dev/null +++ b/db/migrate/20090312194159_add_projects_trackers_unique_index.rb @@ -0,0 +1,21 @@ +class AddProjectsTrackersUniqueIndex < ActiveRecord::Migration + def self.up + remove_duplicates + add_index :projects_trackers, [:project_id, :tracker_id], :name => :projects_trackers_unique, :unique => true + end + + def self.down + remove_index :projects_trackers, :name => :projects_trackers_unique + end + + # Removes duplicates in projects_trackers table + def self.remove_duplicates + Project.find(:all).each do |project| + ids = project.trackers.collect(&:id) + unless ids == ids.uniq + project.trackers.clear + project.tracker_ids = ids.uniq + end + end + end +end |