summaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorJean-Philippe Lang <jp_lang@yahoo.fr>2013-02-07 18:20:59 +0000
committerJean-Philippe Lang <jp_lang@yahoo.fr>2013-02-07 18:20:59 +0000
commit37a4342bcd0818779975ffbaa2867f90111b0cae (patch)
treef0bf2f23a63746a4d65b69bfba9d8148d1c71168 /db
parent36d6caf35f2c8017230d9b7bc84554dc8851a81f (diff)
downloadredmine-37a4342bcd0818779975ffbaa2867f90111b0cae.tar.gz
redmine-37a4342bcd0818779975ffbaa2867f90111b0cae.zip
Add unique index on custom_fields_trackers (#13059).
git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@11329 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20130207175206_add_unique_index_on_custom_fields_trackers.rb24
1 files changed, 24 insertions, 0 deletions
diff --git a/db/migrate/20130207175206_add_unique_index_on_custom_fields_trackers.rb b/db/migrate/20130207175206_add_unique_index_on_custom_fields_trackers.rb
new file mode 100644
index 000000000..9977dcd50
--- /dev/null
+++ b/db/migrate/20130207175206_add_unique_index_on_custom_fields_trackers.rb
@@ -0,0 +1,24 @@
+class AddUniqueIndexOnCustomFieldsTrackers < ActiveRecord::Migration
+ def up
+ table_name = "#{CustomField.table_name_prefix}custom_fields_trackers#{CustomField.table_name_suffix}"
+ duplicates = CustomField.connection.select_rows("SELECT custom_field_id, tracker_id FROM #{table_name} GROUP BY custom_field_id, tracker_id HAVING COUNT(*) > 1")
+ duplicates.each do |custom_field_id, tracker_id|
+ # Removes duplicate rows
+ CustomField.connection.execute("DELETE FROM #{table_name} WHERE custom_field_id=#{custom_field_id} AND tracker_id=#{tracker_id}")
+ # And insert one
+ CustomField.connection.execute("INSERT INTO #{table_name} (custom_field_id, tracker_id) VALUES (#{custom_field_id}, #{tracker_id})")
+ end
+
+ if index_exists? :custom_fields_trackers, [:custom_field_id, :tracker_id]
+ remove_index :custom_fields_trackers, [:custom_field_id, :tracker_id]
+ end
+ add_index :custom_fields_trackers, [:custom_field_id, :tracker_id], :unique => true
+ end
+
+ def down
+ if index_exists? :custom_fields_trackers, [:custom_field_id, :tracker_id]
+ remove_index :custom_fields_trackers, [:custom_field_id, :tracker_id]
+ end
+ add_index :custom_fields_trackers, [:custom_field_id, :tracker_id]
+ end
+end