| @@ -0,0 +1,24 | |||
|
|
1 | class AddUniqueIndexOnCustomFieldsTrackers < ActiveRecord::Migration | |
|
|
2 | def up | |
|
|
3 | table_name = "#{CustomField.table_name_prefix}custom_fields_trackers#{CustomField.table_name_suffix}" | |
|
|
4 | duplicates = CustomField.connection.select_rows("SELECT custom_field_id, tracker_id FROM #{table_name} GROUP BY custom_field_id, tracker_id HAVING COUNT(*) > 1") | |
|
|
5 | duplicates.each do |custom_field_id, tracker_id| | |
|
|
6 | # Removes duplicate rows | |
|
|
7 | CustomField.connection.execute("DELETE FROM #{table_name} WHERE custom_field_id=#{custom_field_id} AND tracker_id=#{tracker_id}") | |
|
|
8 | # And insert one | |
|
|
9 | CustomField.connection.execute("INSERT INTO #{table_name} (custom_field_id, tracker_id) VALUES (#{custom_field_id}, #{tracker_id})") | |
|
|
10 | end | |
|
|
11 | ||
|
|
12 | if index_exists? :custom_fields_trackers, [:custom_field_id, :tracker_id] | |
|
|
13 | remove_index :custom_fields_trackers, [:custom_field_id, :tracker_id] | |
|
|
14 | end | |
|
|
15 | add_index :custom_fields_trackers, [:custom_field_id, :tracker_id], :unique => true | |
|
|
16 | end | |
|
|
17 | ||
|
|
18 | def down | |
|
|
19 | if index_exists? :custom_fields_trackers, [:custom_field_id, :tracker_id] | |
|
|
20 | remove_index :custom_fields_trackers, [:custom_field_id, :tracker_id] | |
|
|
21 | end | |
|
|
22 | add_index :custom_fields_trackers, [:custom_field_id, :tracker_id] | |
|
|
23 | end | |
|
|
24 | end | |
General Comments 0
You need to be logged in to leave comments.
Login now