Mercurial > hg > soundsoftware-site
view db/migrate/20090312194159_add_projects_trackers_unique_index.rb @ 1478:5ca1f4a47171 bibplugin_db_migrations
Close obsolete branch bibplugin_db_migrations
author | Chris Cannam |
---|---|
date | Fri, 30 Nov 2012 14:40:50 +0000 |
parents | 513646585e45 |
children | 622f24f53b42 |
line wrap: on
line source
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