diff options
author | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2013-02-07 18:20:59 +0000 |
---|---|---|
committer | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2013-02-07 18:20:59 +0000 |
commit | 37a4342bcd0818779975ffbaa2867f90111b0cae (patch) | |
tree | f0bf2f23a63746a4d65b69bfba9d8148d1c71168 /db | |
parent | 36d6caf35f2c8017230d9b7bc84554dc8851a81f (diff) | |
download | redmine-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.rb | 24 |
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 |