diff .svn/pristine/1a/1ae20ea87464b5769eed93f455558d2b0e19460e.svn-base @ 1464:261b3d9a4903 redmine-2.4

Update to Redmine 2.4 branch rev 12663

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/.svn/pristine/1a/1ae20ea87464b5769eed93f455558d2b0e19460e.svn-base	Tue Jan 14 14:37:42 2014 +0000
@@ -0,0 +1,24 @@
+class AddUniqueIndexOnCustomFieldsProjects < ActiveRecord::Migration
+  def up
+    table_name = "#{CustomField.table_name_prefix}custom_fields_projects#{CustomField.table_name_suffix}"
+    duplicates = CustomField.connection.select_rows("SELECT custom_field_id, project_id FROM #{table_name} GROUP BY custom_field_id, project_id HAVING COUNT(*) > 1")
+    duplicates.each do |custom_field_id, project_id|
+      # Removes duplicate rows
+      CustomField.connection.execute("DELETE FROM #{table_name} WHERE custom_field_id=#{custom_field_id} AND project_id=#{project_id}")
+      # And insert one
+      CustomField.connection.execute("INSERT INTO #{table_name} (custom_field_id, project_id) VALUES (#{custom_field_id}, #{project_id})")
+    end
+
+    if index_exists? :custom_fields_projects, [:custom_field_id, :project_id]
+      remove_index :custom_fields_projects, [:custom_field_id, :project_id]
+    end
+    add_index :custom_fields_projects, [:custom_field_id, :project_id], :unique => true
+  end
+
+  def down
+    if index_exists? :custom_fields_projects, [:custom_field_id, :project_id]
+      remove_index :custom_fields_projects, [:custom_field_id, :project_id]
+    end
+    add_index :custom_fields_projects, [:custom_field_id, :project_id]
+  end
+end