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