From 74d8739936c85b39a483ab50ec3b5c9fec36c8a0 Mon Sep 17 00:00:00 2001 From: Jean-Philippe Lang Date: Thu, 12 Mar 2009 19:49:39 +0000 Subject: [PATCH] Adds a unique index on projects_trackers table (#2882). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2580 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- ...4159_add_projects_trackers_unique_index.rb | 21 +++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 db/migrate/20090312194159_add_projects_trackers_unique_index.rb 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 -- 2.39.5